Using the IMPORTRANGE Function
Confusingly, a sheet in Google Sheets could refer to two things. It could refer to the individual sheets in your spreadsheet. It could also refer to the spreadsheet file itself.
The method above refers to copying individual sheets into a different spreadsheet. However, what do you do if you’d prefer to merge data from multiple sheets into a single sheet?
To do that, you can use the IMPORTRANGE function. This function will show the data from existing sheets (across multiple files) and place it in one sheet for you to use.
To use the IMPORTRANGE function in Google Sheets:
- Open your Google Sheets spreadsheet.
- Select the sheet you want to merge data into from the tabs at the bottom.
- At the bottom of your existing data and in an empty cell, type: =IMPORTRANGE(
- In quotation marks, type the URL of the sheet you want to import data from, followed by a comma.
- After the comma, and in quotation marks, type the name of your other sheet and the range of cells from that sheet that you want to import (e.g., “Sheet1!A1:Z100”).
- Close the parentheses and press the Enter key (e.g., =IMPORTRANGE(“https://docs.google.com/spreadsheets/d/abcd”, “Sheet1!A1:Z100”)
