How to Use Importrange on Google Sheets on PC or Mac

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.

data click type

Kareem Winters

Update 04 March 2020

You should read it

May be interested

How to Back Up Mac Photos
this wikihow teaches you how to save a backup of your entire photos library on a mac. you can automatically upload all your pictures to icloud if you want an online backup, or copy your photos library file to an external drive if you want...
How to Type an Apple Icon on Mac Computer
have you ever seen anyone put the apple icon on their blog or when chatting? they're not magicians; with a few clicks you'll be doing it, too. keep reading! hold the and button down at the same time.
How to Protect a Zip File with a Password on PC or Mac
this wikihow teaches you how to password-protect a zip archive using winrar for windows, and macos's built-in zip tool. install winrar on your pc. if you don't already have this free archive tool, see use winrar to learn how to get it.
How to Establish a Secure Connection
while you're browsing the web on safari on mac, you might get a loading error that says something like 'safari can't open the page because it can't establish a secure connection.' if macos detects that a server has a weak encryption or if...
How to Use Siri on a Mac
for a long time, apple's intelligent personal assistant siri was only available on certain versions of the iphone. with apple's operating system macos sierra, apple computer owners can now use siri to initiate a ton of tasks without...
How to Use Tabs in macOS
tabbed browsing is a staple of mac computers, but for a long time was only available on web browsers. starting with the late 2016 release of macos sierra, you can use tabs on apps that previously restricted you to a single work station at...