App Icon
Combine data from multiple sheets into one sheet.
Works with:
606,323
Overview
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.
Additional information
Privacy policy
Terms of service
Combine Sheets will ask for the permissions shown below. Learn more
Combine Sheets will need access to your Google account
This will allow Combine Sheets to :
See, edit, create, and delete all of your Google Drive files
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Profile Picture
A User of Combine Sheets
November 30, 2018
Saves so much time. Really excellent. For one large project I received a message that the Combine Sheets function could not accommodate the number of sheets/amount of data. Aside from that, it has been a great tool. Thank you!
Is this review helpful?
Yes
No
Profile Picture
A User of Combine Sheets
September 8, 2019
When I try to combine tabs I just get "Ranges from 0 sheets have been successfully combined." I think its a user issue but any help would be great. Cheers
Is this review helpful?
Yes
No
Profile Picture
A User of Combine Sheets
December 19, 2017
The best solution for joining data!
Is this review helpful?
Yes
No
Profile Picture
A User of Combine Sheets
September 16, 2018
Amazing tool..!! Thank you so much for making this. Combines excel sheets as promised. Easy step by step process. Trial for 30 days only.
Is this review helpful?
Yes
No
Profile Picture
A User of Combine Sheets
May 9, 2019
Amazing! Also support is very helpful!
Is this review helpful?
Yes
No
Profile Picture
Shirley Wong
January 24, 2018
Solution that solve the combining multiple gsheet
Is this review helpful?
Yes
No
Profile Picture
Matt Rebeiro
January 15, 2021
Does what if says right there in the name!
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 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 Picture
A User of Combine Sheets
April 9, 2020
GOOD FOR WHAT I AM GOING TO DO.
Is this review helpful?
Yes
No
1-10 of 22
Search
Clear search
Close search
Google apps
Main menu