Try Sortd for FREETry Sortd
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.
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 cellsWhat'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?V1.3New 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.2Improved:- 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.1Fixed:- 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!
