Combine data from multiple sheets into one sheet
This add-on combines multiple Google sheets into one without copy-pasting. Even if your tables differ in formatting, column order or contents, Combine Sheets will use column headers to join your sheets correctly. In just 3 steps, you tell the tool what sheets & columns to join, what to do with formatting, and where to put the results. And it's up to you to have the outcome as a formula that updates in sync with the source sheets.
Try it for 30 days for freeCombine Sheets is a special extension designed to quickly pull data from multiple tabs into one in Google Sheets. It joins tables no matter their formats and contents, and organizes all records into a well-constructed table. This tool can combine Google Sheets as a formula – so your result updates each time source data 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.
You can now also select specific columns to combine, and add source sheet names in new columns or between the ranges so you always know where each data set comes from.
Yes, but it's cumbersome.
One way is to copy-paste manually… which is hardly convenient when you need to combine data from multiple Google sheets into one sheet.
Another way is to use the Google Sheets IMPORTRANGE function. But you'll have to open each spreadsheet and retrieve its URL, sheet name, and exact range. And it still won't preserve formatting.
Our extension simplifies the process. You just select the sheets & columns to combine, decide on saving formatting, choose a place for the result, and voila! — the sheets are brought together. It can also build the necessary formulas to import ranges from other sheets and help you connect sheets :)
Run the add-on from the Extensions menu and follow the steps:
See a more detailed description here.
Combine Sheets will sort the result by multiple columns for you. Just specify the columns to sort by on the last step.
Yes, but we suggest you make the add-on use IMPORTRANGE formulas to join Google Sheets. You'll see this setting on the third step. This way, your result sheet will always be up-to-date.
Scenarios let you save the settings you’ve used to combine your sheets and reuse them in just one click. If you often work with the same data or follow similar combining setups, scenarios will help you avoid repeating the process.
Once a scenario is saved, you can start it from the Scenarios menu to instantly combine data from selected sheets with your predefined settings.
Yes, you can export scenarios as files and share them with your teammates or even across your own Google accounts. Importing a shared scenario is just as easy: load the file into the add-on, and it will appear in your Scenarios menu.
You can have the name of the source sheets either in a new column to the right or at the beginning of each new range (separate the ranges with the sheet names).
Absolutely.
There's no need to prepare the data beforehand since the column order is unimportant. Combine Sheets merges values from identically named columns into one. Other columns are added to the same table creating a comprehensive report from the scattered data.
You can now select specific columns to combine :) The add-on will show you how many selected sheets have this or that column to help you decide.
No, you can choose to import the formatting of each range along with the values.
You can combine as many Google sheets as you need — just consider the spreadsheet limit for 10 million cells.