How to combine Google Sheets?

Two simple steps to combine data from multiple sheets into one sheet

Get the add-on

This tutorial shows how to use the Combine Sheets add-on to join tables in multiple sheets together.

Start from running the add-on from Google Sheets menu: Add-ons > Combine Sheets > Start.

Run the add-on from Google Sheets menu

Step 1: Select all the sheets you want to combine

On this step you select those spreadsheets you want to combine.

Select sheets you want to combine

Moreover, if some sheets have extra data, you'll be able to specify the range of interest. To do that, click All data next to the sheet name and do one of the following:

  • Type the range.
  • Click the table symbol and select the range from the sheet manually.
  • Click the table symbol, select any cell within your table, and click Auto select. This will automatically pick the whole table range.
Select the needed range manually
Note. Please bear in mind that Google Sheets limits the total number of possible cells in your file up to 2 million cells.

Click Add files from Drive to import and use more files.

If you add a spreadsheet by mistake, select the file and click the Exclude button.

Tip. You can add a few files at a time. Just click their names to see them highlighted in light-blue. Click Add to work with these files or click them once again to cancel the choice. Add more sheets to consolidate

If you remember the name of a spreadsheet you need, use the quick search field to find it.

When the sheets you want to work with are selected, click Next. To finish working with the add-on, click Close.

Step 2: Fine tune the options to combine spreadsheets into one correctly

The add-on lets you personalize the way it's going to consolidate data.

Select additional options

Choose how you need to transfer data from the sheets

You can adjust the way the data will be pulled using the following preferences:

  • If your data contain similar columns arranged in different ways, check the option Consider table headers. This will allow the add-on to consolidate worksheets based on their headers.
  • If you need to save the original look of each table, check the option to Preserve formatting.
  • The second option, Separate the copied ranges by a blank row, will add an empty row between the tables so that you could easily find where one range ends and the next begins.

See where you want to put the results:

  • By selecting New spreadsheet, you decide to review the resulting table from a new file. Combine Sheets will create it automatically.
  • If you select New sheet, the add-on will add your output table to a new sheet within the opened file.
  • In case you want to put the combined data to a particular place in a spreadsheet, select Custom location and enter or select the leftmost cell of the future joined table.

Click Combine to consolidate data.

If you want to select other sheets or add a few more, click Back. To exit the add-on, click Close.

Enjoy the result

At the end, you will see the message saying how many sheets have been combined. Click Close to exit the add-on and see the result – your data collected together in a new place according to the options you selected.

See the result message when combining is over
Tip. If you chose to put the results to a new spreadsheet on step 2, the add-on will offer you a link to open the new file right away.

If you have any questions left or experience any difficulties with the add-on, please use the form below to let us know. We'll be happy to assist you.

Featured customers featured customers
Contact us

Our working hours: 0am to 10am PST; 3am to 1pm EST; 8am to 6pm CET.

Ultimate Suite 2018.3 Summer Offer
Excel add-ins and Outlook tools -