Formulas > =IMPORTRANGE()

How To Use IMPORTRANGE() Function in Google Sheets


Imports a range of cells from a specified spreadsheet.

Common questions about the IMPORTRANGE formula:
1. What is the IMPORTRANGE formula? Used to get a range of cells from one sheet to another sheet.
2. How do I use the IMPORTRANGE formula? The sheet in question could be a tab in the same spreadsheet file or a sheet in another spreadsheet file. IMPORTRANGE is quite versatile in that regard.
3. What are the limitations of the IMPORTRANGE formula? If your data is in an EXCEL spreadsheet, then IMPORTRANGE will not work. Also you cannot import formatting from one sheet to another sheet using IMPORTRANGE.

How can the IMPORTRANGE formula be used appropriately?
The IMPORTRANGE formula can be used to import data from one Google Sheet to another. It can be used to quickly and easily copy data from one sheet to another, allowing for easy collaboration between multiple users.

How can the IMPORTRANGE formula be commonly mistyped?
The IMPORTRANGE formula is commonly mistyped as “IMPORT RANGE” or “IMPORT RANGES”. Do not include a space in the formula. Also IMPORTRANGE might be mistyped as IMPORT,or IMPRTRANGE, or IMPRTRNGE, or IMPORTRANG.

What are some common ways the IMPORTRANGE formula is used inappropriately?
The IMPORTRANGE formula should not be used to copy large amounts of data from one sheet to another. It should also not be used to copy data from a sheet that is not owned by the user. Of course maybe that's unethical but not really improper use of IMPORTRANGE. IMPORTRANGE used to gather information is fine. What is really can't be used for is images and formatting.

What are some common pitfalls when using the IMPORTRANGE formula?
The IMPORTRANGE formula can be slow to update when the source sheet is updated. It can also be difficult to troubleshoot if the formula is not entered correctly. As the original data may need validation and tracking where an IMPORTRANGE is coming from is  a case of "what's this url go to?" You'll be searching through old sheets for the right data you need, and fix it.

What are common mistakes when using the IMPORTRANGE Formula?
Common mistakes when using the IMPORTRANGE formula include entering the wrong range of cells, entering the wrong sheet name, and forgetting to grant access to the source sheet. If you forget to grant access you'll always get a REF error, also called a Reference error.

How To Actually Use IMPORTRANGE() in Sheets

IMPORTRANGE(spreadsheet_url, range_string)

9Better Sheets Tutorials

Combine Databases and Backup Your Information Effortlessly - Learn how to merge two databases and compare backups with ease. Get all the information you need from past years and multiple sheets. Follow our step-by-step guide and simplify your data management today! 
Jodi asked:  ab out Building a sales CRM spreadsheet that has 4-5 tabs at the bottom. Each sales person gets their own sheet and then I want a master spreadsheet that pulls each salespersons Information they enter (customer, job, status etc) into one place. 

I’m not sure how to get the master sheet to pull in from the other sheets as they enter the data so that the master sheet shows real-time what’s happening without making one row = a row from another sheet.  I just want it to come in one row after the next as it happens.

Other Videos Mentioned in this video:

Spreadsheet Automation 101:
Covering some of the basics I skipped over in the part 1 video.
A funky way to password protect some data in a sheet, 3 ways to do it: with IF(), Apps Script, and Encoding
Quick intro to a better experience of using Google Sheets
We have a question from Rupesh about the quick CRM. He wants to add some team members.
Stick around after the 1st portion of the video for bonus content.
Just in time for the holidays. Great for making promotion calendars to reveal promotions day to day.
I'll show you how to get text from one spreadsheet file to another with Apps Script. Yes you can do this by Importrange() but you might want another way to do it.

Learn more about the IMPORTRANGE() formula:

Generate a IMPORTRANGE() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.