Data: How to Use Importrange on Google Sheets on PC or Mac

This updated guide examines Data: How to Use Importrange on Google Sheets on PC or Mac and organizes the essential facts, background, and practical takeaways in clear American English.

Part 1of 2:

Getting a Link to the Data

1. Go tohttps://sheets.google.comin a web browser. If you're not already signed in to your Google account, sign in now.
2. Click the file you want to import data from. This opens the workbook.
3. 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]
4. Click theFilemenu. It's near the top-left corner of the screen.
5. ClickShare….
6. ClickGet shareable link. A link to the spreadsheet is now copied to the clipboard.
7. ClickDone.
8. 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 2of 2:

Importing the Data

1. Go tohttps://sheets.google.comin a web browser. If you already see a list of your files, you can skip this step.
2. Click the file where you want the data to appear. You'll be entering the formula on this spreadsheet.
3. Click the cell where you want the range to appear.
4. Type=IMPORTRANGE. A list of matching functions will appear.
5. ClickIMPORTRANGE. The cell now reads=IMPORTRANGE(.
6. Type a".
7. PressCtrl+V(Windows) or?Cmd+V(macOS). This pastes the link to the other spreadsheet into the blank.
8. Type another".
9. Type a comma,.
10. 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".
11. Type). You should now see something like this:
    • =IMPORTRANGE('https://docs.google.com/spreadsheets/test', 'Sheet1! A2:D11').
12. Press?Enteror?Return. The IMPORTRANGE formula will import the data. Once the import is complete, the data from the first spreadsheet will appear in the second.