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
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.
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.
Run the add-on from the Extensions menu and follow the steps:
See a more detailed description here.
Yes, if you make the add-on pull data from the sheets using a formula. You'll see this setting in the second step.
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.
No, a special extra option lets you import the formatting of each range along with the values.
As many as you need — just consider the Google Sheets limit for 10 million cells.