How to Use IMPORTRANGE() in Google Sheets

Description

Imports a range of cells from a specified spreadsheet.

How To Actually Use IMPORTRANGE() in Sheets

IMPORTRANGE(spreadsheet_url, range_string)

Try IMPORTRANGE yourself

Use the IMPORTRANGE formula to import data from the spreadsheet with the URL 'https://docs.google.com/spreadsheets/d/abc123456/edit' for the range 'Sheet1!A1:A10'.

Your formula

Hints (2)

Locale Separator ,

Official Docs

9 Better Sheets Tutorials

Add Team Members to the Quick CRM

We have a question from Rupesh about the quick CRM. He wants to add some team members.

Intermediate

FILTER() IMPORTRANGE()

Combine Data from a Tab and a Totally Different Sheet | ImportRange and Curly Brackets!

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!

Intermediate

IMPORTRANGE()

Create a Public Sheet and Private Sheet: Using ImportRange()

Stick around after the 1st portion of the video for bonus content.

Intermediate

FILTER() IMPORTRANGE()

Password Protecting Data In a Google Sheet Part 2 The Basics

Covering some of the basics I skipped over in the part 1 video.

Advanced

IF() IMPORTRANGE()

Password Protecting Data In a Google Sheet

A funky way to password protect some data in a sheet, 3 ways to do it: with IF(), Apps Script, and Encoding

Advanced

IF() IMPORTRANGE()

Learn to Love Your Sheets

Quick intro to a better experience of using Google Sheets

Beginner

ARRAYFORMULA() IMPORTRANGE()

Combine Sheets Into One Sheet As It Happens

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:
https://bettersheets.co/tutorials/add-a-timestamp-to-task-lists-without-now-formula
https://bettersheets.co/tutorials/spreadsheet-automation-101-lesson-2-onedit-trigger

Spreadsheet Automation 101: https://bettersheets.co/courses/spreadsheet-automation-101

Intermediate

IMPORTRANGE() SORT()

I Created an Advent Calendar

Just in time for the holidays. Great for making promotion calendars to reveal promotions day to day.

Beginner

IMPORTRANGE()

How do I reference a different spreadsheet in Apps Script?

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.

Intermediate

IMPORTRANGE()

Learn more about the IMPORTRANGE() formula:

Generate a IMPORTRANGE() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses IMPORTRANGE(). 2 free AI generations, no signup. Members get unlimited use.

Generate a IMPORTRANGE() formula