рдЦреЛрдЬреЗрдВ
рдЦреЛрдЬ рд╣рдЯрд╛рдПрдВ
рдЦреЛрдЬ рдмрдВрдж рдХрд░реЗрдВ
рдореБрдЦреНрдп рдореЗрдиреНрдпреВ
Google рдРрдк
App Icon
Combine data from multiple sheets into one sheet.
рдмрдирд╛рдиреЗ рд╡рд╛рд▓реА рдХрдВрдкрдиреА:
рд▓рд┐рд╕реНрдЯрд┐рдВрдЧ рдХреЛ рдкрд┐рдЫрд▓реА рдмрд╛рд░ рдЕрдкрдбреЗрдЯ рдХрд┐рдпрд╛ рдЧрдпрд╛:21 рдлрд╝рд░рд╡рд░реА 2025
рдЗрдирдХреЗ рд╕рд╛рде рдХрд╛рдо рдХрд░рддрд╛ рд╣реИ:
10 рд▓рд╛рдЦ+
рдЕрд╡рд▓реЛрдХрди
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
  тАв Sort the combined result by multiple columns
  тАв Keep the formatting of the original datasets
  тАв Put the result into  an existing or new file, 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

ЁЯТ╛ SAVE TIME WITH SCENARIOS
If you frequently combine the same data, save your preferred settings as scenarios to skip repetitive steps. Simply create, name, and run a scenario to combine your data instantly.

ЁЯСе SHARE SCENARIOS WITH YOUR TEAM
Export your scenarios to share with your team or across accounts, and import shared scenarios to start combining data using preconfigured settings immediately.

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-add-ons/index.php
тАУтАУтАУтАУтАУтАУтАУтАУтАУтАУтАУтАУтАУтАУтАУтАУтАУтАУтАУтАУтАУтАУтАУтАУтАУтАУтАУтАУтАУтАУтАУтАУтАУтАУтАУтАУтАУ
WHAT'S NEW
***** V1.8 (04 Feb 2025) *****
тШЕ New features тШЕ
- Sort the result. Whether you combine data with or without a formula, you can have the result sorted by any number of columns A>Z or Z>A.
- Scenarios. Save the options you use most often and give this set a name тАУ this is your scenario. Once you run it, your data will be processed right away, and you won't need to go over the same steps again.
- Share saved scenarios. Export and import your saved scenarios to share them with your teammates or just make their backups on your Drive or computer.
- New place for your resulting files: browse your Drive and pick a certain folder.

Improvements:
- The formula ignored sheets that didn't have the required columns. Now these sheets are included in the result in case the required data appears in future.
- Combine even more sheets using the formula since we adjusted it so it's harder to reach the limit for 50k characters for formulas.
- Minor UX improvements.

Fixed:
- The formula didn't work if empty sheets were included in the result for possible future use.

