Combine data from multiple sheets into one sheet.
Listing updated:August 30, 2024
Works with:
978K+
Overview
This add-on pulls data from numerous spreadsheets into one as values or as a formula in just 3 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 the 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
  β€’ Include extra sheets to the existing result at any time
  β€’ Add sheets from Google Drive using the quick search field
  β€’ Pull data from the entire sheet or adjust the range manually
  β€’ Pick columns to combine if needed
  β€’ 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 or sheet names for better navigation
  β€’ Add sheet names to the result to identify the source of each combined table

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.7 (30 Aug 2024) *****
β˜… New features β˜…
- You can now select columns to combine. Make the add-on auto-detect common columns across the sheets or pick desired columns manually.
- Optionally have sheet names in a new column to the right of your result table so you always have an idea where that data came from.

Improved:
- Pulls notes associated with cells to the result as well.
- When combining as values, the result will inherit some formatting of the original cells: vertical alignment, column width, row height, wrapping, and data validation.
- Minor UX and UI improvements.

Fixed:
- If there were 3 or more columns with identical headers, their content could get lost in the result.
- Cut zeros and leading spaces from the names of the combined sheets on the 'Connect files to IMPORTRANGE' sheet.
- Couldn't process data that contained some non-printing characters.
- Couldn't process sheets that had a plus symbol (+) in their names.

***** V1.6 (23 December 2023) *****
Improved:
- When you add sheets to the result using a formula, they are now being added to the end of the whole table.
- It's now possible to look for the files in the folder with Starred items of your Drive.
- The limit for total cells in a spreadsheet is expanded to 10 million cells.
- Minor UX improvements.

Fixed:
- The option 'Add to the result' replaced the existing formula instead of updating it.
- Treated the same headers written in different cases as distinct ones and didn't combine them.
- Unlike the formula, treated different columns with blank headers as distinct ones.
- Changed the Date format in the combined data.
- Couldn't locate spreadsheets in Drive if your search name started with an apostrophe.
- The add-on couldn't paste data into the file without a set time zone.

***** V1.5 (18 October 2021) *****
β˜… New features β˜…
- Quickly add more files to the existing result with a corresponding new option. No need to combine all sheets all over again. Just select the new sheets you want to add to the result and the result itself. Select the previously combined data as the one to update and the add-on will do the rest. Visit the help page for all the details.

Improved:
- Significant performance improvements in processing large amounts of data.
- Minor UX improvements.

Fixed:
- Placing the resulting formula into your custom location removed existing conditional formatting, Data validation rules and comments.

***** 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
PricingFree of charge trial
Developer
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:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Meghan Jackson
September 1, 2024
It works, but if you have an image in cell, the images will not be copied over into the combined document. I was looking for something that can do more than what I can do via copy and paste myself.
Is this review helpful?
Yes
No
Profile Picture
Roger Moh
October 3, 2024
Works good and well. Unfortunately, I can't afford the subscription :'(
Is this review helpful?
Yes
No
Profile Picture
muchira
August 5, 2024
Worked like a charm! Very helpful! Thank you
Is this review helpful?
Yes
No
Profile Picture
Matt Marshall
July 15, 2024
In app purchases? To combine two google sheets? Come on.
Is this review helpful?
Yes
No
Profile Picture
favourite readymade garments
April 30, 2024
good for working
Is this review helpful?
Yes
No
Profile Picture
ritik srivastava
January 21, 2024
Doesn't work properly
Is this review helpful?
Yes
No
Profile Picture
Michael Powell
August 28, 2024
cant find it after installing
Is this review helpful?
Yes
No
Profile Picture
Laura Hambleton
October 12, 2022
Although there are limitations (I had to break my spreadsheet into three and then combine them into one from there because of the large amount of data) this app is super. You are able to set up a dynamic flow so your information updates on your master (combined) sheet, which in my case reduces the chance for copy and paste errors. The customer service was super, knowledgeable, and fast when I tried to use the program the first time and encountered errors (due to the large data amount) and helped me with a work around that was successful. I would recommend this product to others.
Is this review helpful?
Yes
No
Profile Picture
Kevin Townsend
June 20, 2023
An excellent piece of software that's sold a multitude of problems, particularly when trying to integrate with Looker Studio.
Is this review helpful?
Yes
No
Profile Picture
Ed Soniat
February 5, 2023
Shows up as a managed app but there is no item on the tool bar to access it. I can find no way to run this app. Free trail is a fail.
Is this review helpful?
Yes
No
1-10 of 35
Search
Clear search
Close search
Google apps
Main menu