App Icon
Ablebits
•  531,493
Overview
Combine data from multiple sheets into one sheet.
This add-on pulls data from numerous spreadsheets into one as values or as a formula in just two quick steps. Even if your tables differ in column order, contents, or formatting, Combine Sheets will perfectly join everything you have in one table by common column headers.

GET THE AUTO-UPDATED RESULT
The add-on can combine sheets using a formula. This way, your result will be in-sync with the source tables, and all changes made in original sheets will be reflected in the result automatically. Try it yourself and you won't regret it.
 
PERKS OF COMBINE SHEETS
 • Combine as many spreadsheets as you need
 • Add sheets from Google Drive using the quick search field
 • Pull data from the entire sheet or adjust the range manually
 • Keep the formatting of the original datasets
 • Put the result to a new spreadsheet, sheet, or cells of your choice
 • Separate combined sheets with empty rows for better navigating
 • Consider Google Sheets limit for 5 million cells

30 DAYS OF FREE USE
Fully functional 30-day trial period. All payments are secure and include an unconditional 30-day money-back guarantee.

If you have any questions about consolidating data from many Google Sheets, please post them here:
https://www.ablebits.com/docs/google-sheets-combine-multiple-sheets/
We'll be happy to assist!

Combine Sheets is a proud member of the Ablebits product family. We build add-ons that help you make the most of Google Workspace. Visit our official website to learn more:
https://www.ablebits.com/google-sheets-addons.php
–––––––––––––––––––––––––––––––––––––
WHAT'S NEW

***** V1.4 (5 May 2021) *****
Improved:
- Performance improvements in processing large amounts of data.
- Minor UX and UI improvements.

Fixed:
- Didn't accept custom ranges entered from the keyboard.
- Didn't work if you chose to preserve formatting but one of your tables contained headers with blank colored rows.
- Minor UX issues.

***** V1.3 *****
★ New features ★
- One more way to combine data – with a formula! 
Have the add-on build a formula to join all existing and future records from the chosen sheets together. The formula is always connected to your original files. Hence, all source changes, all new cells, rows and columns will appear in the combined table automatically. Make sure to visit the help page for more details.

Improved:
- Minor UX improvements.

Fixed:
- In some cases, the add-on couldn't combine lots of spreadsheets and fired error. Now it offers you to try and process data again or email our customer support service.
- Couldn't add files from Drive if they were previously excluded from the add-on tree-view.
- Used to add only up to 10 files from Shared Drive.
- Minor UI issues.

***** V1.2 *****
Improved:
- When picking spreadsheets from Drive, files and folders are now sorted A>Z.
- The limit for cells has been increased to 5M cells.
- UI: elements don't overlap anymore for DPI 200%.

Fixed:
- The add-on counted the resulting cells incorrectly and exceeded the limit for 5M cells every time the option 'Consider table headers' was not selected.
- Didn't work with a one-column range if 'All data' was selected to combine.
- Accepted the incorrect range for a custom location for the results.

***** V1.1 *****
Fixed:
- Wrong selected range if server response time was slow.
- Modifying date format after combining.
- The message "The entered range is incorrect" kept showing even after the range was corrected.
- Minor UI issues.
Reviews
Language:
Sort by:
Profile Picture
Robert Malone
March 24, 2021
This 5 Star review is based on the support that I received during a 30-day free trial subscription to Combine Sheets. As a free-trial subscriber, I had little expectation of such excellent support. The response to a problem I encountered was prompt, detailed, to the point, and readily solved my problem. As a result of this support experience, I am likely to subscribe to the Power Tools suite of Sheets add-ons.
Is this review helpful?
Yes
No
Profile Picture
Jacob White
February 12, 2021
Very powerful and extremely useful. I am quite satisfied.
Is this review helpful?
Yes
No
Profile Picture
Abhishek Srivastava
February 3, 2021
Works well as described. One suggestion. There should be an option to copy data in the combined sheets as links to the original sheets. This will ensure that the data in the combined sheet is dynamic, so whenever there is a change in the original sheets, the combined sheet reflects the change as well.
Is this review helpful?
Yes
No
Profile Pciture
Ablebits team
February 4, 2021
Thank you for your feedback, Abhishek, The feature you suggested is already available. On step2, select the option to combine data as a formula. The resulting table will then be always connected to original files and change accordingly. Please watch the video and take a look at the add-on help page for details.
Profile Picture
Matt Rebeiro
January 15, 2021
Does what if says right there in the name!
Is this review helpful?
Yes
No
Profile Picture
Samson Assefa
December 1, 2020
Samson Assefa Gebrehiwot
Is this review helpful?
Yes
No
Profile Picture
Hudson Atwell
November 27, 2020
Amazing tool. Would like to request that combined sheets be filterable.
Is this review helpful?
Yes
No
Profile Pciture
Ablebits team
January 26, 2021
Thank you for your feedback, Hudson! We've added your feature request to our roadmap. As soon as it is available, we'll be sure to let you know.
Profile Picture
Pete Greenquist
November 13, 2020
Just tried this for the first time and I have to say, it is my new favorite. I have a shared sheet with 40 tabs that I need to combine once/month and this is a lifesaver. Purchasing the full subscription ASAP.
Is this review helpful?
Yes
No
Profile Picture
Ian Taylor
October 21, 2020
Really useful, makes combining sheets a breeze. The common headers feature was exactly what I was looking for. If I had a request, it would be to only include common headers in the output and ignore others, or to make header selection possible as you can in Merge Sheets. To get more advanced, the ability to select which columns match would be nice - sometimes I had to edit column names as they differed but the data was similar (e.g. Plays vs Views).
Is this review helpful?
Yes
No
Profile Picture
Ravi C Varanasi
September 2, 2020
Can I merge as follows: Sheet 1 has columns A, B, and C Sheet 2 has columns A, B, and C Sheet 3 has columns A, B, C, D Merged Sheet 4 should have columns A, B, C, D, E, F, G, H, I, and J. (Sheet 1 columns followed by Sheet 2 columns followed by Sheet 3 columns)
Is this review helpful?
Yes
No
Profile Pciture
Ablebits team
September 3, 2020
Thank you for your question. Yes, if you do no select the option to consider common headers, the add-on will simply add the next table to new columns.
Profile Picture
Mohammed Al-Shammaa
August 29, 2020
It would be useful to add an option for adding a column in the combined sheet that contains the original sheet names
Is this review helpful?
Yes
No
Profile Pciture
Ablebits team
August 31, 2020
Thank you for your feedback, Mohammed. The feature is already in our development list. I've added your name to it as well so we could let you know when it's available.
1-10 of 22
Additional information
Ablebits
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu