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

Published: 01 February 2023
on channel: Software Spring

1,075

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:

   • Google Sheets | XMATCH | Function | Exampl...
-------------------------------------
How to Use INDEX in Google Sheets?

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

   • Google Sheets INDEX | Use INDEX Google She...
-------------------------------------
How to Use XLOOKUP for Approximate and Wildcard Match in Google Sheets?

XLOOKUP can return approximate data and supports wildcard search:

   • Google Sheets | XLOOKUP | Function | Match...
-------------------------------------
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:

   • Google Sheets | XLOOKUP | Function | Get D...
-------------------------------------
How to Use XLOOKUP to Extract Multiple Values in Google Sheets?

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

   • Google Sheets | XLOOKUP | Function | Extra...
-------------------------------------
How to Use VLOOKUP in Google Sheets?

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

   • VLOOKUP Google Sheets | How to Use VLOOKUP...
-------------------------------------
How to Use HLOOKUP in Google Sheets?

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

   • HLOOKUP Google Sheets | How to Use HLOOKUP...
----------------------------------------
How to Sum Investment Amount by Quarter?

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

   • Google Sheets | Sum by Quarter | Example |...
-------------------------------------
How to Sum Investment Amount by Month?

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

   • Google Sheets | Sum Data like Investments,...
-------------------------------------
How to Sum Investment Amount by Week?

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

   • Google Sheets |  How to Sum Investment Amo...
-------------------------------------

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.

On this page of the site you can watch the video online Google Sheets | IMPORTRANGE | Function | Import Data from Range | Example | Spreadsheet Tutorial with a duration of hours minute second in good quality, which was uploaded by the user Software Spring 01 February 2023, share the link with friends and acquaintances, this video has already been watched 1,075 times on youtube and it was liked by 3 viewers. Enjoy your viewing!

13,912

323