Combine sheets in Google Sheets

Combine 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:

1. Select sheets you want to combine.
2. Select columns to combine.
3. Add extra files from Google Drive if necessary.
4. Adjust settings to your needs.
5. Click Combine.

See a more detailed description here.

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.

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.