How to Consolidate data with Sheetgo (updated version in description)
Watch the up-to-date version here: • How to consolidate data with Sheetgo
Sheetgo's Consolidate feature allows you to use multiple source files in your connection. This will pull data from multiple spreadsheets and combine it into one single tab in another spreadsheet.
► Open Sheetgo: https://app.sheetgo.com/workflows?stm...
A consolidate connection is useful when you want to collate data from different sources in a central master sheet for analysis or reporting. Consolidate saves you time as you only need to set up one connection. In one click (or with automatic updates) your data is gathered in one place.
You can consolidate in two ways:
1. Consolidate individual sheets: merge data from multiple spreadsheets added to the connection, no matter where they are located in your Drive storage.
2. Consolidate from a folder: merge data from the same tab in every spreadsheet in a folder (available with the Professional or Expert plan). You can consolidate up to 10MB of data in one connection.
Use any file type (Google Sheets, Excel, CSV, or TSV) as your source file. TIP: Always consider consolidating from a folder, as it's faster, more efficient, and more future proof. If you add a new spreadsheet to the folder, it will be included in the consolidation automatically!
____________________________________________
► Read more about how the Sheetgo Consolidate feature works here: https://support.sheetgo.com/how-to-me...
Video breakdown:
0:00 - 1:42: Introduction to Sheetgo's Consolidate feature
1:43 - 3:43: Instructions in the product
3:44 - 3:57: Visual result
3:58 - 4:35: Results in your spreadsheet
4:36 - 6:21: Consolidate from a folder
6:22 - 6:42: Add more spreadsheets to the folder
6:43 - 6:55: Contact us
____________________________________________
► If you need guidance, our experts can help you: https://calendly.com/sheetgomeeting/s...
► Subscribe to Sheetgo's Youtube channel: https://youtube.com/c/Sheetgo?sub_con...
____________________________________________