In this tutorial, we will show you exactly how to combine multiple sheets into one in Google Sheets in just a few steps. Simply follow the steps below.
Merging multiple sheets into one on Google Sheets can be achieved using two effective methods: the 'IMPORTRANGE Function' and the 'Sheetgo Add-On'. We will discuss how to use each method in the following sections.
Here’s how to use IMPORTRANGE function to merge several sheets into one in Google Sheets.
Look at the bottom of your open Google Sheets file. You’ll see tabs with different sheet names like "Sheet1", "Sheet2", etc. These are the sheets you want to combine.
Decide which sheet will act as your main sheet. This is where all the data from other sheets will be combined. In our case, we'll use Sheet 1.
In a blank cell in the main sheet, type the formula:
```=IMPORTRANGE("spreadsheet_url", "sheet_name!range")```
Replace spreadsheet_url with the link to the spreadsheet you’re importing from.
You can copy the spreadsheet_url from the address bar.
And sheet_name!range with the specific range of cells (e.g., Sheet1!A1).
For each additional sheet, repeat the IMPORTRANGE process, updating the sheet_name!range to match the new sheet you’re combining.
Now that all your sheets are combined into the main sheet, organize the data as needed. You can remove empty rows, adjust column widths, or reformat cells for clarity.
Follow the steps below to use the Sheetgo add-on to merge two or more sheets into one in Google Sheets.
With your Google Sheets open, click on the “Extensions” menu at the top.
After clicking "Extension," a dropdown menu will be shown where you can select "Add-ons" then "Get add-ons."
In the Google Workspace Marketplace, search for the "Sheetgo" add-on.
After selecting the add-on, click "Install."
Tap "Continue" to proceed.
Select your desired account.
Click on "Continue" to proceed.
Then, click "Allow" to grant permissions.
After installation, go back to “Extensions,” click “Sheetgo,” and select “Start.” The add-on will open a new sidebar.
In the Sheetgo sidebar, click “Start connecting.” Follow the prompts to select the sheets you want to combine and the destination sheet where you want the combined data.
You’ll be asked to choose the source sheets and ranges to combine. Click "Select data" to start.
Select "Sheet files" to select the files you want to combine.
Click on "Grant permission" to allow the add-on to access your Google Drive.
On this page, tick off the checkboxes beside the files you want to combine. Select "Done" to start uploading.
Click on "Next step" to proceed.
Click "Finish and save" to save the parameters.
After setting the parameters, click “Run all” to combine your sheets. The add-on will merge the data into the destination sheet automatically.
We hope that you now have a better understanding of merging multiple sheets into one on Google Sheets. If you enjoyed this article, you might want to check our articles on how to insert data from a picture in Google Sheets and how to show hidden sheets in Google Sheets.
