Combine Sheets™ Add-on to combine multiple Sheets™ on a click.I
Listing updated:May 27, 2024
Works with:
79K+
Overview
Combine multiple spreadsheets on a click.It automatically retrieves all existing sheets in a file. Easily the sheets that you want to combine and get data appended to existing sheet or create a new file. 

Steps:
Go to Add-ons > Combine Sheets > Start to start. it will automatically look for the sheets in your workbook. then select the sheets you want to combine and hit combine button. using this addon you can either append entire data to the existing sheet or replace existing data with the new data. you can also choose if headers are required from each sheet or just first for consolidating data. 
Additional information
PricingFree of charge
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 :
View and manage spreadsheets that this application has been installed in
Display and run third-party web content in prompts and sidebars inside Google applications
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
Kaan Demiroz
December 2, 2024
Works for me, but it copies the first row (header) from all selected sheets instead of just once at the top. And if I check "Skip first row (header)", it skips from all sheets. It would be nice to have an option to keep the header but not duplicate it if all sheets have the header.
Is this review helpful?
Yes
No
Profile Picture
Joseph Pipkin
October 29, 2024
It worked mostly, but doesn't seem to be able to recognize dates. By the time I finished editing it wasn't it.
Is this review helpful?
Yes
No
Profile Picture
Valeria Torres
March 7, 2024
Having the same issue as another reviewer, it says it needs to be authorized, I'm only trying to combine 7 sheets. Doesn't tell me how to authorize it, it's been properly installed.
Is this review helpful?
Yes
No
Profile Picture
Tanya Bakken
April 21, 2024
keeps saying error about authorization. Dang it .
Is this review helpful?
Yes
No
Profile Picture
Dallas Turner
May 17, 2024
It works, slowly at times, but it works.
Is this review helpful?
Yes
No
Profile Picture
BLUE14 Products
September 23, 2021
Looks like exactly what I need, but issue with installation. Error: undefined:Authorisation is required to perform that action. App has been authorised - tried uninstalling/reinstalling, and still nothing. Shame UPDATE: got it working in Chrome - but limited to 15 sheets, so won't work for me. Shame
Is this review helpful?
Yes
No
1-6 of 6
Search
Clear search
Close search
Google apps
Main menu