Combine Sheets in Google Sheets

Merge data from two sheets in 5 simple steps

This add-on offers a great opportunity to consolidate data from many spreadsheets into one. Even if your tables differ in formatting, column order, or content, Combine Sheets will perfectly join everything you have in one table using the column headers. You dictate the add-on what sheets to compare, what to do with formatting, and where to put the results in two quick steps:

Combine as many spreadsheets as you need
Use entire sheet or adjust the range manually
Consider Google Sheets limit for 2 million cells
Select spreadsheets from Google Drive
Use the quick search
Transfer the formatting of the original datasets
Review the result in a new spreadsheet, sheet, or a range of your choice

Learn how to work with the add-on.

Try this add-on

for free

When your 30-day trial period expires, you'll be able to order a licensed version.

License: $33.60/year.

Select all the sheets you want to combine

Quickly gather the data from multiple sheets at one place

Our add-on is designed to assemble all the data you need in one place. It combines spreadsheets no matter their formats and contents. All you have to do is simply select all the sheets you want to merge, adjust a couple of settings to your needs, choose where to place the result, and get all the information at hand.

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

A set of options to combine spreadsheets

Choose how to copy the data and where to place the result

The extension for Google Sheets consolidates datasets and puts them one under another. If your tables have headers, just tick off the corresponding option, and the add-on will combine the same columns together. For a better review, you can choose to add an empty row between those datasets that belong to different files. What's more, you decide whether you want to transfer not only data, but also its original formatting.