App Icon
Consolidate data from numerous Google sheets into one.
Listing updated:November 22, 2021
Works with:
If pulling data from other documents is not enough and you'd rather do some math with all those records, Consolidate Sheets is the add-on to go with. It not only merges multiple Google sheets but also calculates numbers at the same time.

The tool will definitely spare you monotonous copy-pasting and building Pivot tables or QUERY formulas. What's more, you won't have to open each spreadsheet anymore. You just tick off the sheets you'd like to process, specify ranges if necessary, and Consolidate Sheets summarizes data from there. A spe

4 merging options let the tool CONSOLIDATE DATA OF DIFFERENT STRICTURES:

  • consolidate by the header row
  • consolidate by first column labels
  • summarize data by both headers and column labels
  • consolidate by position

11 consolidation functions built into the add-on provide different summary reports: 

As an extra, you will also choose where to place the consolidated data: 
  - new spreadsheet
  - new sheet
  - custom cells within the opened spreadsheet


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 the add-on, please post them here: 
We'll be happy to assist!

Consolidate 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: 

***** V1.1 (5 May 2021) *****
★ New features ★
- Another way to consolidate data – with a formula! Have the result for SUM and COUNT returned as a formula to consolidate all existing and future records from the selected sheets. The formula is always connected to your original files: the resulting calculations will consider all changes and new values automatically. Make sure to visit the help page for more details.

- Now it's possible to consolidate data from just one table.
- Automatically took the existing table as the custom location for the result.
- Minor UX and UI improvements.

- Didn't accept the custom place for the result if entered from the keyboard.
- Threw errors about incorrect ranges even if the sheet was not selected.
- Used to add only up to 10 files from Shared Drive.
- Allowed you to press the final 'Consolidate' button a few times making the tool throw errors.
- In some cases, counted the amounts of data incorrectly, hence, didn't notify about the large selection and extra time needed to process these cells.
- Errored after pressing 'Cancel' in the notification message about the large selection.
- Didn't work if you run the tool from a Chart sheet.
- 'Select range' didn't accept correct ranges after small ones.
Additional information
PricingNot available
Privacy policy
Terms of service
Consolidate Sheets will ask for the permissions shown below. Learn more
Consolidate Sheets will need access to your Google account
This will allow Consolidate 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
Sort by:
Profile Picture
Samson Assefa
December 11, 2020
Samson Assefa Gebrehiwot
Is this review helpful?
Profile Picture
Gurmeet Sodhi
August 17, 2021
Consolidate sheets, great add-on!! made my life little less complicated. Great customer service. we had issue with the function and we reached out by email. we received quick response and also resolved the issue same time. I recommend this Add-On.
Is this review helpful?
1-2 of 2
Clear search
Close search
Google apps
Main menu