HomeMac OS X

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...
Part 1 of 2:

Getting a Link to the Data

  1. How to Use Importrange on Google Sheets on PC or Mac Picture 1How to Use Importrange on Google Sheets on PC or Mac Picture 1
    Go to https://sheets.google.com in a web browser. If you're not already signed in to your Google account, sign in now.
  2. How to Use Importrange on Google Sheets on PC or Mac Picture 2How to Use Importrange on Google Sheets on PC or Mac Picture 2
    Click the file you want to import data from. This opens the workbook.
  3. How to Use Importrange on Google Sheets on PC or Mac Picture 3How to Use Importrange on Google Sheets on PC or Mac Picture 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. How to Use Importrange on Google Sheets on PC or Mac Picture 4How to Use Importrange on Google Sheets on PC or Mac Picture 4
    Click the File menu. It's near the top-left corner of the screen.
  5. How to Use Importrange on Google Sheets on PC or Mac Picture 5How to Use Importrange on Google Sheets on PC or Mac Picture 5
    Click Share….
  6. How to Use Importrange on Google Sheets on PC or Mac Picture 6How to Use Importrange on Google Sheets on PC or Mac Picture 6
    Click Get shareable link. A link to the spreadsheet is now copied to the clipboard.
  7. How to Use Importrange on Google Sheets on PC or Mac Picture 7How to Use Importrange on Google Sheets on PC or Mac Picture 7
    Click Done.
  8. How to Use Importrange on Google Sheets on PC or Mac Picture 8How to Use Importrange on Google Sheets on PC or Mac Picture 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 2 of 2:

Importing the Data

  1. How to Use Importrange on Google Sheets on PC or Mac Picture 9How to Use Importrange on Google Sheets on PC or Mac Picture 9
    Go to https://sheets.google.com in a web browser. If you already see a list of your files, you can skip this step.
  2. How to Use Importrange on Google Sheets on PC or Mac Picture 10How to Use Importrange on Google Sheets on PC or Mac Picture 10
    Click the file where you want the data to appear. You'll be entering the formula on this spreadsheet.
  3. How to Use Importrange on Google Sheets on PC or Mac Picture 11How to Use Importrange on Google Sheets on PC or Mac Picture 11
    Click the cell where you want the range to appear.
  4. How to Use Importrange on Google Sheets on PC or Mac Picture 12How to Use Importrange on Google Sheets on PC or Mac Picture 12
    Type =IMPORTRANGE. A list of matching functions will appear.
  5. How to Use Importrange on Google Sheets on PC or Mac Picture 13How to Use Importrange on Google Sheets on PC or Mac Picture 13
    Click IMPORTRANGE. The cell now reads =IMPORTRANGE(.
  6. How to Use Importrange on Google Sheets on PC or Mac Picture 14How to Use Importrange on Google Sheets on PC or Mac Picture 14
    Type a ".
  7. How to Use Importrange on Google Sheets on PC or Mac Picture 15How to Use Importrange on Google Sheets on PC or Mac Picture 15
    Press Ctrl+V (Windows) or ⌘ Cmd+V (macOS). This pastes the link to the other spreadsheet into the blank.
  8. How to Use Importrange on Google Sheets on PC or Mac Picture 16How to Use Importrange on Google Sheets on PC or Mac Picture 16
    Type another ".
  9. How to Use Importrange on Google Sheets on PC or Mac Picture 17How to Use Importrange on Google Sheets on PC or Mac Picture 17
    Type a comma ,.
  10. How to Use Importrange on Google Sheets on PC or Mac Picture 18How to Use Importrange on Google Sheets on PC or Mac Picture 18
    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. How to Use Importrange on Google Sheets on PC or Mac Picture 19How to Use Importrange on Google Sheets on PC or Mac Picture 19
    Type ). You should now see something like this:
    1. =IMPORTRANGE('https://docs.google.com/spreadsheets/test' , 'Sheet1!A2:D11').
  12. How to Use Importrange on Google Sheets on PC or Mac Picture 20How to Use Importrange on Google Sheets on PC or Mac Picture 20
    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.
4 ★ | 1 Vote
dataclicktype

You should read it

May be interested

Mac OS X