IMPORTRANGE in Google Sheets

The IMPORTRANGE function in Google Sheets allows you to import data between multiple spreadsheets. To understand the formula of the IMPORTRANGE function better, you need to first understand the general structure of a Google Sheet.

A Google Sheet is hosted online and thus can be identified by an URL (like any other webpage). Inside the sheet we have multiple tabs & in each tab data is stored within a range of rows and columns.

To get data from a particular spreadsheet, we need to know:

  1. The URL of the Spreadsheet you want to pull the data from
  2. The tab within the sheet where the data is located
  3. The range of the data

IMPORTRANGE function Formula

If you understand the above structure, understanding the IMPORTRANGE formula won’t be much of a trouble:

= IMPORTRANGE(spreadsheet_url, range_string) 

Spreadsheet url of a particular Google sheet is available in the top URL bar , when the sheet is loaded in a browser.

The range_string contains the data range (including the tab). To understand better check the below example:

=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1Hh2grfB6rp9OQ2yAIu3S5YF_CCFJGwyqPGveABlOZKg/edit", "World Cup!A1:D21") 

The above formula would ping the mentioned URL and get the data from cell A1 to D21 located in the tab named “World Cup” .

When you type in the above formula in cell A1 of a sheet , here’s what you can expect to see:

Example: How to use  IMPORTRANGE  in Google Sheets
Example: How to use IMPORTRANGE in Google Sheets

Uses of IMPORTRANGE Function in Google Sheets

IMPORTRANGE allows you to combine multiple Google Sheets

More often than not, we encounter situations where the base data is continuously updated in a Google Sheet. We may not want to disturb this sheet. In such cases, we can import whatever data we need to our worksheet using IMPORTRANGE.

IMPORTRANGE can help with data privacy

We may have a situation , whereby we want to keep certain fields private while exposing the rest. In such cases we could use IMPORTRANGE to import the data that we need to the open sheet. Do note if the , source sheet isn’t shared openly, we would need to manually allow IMPORTRANGE to pull out data from it.

FAQs : IMPORTRANGE in Google Sheets

How do I pull data from one Google spreadsheet to another?

You can pull data from one Google spreadsheet to another using the IMPORTRANGE function.

Can you reference another workbook in Google Sheets?

You can reference another workbook in Google Sheets by using the URL of the workbook.

Summary
IMPORTRANGE in Google Sheets
Article Name
IMPORTRANGE in Google Sheets
Description
IMPORTRANGE function in Google Sheets is used for importing data from one spreadsheet to another. Learn to use the function like a pro with this easy to follow tutorial.
Author
Publisher Name
Digital Marketing Chef
Publisher Logo

8 thoughts on “IMPORTRANGE in Google Sheets”

  1. Greetings, I do think your site might be having internet browser compatibility issues.
    Whenever I take a look at your blog in Safari, it looks fine
    however when opening in I.E., it’s got some overlapping issues.
    I merely wanted to give you a quick heads up! Other than that, great
    site!

  2. I like reading through an article that can make men and women think.
    Also, thanks for allowing for me to comment!

    P.S. If you have a minute, would love your feedback on my new website
    re-design. You can find it by searching for «royal cbd» — no sweat if you can’t.

    Keep up the good work!

  3. I have been browsing on-line more than three hours nowadays,
    but I never found any attention-grabbing article like yours.
    It is lovely worth enough for me. In my view, if all site owners and bloggers
    made just right content material as you probably did, the net can be a lot more
    helpful than ever before.

  4. I would like to voice my admiration for your kindness giving support to individuals that must have assistance with the topic. Your personal commitment to passing the solution all through was surprisingly powerful and has usually enabled most people like me to attain their objectives. Your own warm and friendly help and advice implies this much a person like me and somewhat more to my fellow workers. Many thanks; from everyone of us.

Leave a Reply

Your email address will not be published. Required fields are marked *