1. How to merge multiple files into a single spreadsheet tab
To merge data from multiple files into one you can use Sheetgo connections, leaving the data in the source files intact. You can merge from multiple files or from a folder containing all the files.
Please note: To merge different spreadsheets, it's essential that they have the same column structure, otherwise the data will get mixed up.
1. Open Sheetgo’s web app, click New workflow, and Create a connection
2. Select multiple files
3. In your cloud storage select all the files to pull the data from and click Done.
4. From each spreadsheet, select the tabs you want to merge. Then click Next step.
5. Select the Merge processor
By default, Sheetgo will treat the first row as a header. To change this, open the dropdown menu, select the desired row, and click Next step.
6. Select the destination spreadsheet
You can send your merged data to a single spreadsheet or to multiple files. In this case, we are sending the data to one Google Sheets file.
As the destination, you can select an existing spreadsheet or create a new one.
If you create a new spreadsheet, Sheetgo will save it on the root folder of the source documents by default. You can to Change destination folder to specify where to create this new file. You will need to give it a name and specify the file format (Google Sheets, Excel or CSV).
Sheetgo will merge all the data from the source files into a single tab, with a name based on the source file but this can be customized. When you're done, click Finish and save.
This is what the resulting merge looks like. Note that this new tab is locked. You can still edit it, but any modification will be overwritten when the automation runs again.
Merge data from a folder
To merge all the files in a folder, repeat the steps above and select Files in a folder as the source.
Sheetgo will export data as follows:
From every file in the folder to the destination file, each time the automation runs.
From the latest file added to the folder to the destination file, each time the connection is updated.
Choose the folder name, import settings, and tab name.
After this, the next steps are identical to the ones used to merge data from multiple sources. Click Finish and save and run the connection to see how Sheetgo merged data from the three files.
Need more help?
Contact us via chat, on our email ([email protected]), or send us a ticket!
Visit our Community for help, tips, tricks, and feedback for Sheetgo.