***** 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.
рдЕрддрд┐рд░рд┐рдХреНрдд рдЬрд╛рдирдХрд╛рд░реА
рдХреАрдорддрдЗрд╕ рдРрдкреНрд▓рд┐рдХреЗрд╢рди рдХреЛ рдмрд┐рдирд╛ рдХрд┐рд╕реА рд╢реБрд▓реНрдХ рдХреЗ рдЖрдЬрд╝рдорд╛рдиреЗ рдХреА рд╕реБрд╡рд┐рдзрд╛ рдЙрдкрд▓рдмреНрдз рд╣реИ
рдбреЗрд╡рд▓рдкрд░
рд╕реЗрд╡рд╛ рдХреА рд╢рд░реНрддреЗрдВ
Combine Sheets рдиреАрдЪреЗ рджреА рдЧрдИ рдЕрдиреБрдорддрд┐рдпреЛрдВ рдХреЗ рдРрдХреНрд╕реЗрд╕ рдХрд╛ рдЕрдиреБрд░реЛрдз рдХрд░реЗрдЧрд╛. реЫреНрдпрд╛рджрд╛ рдЬрд╛рдиреЗрдВ
Combine Sheets рдХреЛ рдЖрдкрдХреЗ Google рдЦрд╛рддреЗ рдХреЗ рдРрдХреНрд╕реЗрд╕ рдХреА рдЬрд╝рд░реВрд░рдд рд╣реЛрдЧреА
рдЗрд╕рд╕реЗ Combine Sheets рдХреЗ рджрд╛рдпрд░реЗ рдореЗрдВ рдпреЗ рдЕрдиреБрдорддрд┐рдпрд╛рдВ рднреА рд╢рд╛рдорд┐рд▓ рд╣реЛ рдЬрд╛рдПрдВрдЧреА :
Google Disk рдкрд░ рдореМрдЬреВрдж рдЕрдкрдиреА рд╕рднреА реЮрд╛рдЗрд▓реЗрдВ рджреЗрдЦреЗрдВ, рдЙрдирдореЗрдВ рдмрджрд▓рд╛рд╡ рдХрд░реЗрдВ, рдмрдирд╛рдПрдВ, рдФрд░ рдЙрдиреНрд╣реЗрдВ рдорд┐рдЯрд╛рдПрдВ
рдЖрдкрдХреА рд╕рднреА Google Sheets рд╕реНрдкреНрд░реЗрдбрд╢реАрдЯ рджреЗрдЦрдирд╛, рдЙрдирдореЗрдВ рдмрджрд▓рд╛рд╡ рдХрд░рдирд╛, рдирдИ рд╕реНрдкреНрд░реЗрдбрд╢реАрдЯ рдмрдирд╛рдирд╛, рдФрд░ рдЙрдиреНрд╣реЗрдВ рдорд┐рдЯрд╛рдирд╛
Google рдРрдкреНрд▓рд┐рдХреЗрд╢рди рдореЗрдВ рдкреНрд░реЙрдореНрдкреНрдЯ рдФрд░ рд╕рд╛рдЗрдбрдмрд╛рд░ рдореЗрдВ рддреАрд╕рд░реЗ рдкрдХреНрд╖ рдХрд╛ рд╡реЗрдм рдХреЙрдиреНрдЯреЗрдВрдЯ рджрд┐рдЦрд╛рдПрдВ рдФрд░ рдЪрд▓рд╛рдПрдВ
рдХрд┐рд╕реА рдмрд╛рд╣рд░реА рд╕реЗрд╡рд╛ рд╕реЗ рдХрдиреЗрдХреНрдЯ рдХрд░реЗрдВ
рдЖрдкрдХреЗ Google рдЦрд╛рддреЗ рдХрд╛ рдореБрдЦреНрдп рдИрдореЗрд▓ рдкрддрд╛ рджреЗрдЦрдирд╛
рд╕реЛрд╢рд▓ рдореАрдбрд┐рдпрд╛ рдкрд░ рджреА рдЧрдИ рдХрд┐рд╕реА рднреА рдЬрд╛рдирдХрд╛рд░реА рдХреЗ рд╕рд╛рде, рдЕрдкрдиреА рдирд┐рдЬреА рдЬрд╛рдирдХрд╛рд░реА рджреЗрдЦреЗрдВ
рд╕рдореАрдХреНрд╖рд╛рдПрдВ
рднрд╛рд╖рд╛:
рдЗрд╕ рдХреНрд░рдо рдореЗрдВ рд▓рдЧрд╛рдПрдВ:
Google, рд╕рдореАрдХреНрд╖рд╛рдУрдВ рдпрд╛ рд░реЗрдЯрд┐рдВрдЧ рдХреА рдкреБрд╖реНрдЯрд┐ рдирд╣реАрдВ рдХрд░рддрд╛. рд╕рдореАрдХреНрд╖рд╛рдУрдВ рдХреЗ рдмрд╛рд░реЗ рдореЗрдВ реЫреНрдпрд╛рджрд╛ рдЬрд╛рдиреЗрдВ
рдХреЛрдИ рдЯрд┐рдкреНрдкрдгрд┐рдпрд╛рдВ рдирд╣реАрдВ