IMPORTRANGE

Imports a range of cells from a specified spreadsheet. Learn more

Video field
Web

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.

Want even more from Google Sheets?


With Softr, you can turn your spreadsheets into powerful web apps.You can give advanced roles and permissions to each user, build advanced logic and automation flows, customize the design to your needs, and much more.


Softr also offers a growing library of templates for internal tools, client portals, community hubs, and more. The templates come with a Google Sheet or an Airtable base that you can use to store and manage your data easily.


Try Softr now and build your custom web apps in 10 minutes no code required!

Client Portal | Internal Tools | Web App Builder | Free Website Builder Made with Softr