Google Sheets | IMPORTRANGE | Function | Import Data from Range | Example | Spreadsheet Tutorial

The Google Sheets IMPORTRANGE function returns specified range of data from a source spreadsheet to the destination spreadsheet with the IMPORTRANGE function formula. A reason to use IMPORTRANGE is to import only part of the spreadsheet, instead of the entire data, into another sheet or spreadsheet.

-------------------------------------
How to Use XMATCH in Google Sheets?

XMATCH returns the position of the specified search key in a row or column:

-------------------------------------
How to Use INDEX in Google Sheets?

Get to know more about INDEX with this step-by-step video tutorial:

-------------------------------------
How to Use XLOOKUP for Approximate and Wildcard Match in Google Sheets?

XLOOKUP can return approximate data and supports wildcard search:

-------------------------------------
How to Use XLOOKUP to Extract Data to Left of Search Key in Google Sheets?

XLOOKUP can extract data to left, right, or left and right of search key:

-------------------------------------
How to Use XLOOKUP to Extract Multiple Values in Google Sheets?

XLOOKUP allows to extract multiple values from a row or column:

-------------------------------------
How to Use VLOOKUP in Google Sheets?

Use VLOOKUP to extract a single value to the right of the search key:

-------------------------------------
How to Use HLOOKUP in Google Sheets?

Use HLOOKUP for horizontal lookup of search key and extract a single value to its right:

----------------------------------------
How to Sum Investment Amount by Quarter?

Sum data of investments, profits, revenues, etc., by quarter:

-------------------------------------
How to Sum Investment Amount by Month?

The step-by-step tutorial to sum investment amount (or profits, revenues, expenses, orders, etc.) by month:

-------------------------------------
How to Sum Investment Amount by Week?

The step-by-step tutorial to sum investment amount (or profits, revenues, expenses, orders, etc.) by week:

-------------------------------------

IMPORTRANGE Function Formula

=IMPORTRANGE(spreadsheet_url, range_string)

spreadsheet_url is the address of the source spreadsheet from which to import the range.

range_string is the range name or address.

NOTE: Both spreadsheet_url and range_string should be typed between double quotes.

Example 1

Import Data from one Spreadsheet into Another

Open the source and destination spreadsheets.

Assume the data range you want to import from the source spreadsheet is named as south_zone_q1_q4_FY_2023.

In the destination spreadsheet, in the cell, which will be the first cell the
imported data will display, type the following part of the IMPORTRANGE function formula:

=IMPORTRANGE(

Switch to the source spreadsheet and copy the URL of the spreadsheet from the browser address bar. Switch back to the destination spreadsheet.

Type the opening double-quotes and paste the URL, type the closing double-quotes, and type comma. Type the range name between double quotes. Type the closing parenthesis.

Connect the source and destination spreadsheets. The function will import the data in the named range in the source spreadsheet to the destination spreadsheet.

Review this tutorial, which gives the steps to use the Google Sheets IMPORTRANGE function, with examples.