Clear, practical technology insights About · Contact

How to Use Importrange on Google Sheets on PC or Mac

This wikiHow teaches you how to use the IMPORTRANGE function in the web version of Google Sheets to import data from another spreadsheet. Go to https://sheets.google.com in a web browser. If you're not already signed in to your Google...

Author: Kareem Winters04 March 20203 minutes read

Table of Contents

Part 1 of 2:

Getting a Link to the Data

Go to https://sheets.google.com in a web browser. If you're not already signed in to your Google account, sign in now.
Click the file you want to import data from. This opens the workbook.
Make note of the sheet name and range of the data you want to import. The sheets in the file are listed along the bottom of the screen. Click the sheet name that contains the data, then write down or memorize the range (e.g. A2:D11). You'll need this information for the IMPORTRANGE formula.^[1]
Click the File menu. It's near the top-left corner of the screen.
Click Share….
Click Get shareable link. A link to the spreadsheet is now copied to the clipboard.
Click Done.
Click the Google Sheets home icon. It's the green button with a white table at the top-left corner of the screen. Now that you've copied the link, it's time to add it to a formula in the sheet where you want the data to appear.

Part 2 of 2:

Importing the Data

Go to https://sheets.google.com in a web browser. If you already see a list of your files, you can skip this step.
Click the file where you want the data to appear. You'll be entering the formula on this spreadsheet.
Click the cell where you want the range to appear.
Type =IMPORTRANGE. A list of matching functions will appear.
Click IMPORTRANGE. The cell now reads =IMPORTRANGE(.
Type a ".
Press Ctrl+V (Windows) or ⌘ Cmd+V (macOS). This pastes the link to the other spreadsheet into the blank.
Type another ".
Type a comma ,.
Type the path to the data between quotes (''). For example, if the data in the first spreadsheet is on a sheet called Sheet1 and the range is A2:D11, type "Sheet1!A2:D11".
Type ). You should now see something like this:
1. =IMPORTRANGE('https://docs.google.com/spreadsheets/test' , 'Sheet1!A2:D11').
Press ↵ Enter or ⏎ Return. The IMPORTRANGE formula will import the data. Once the import is complete, the data from the first spreadsheet will appear in the second.

Was this article helpful?

Your feedback helps us improve.

Discussion

Reader Comments 0

Sign in with email or Google to join the discussion.