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

Ablebits.com featured customers
 
Contact us
 
  Publish your message on our support forum
 

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

Ultimate Suite for Excel Professionals
 
 
60+ professional tools for Excel 2016-2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Awesome!!!
Sheila Blanchard
 
 
Excel add-ins and Outlook tools - Ablebits.com