Ablebits
•  120,846
Overview
Combine data from multiple sheets into one sheet
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 combine, what to do with formatting, and where to put the results on two quick steps.

· Combine as many spreadsheets as you need
· Add sheets from Google Drive using quick search field
· Use entire sheet or adjust the range manually
· Transfer the formatting of the original datasets
· Review the result in a new spreadsheet, sheet, or a range of your choice
· Consider Google Sheets limit for 2 million cells

What's more, you can separate combined sheets with empty rows. This way you'll be able to scan through the consolidated data easily and work with it faster. Try it yourself and you won't regret it.

What's new?
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.

If you have any questions about consolidating data from many Google Sheets, please post them here: https://www.ablebits.com/docs/howto-combine-google-sheets/
We'll be happy to assist!
Reviews
Language:
Sort by:
A User of Combine Sheets
April 9, 2020
GOOD FOR WHAT I AM GOING TO DO.
Is this review helpful?
Yes
No
A User of Combine Sheets
March 31, 2020
I've paid for this but it still isn't showing up in my Add On menu. On this page it says it's installed but I'm unable to locate it.
Is this review helpful?
Yes
No
A user of Combine Sheets
April 9, 2020
GOOD FOR MY FUN
A user of Combine Sheets
April 9, 2020
YES IT HAS
A user of Combine Sheets
April 1, 2020
Hello, Sorry to hear you can't find the add-on. Please email our support team with the screenshots of the problem, we'll help you install it correctly. To contact us, just click the Website link at the bottom of this page and go the Support tab. Thank you.
A User of Combine Sheets
February 20, 2020
Does it work with Sheets on an Android device?
Is this review helpful?
Yes
No
A user of Combine Sheets
February 21, 2020
Hello, Combine Sheets is designed to work in desktop browsers. If you use a special Google Sheets app, you won’t find our add-on there since we haven’t created it for the app.
A User of Combine Sheets
January 15, 2020
Very useful tool. Will it be possible to save steps used for frequent consolidation? It will reduce routine tasks of running combining in case of selecting one particular spreadsheet or range from multiple sheets.
Is this review helpful?
Yes
No
A user of Combine Sheets
January 16, 2020
Hello, I will forward your feedback to our dev team for consideration. If it's technically possible, we'll add it to our list of features to implement. Thank you.
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
A User of Combine Sheets
May 9, 2019
Amazing! Also support is very helpful!
Is this review helpful?
Yes
No
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
A user of Combine Sheets
December 5, 2018
Thank you very much for your feedback, Ann! Just wanted to let you know that our add-on don't impose any additional limitations. It looks like you simply encountered the limit for 2 million cells in Google Sheets. If this problem occurs in the future, don't hesitate to email us to support@ablebits.com, we'll investigate the issue.
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
Shirley Wong
January 24, 2018
Solution that solve the combining multiple gsheet
Is this review helpful?
Yes
No
A User of Combine Sheets
December 19, 2017
The best solution for joining data!
Is this review helpful?
Yes
No
1-10 of 10
Additional information
Ablebits
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu