How To IMPORTRANGE From Another Tab in Google Sheets

Last Updated on October 31, 2023 by Jake Sheridan

In this tutorial, you will learn how to importrange from another tab in Google Sheets.

How To IMPORTRANGE From Another Tab in Google Sheets

We can use an array formula to import an entire range found in another sheet tab in Google Sheets. We can set up an array reference by wrapping a range with curly braces.

This can be a useful trick for users who want to use data from another tab in the current tab.

Unlike the copy-paste method, the array formula will automatically update when changes are made in the original tab.

This guide will show you how to import a range from another tab in Google Sheets.

How to Import a Range from Another Sheet Tab in Google Sheets

Here’s our step-by-step guide on how to import a range from another tab in Google Sheets.

Step 1

First, select an empty cell which you want to import data into.

Ensure that there is enough space around this blank cell to accommodate the data you plan on importing.

Step 2

Type the equal sign to begin the formula. After, write down the range you want to import and wrap the reference with an opening and closing curly brace.

Do note that cell references from other sheet tabs must start with the name of the sheet followed by a “!” character.

In this example, we want to add the range A1:F31 in Sheet2 into our blank cell in Sheet1.

Step 3

Hit the Enter key to expand the array reference.

Summary

This guide should be everything you need to learn how to importrange from another tab in Google Sheets.

You may make a copy of this example spreadsheet to test it out on your own.