Combine sheets in Google Sheets

Combine data from multiple sheets into one sheet

This add-on pulls data from multiple Google spreadsheets into one without copy-pasting. Even if your tables differ in formatting, column order or contents, Combine Sheets will join your sheets to one table using column headers. You tell the tool what sheets to merge, what to do with formatting & where to put the results in just 2 steps. And it's up to you to have the outcome as a formula so it updates in sync with the source sheets.

Try it for 30 days for free
Сombine Sheets add-on for Google Sheets

With Combine Sheets you will

  • Combine as many Google sheets as you need As long as you don't exceed the Google Sheets limit for 10 million cells.
  • Merge data from common columns based on their headers The order of columns is not important — the add-on detects common labels.
  • Select spreadsheets to join from Google Drive Use a quick search to import data from another Google sheet without opening it.
  • Adjust the ranges to merge Go with the entire sheet or select a particular range manually.
  • Import extra Google sheets to the existing result later With a special option that adds more sheets to the previously combined data.
  • Have the result update automatically Join tables with a formula so the outcome changes along with source sheets.
  • Choose a place for the resulting table Review the result in a new spreadsheet, extra sheet, or a range of your choice.
  • Preserve the formatting of the tables Pull data from another Google sheet with its original formatting.

How to combine data in Google Sheets

Use Quick Search to swiftly look for other spreadsheets
Use Quick Search to swiftly look for other spreadsheets
Tick off entire spreadsheets or certain sheets to bring them together
Tick off entire spreadsheets or certain sheets to bring them together
Select additional options
Select additional options
Combine data from multiple Google sheets in a place of your choice
Combine data from multiple Google sheets in a place of your choice
Import additional Google sheets to your existing result later
Import additional Google sheets to your existing result later
Merge Google sheets using a formula – the result will update in sync with the original sheets
Merge Google sheets using a formula – the result will update in sync with the original sheets
Combine data from multiple sheets based on common headers.
Combine data from multiple sheets based on common headers.

License benefits

Our customers get

Unconditional
30-day money-back guarantee
Free support
Volume discounts: the more you buy, the less you pay

These companies choose Ablebits products

Frequently asked questions

What is Combine Sheets and what do I need it for?

Our add-on is designed to quickly pull data from multiple tabs into one in Google Sheets. It merges spreadsheets no matter their formats and contents and organizes all records into a well-constructed table. Per your request, this tool for Google Sheets joins tables as a formula – so your result updates each time the data in source sheets changes.

Combine Sheets also recognizes and merges the same columns if necessary. For a better review, you can choose to add an empty row between the datasets that belong to different files. And you decide whether you want to transfer not only the data but also its original formatting.

I think I can transfer ranges without any add-ons, can't I?

Yes, but it won't be easy.

One way is to copy-paste the tables between sheets manually… which is hardly convenient when you need to combine data from multiple sheets into one sheet.

Another way is to use the Google Sheets IMPORTRANGE function. But for a proper reference, you'll have to open each spreadsheet and retrieve its URL, sheet name, and the exact range. The formula, however, won't preserve source formatting; neither will it apply the existing format from the current sheet. Also, for each new range it will ask for your permission to connect sheets.

It's much easier with our tool. You just tick off the sheets to join, decide on saving formatting, choose a place for the result, and voila! — the tables are brought together. Even if you decide to merge Google sheets with a formula, the add-on will build it for you and provide all buttons to connect the sheets in one place.

So how do I combine Google sheets?

Run the add-on from the Extensions menu and follow the steps:

  1. Select those sheets or entire spreadsheets you want to consolidate.
  2. Add extra files from Google Drive if necessary.
  3. Adjust a couple of settings to your needs.
  4. Click Combine.

See a more detailed description here.

Will the result change as well if the data in my source sheets changes?

Yes, if you make the add-on pull data from the sheets using a formula. You'll see this setting in the second step.

Columns in my tables differ in order and quantity. Will your add-on manage that?

Of course.

There's no need to prepare the data beforehand since the order of columns is not important. Combine Sheets merges values from identically named columns into one. Other columns are added to the same table, allowing the add-on to create a single report out of the scattered data.

Will my tables lose all the formatting after the merge?

No, a special extra option lets you import the formatting of each range along with the values.

How many sheets can I combine with your add-on?

As many as you need — just consider the Google Sheets limit for 10 million cells.

Choose your plan

12-month

  • 12-month access with all updates
$33.60
$19.99
Buy now

Lifetime

  • Get all new features and updates for free ever!
$59.90
Buy now

System requirements

Operating Systems

  • Microsoft: Windows 7 and up
  • Mac: High Sierra 10.13 and up
  • Chrome OS™

Browsers

  • Chrome™
  • Firefox
  • Safari (Mac only)