Imports a range of cells from a specified spreadsheet. Learn more
The IMPORTRANGE function in Google Sheets is a powerful tool that allows you to import data from one Google Sheets document into another.
It enables you to access and display data from a specified range of cells in a different spreadsheet.
The IMPORTRANGE function takes two arguments:
spreadsheet_url: This is the URL of the spreadsheet from which you want to import data. It should be enclosed in quotation marks (" ").
range_string: This specifies the range of cells you want to import. It can be a single cell, a range of cells, or even an entire sheet. The range should be in the format
To use IMPORTRANGE, you need to follow these steps:
Open the destination spreadsheet where you want to import the data.
In the cell where you want the imported data to appear, enter the following formula:
=IMPORTRANGE("spreadsheeturl", "rangestring")
Replace "spreadsheeturl" with the actual URL of the source spreadsheet and "rangestring" with the desired range of cells.
Press Enter, and if the source spreadsheet is accessible, you will be prompted to grant permission to import the data. Click "Allow access" to proceed.
Once the import is successful, the specified data from the source spreadsheet will be displayed in the destination spreadsheet.
The imported data will be dynamically linked, meaning that any changes made in the source spreadsheet will be reflected in the destination spreadsheet as well.
Note that both the source and destination spreadsheets must be owned by the same Google account, or the source spreadsheet must be shared with the Google account that owns the destination spreadsheet, for the import to work properly.