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. Picture 1 of How to Use Importrange on Google Sheets on PC or Mac
    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. Picture 2 of How to Use Importrange on Google Sheets on PC or Mac
    Click the file you want to import data from. This opens the workbook.
  3. Picture 3 of How to Use Importrange on Google Sheets on PC or Mac
    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. Picture 4 of How to Use Importrange on Google Sheets on PC or Mac
    Click the File menu. It's near the top-left corner of the screen.
  5. Picture 5 of How to Use Importrange on Google Sheets on PC or Mac
    Click Share….
  6. Picture 6 of How to Use Importrange on Google Sheets on PC or Mac
    Click Get shareable link. A link to the spreadsheet is now copied to the clipboard.
  7. Picture 7 of How to Use Importrange on Google Sheets on PC or Mac
    Click Done.
  8. Picture 8 of How to Use Importrange on Google Sheets on PC or Mac
    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. Picture 9 of How to Use Importrange on Google Sheets on PC or Mac
    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. Picture 10 of How to Use Importrange on Google Sheets on PC or Mac
    Click the file where you want the data to appear. You'll be entering the formula on this spreadsheet.
  3. Picture 11 of How to Use Importrange on Google Sheets on PC or Mac
    Click the cell where you want the range to appear.
  4. Picture 12 of How to Use Importrange on Google Sheets on PC or Mac
    Type =IMPORTRANGE. A list of matching functions will appear.
  5. Picture 13 of How to Use Importrange on Google Sheets on PC or Mac
    Click IMPORTRANGE. The cell now reads =IMPORTRANGE(.
  6. Picture 14 of How to Use Importrange on Google Sheets on PC or Mac
    Type a ".
  7. Picture 15 of How to Use Importrange on Google Sheets on PC or Mac
    Press Ctrl+V (Windows) or ⌘ Cmd+V (macOS). This pastes the link to the other spreadsheet into the blank.
  8. Picture 16 of How to Use Importrange on Google Sheets on PC or Mac
    Type another ".
  9. Picture 17 of How to Use Importrange on Google Sheets on PC or Mac
    Type a comma ,.
  10. Picture 18 of How to Use Importrange on Google Sheets on PC or Mac
    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. Picture 19 of How to Use Importrange on Google Sheets on PC or Mac
    Type ). You should now see something like this:
    1. =IMPORTRANGE('https://docs.google.com/spreadsheets/test' , 'Sheet1!A2:D11').
  12. Picture 20 of How to Use Importrange on Google Sheets on PC or Mac
    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.
Update 04 March 2020
dataclicktype

You should read it

Maybe you are interested

Category

System

Mac OS X

Hardware

Game

Tech info

Technology

Science

Life

Application

Electric

Program

Mobile