How To Merge Multiple Google Sheets Into One (3 Methods)
The spreadsheet is the backbone of so many business processes that your device is probably full of them. With cloud-based services, it’s easier than ever to spin up a new spreadsheet and start working in it. Often, that means you’ll end up with duplicate spreadsheets or just data spread out over multiple sheets. That’ll lead to situations where you need to quickly figure out how to merge multiple Google Sheets into one.
Read on to learn about three methods for doing that — and a bonus formula you can use too.
First method: Merging Google Sheets with CSV files
Because it uses CSV (comma-separated values) files, this is possibly the fastest method to merge multiple Google Sheets — and it’ll work for other spreadsheet tools, too. You’ll just need a few clicks, an export, and an import, and you’ll be done.
So if you have two sheets that need merging, identify the one you want to pull data out of and the sheet you want to merge that data into. In this case, we want to pull data out of a spreadsheet called New Products.
And we’ll merge it into a spreadsheet called Product Database.
Go to the spreadsheet you want to export, hit File, then Download and Comma Separated Values.
This’ll give you a CSV file, which you’ll import into your other sheet. Go to that sheet, hit File, then Import.
In this next screen, go to Upload, then Browse for the CSV file you just downloaded from your first spreadsheet.
Once your file is selected, you’ll get a new screen with a few more options. Under the Import location dropdown, make sure you select Append to current sheet.
This will automatically add the data in your second spreadsheet to the one you want to merge it with.
Note that, because your exported file includes all the data in the original sheet, you’ll probably see headers and other data you don’t want. You’ll have to manually edit these out to completely merge your sheets.
Bonus Method: Merge Google Sheets from the same file with a formula
Did you know you can use a simple formula to reference data from another sheet within the same file? That way, your data will stay updated instead of you needing to constantly export your spreadsheet manually every time you need to merge your Google Sheets together. Here’s the formula:
So in the example above, we’d fill out this formula like this:
Note the quotes. If your spreadsheet has a space in its name, you must enclose it in single quotes. Once that’s done, here’s what you’ll get.
If you want more data, all you need to do is grab the blue square in the corner of the cell with the formula and spread it out to the cells you want your data to be in.
Limitations of the first method
Exporting a CSV file is one of the easiest ways to merge Google Sheets, but is it the best one for your needs? It depends on whether any of these limitations are a dealbreaker for you or not.
- Manual exports: While you can easily merge Google Sheets by exporting a sheet to a CSV file, it’s a completely manual process. That means you’ll need to do it repeatedly whenever there’s an update in either spreadsheet.
- Outdated data: This is one of the biggest disadvantages of manually exporting data. As soon as that data leaves its original spreadsheet, it’s outdated. Any updates made to it won’t be captured in your original export.
- It needs some cleanup: If you’re only merging sheets with a few rows, this won’t be much of an issue. But if you have hundreds or thousands of rows that all need cleanup after an export, this method isn’t very scalable.
If you need to quickly merge Google Sheets with just a few rows, this method might work for you. But if it doesn’t, there’s another way.
Third method: Merge multiple Google Sheets with Unito
Unito is a no-code workflow management solution with some of the deepest two-way integrations for the most popular tools on the market, including Google Sheets, Excel, Airtable, Notion, Smartsheet, and more. With a single Unito flow, you can automatically merge Google Sheets into a single spreadsheet while keeping your data up to date automatically. No need to export your data manually.
Here’s why Unito is the best way to merge multiple Google Sheets into one.
- It’s automatic: Once you build it, a Unito flow will automatically export Google Sheets data and merge your spreadsheets. No more scheduled exports.
- Your data is up to date: Unito doesn’t just merge your spreadsheets, it keeps them up to date, too. That means no matter which spreadsheet you’re making changes in, Unito will update your data everywhere.
- No cleanup necessary: With Unito, you can automatically map columns in one spreadsheet to columns in another, meaning there’s no need to clean up your data. You also won’t have to delete header rows.
Ready to start? Here’s how easy it is to build your first Unito flow and merge Google Sheets.
- First, connect Google Sheets to Unito.
You’ll also pick the Google Sheets you want to merge at this step.
- Next, use rules to filter out the Google Sheets rows you don’t want merged.
You could filter out rows with specific empty values, for example.
- After that, you can map Google Sheets fields between the two spreadsheets.
You’ll see the names of the headers in each spreadsheet, and you can send your data where it needs to go.
And that’s it! Now you just need to launch your flow and watch as Unito automatically merges your Google Sheets spreadsheets.
Ready to start?
Try Unito for 14 days, absolutely free.