Help & Support
Send Feedback
Combine Sheets
Combine data from multiple sheets into one sheet
23 users
Works with
Install
Overview
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?
Version 1.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!
Please visit the Chrome Web Store if you would like to reply or rate a review for this app.
Reviews
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!
Submit reply
Cancel
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.
Submit reply
Cancel
January 24, 2018
Solution that solve the combining multiple gsheet
Submit reply
Cancel
December 19, 2017
The best solution for joining data!
Submit reply
Cancel
1-4 of 4
Additional information
Search
Clear search
Close search
Google apps
Main menu