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
-
How 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. -
How 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. -
How 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] -
How 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. -
How to Use Importrange on Google Sheets on PC or Mac Picture 5
Click Share…. -
How 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. -
How to Use Importrange on Google Sheets on PC or Mac Picture 7
Click Done. -
How 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
-
How 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. -
How 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. -
How to Use Importrange on Google Sheets on PC or Mac Picture 11
Click the cell where you want the range to appear. -
How to Use Importrange on Google Sheets on PC or Mac Picture 12
Type =IMPORTRANGE. A list of matching functions will appear. -
How to Use Importrange on Google Sheets on PC or Mac Picture 13
Click IMPORTRANGE. The cell now reads =IMPORTRANGE(. -
How to Use Importrange on Google Sheets on PC or Mac Picture 14
Type a ". -
How 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. -
How to Use Importrange on Google Sheets on PC or Mac Picture 16
Type another ". -
How to Use Importrange on Google Sheets on PC or Mac Picture 17
Type a comma ,. -
How 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". -
How to Use Importrange on Google Sheets on PC or Mac Picture 19
Type ). You should now see something like this:- =IMPORTRANGE('https://docs.google.com/spreadsheets/test' , 'Sheet1!A2:D11').
-
How 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
You should read it
- Data type in C / C ++
- Data type in C #
- Data types in SQL Server
- Convert data types in C #
- Data type in C programming
- Press type in C
- Query XML data from a table with XML data type
- Chromebooks can now warn users when connecting to an 'inappropriate' USB Type C cable
- Data types in Access 2016
- TYPE function - Function that returns the data type of any value in Excel
- How to Type Symbols on a Keyboard
- What is USB Type C? Type C cable models are widely used