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.

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.



Screenshots

Run the add-on from Google Sheets menu
Select all the sheets you want to combine
Choose how to copy the data and where to place the result
See the result message when combining is over

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