NorthStar Analytics
Pricing

HiDocs High-Quality Ghost Documentation Theme

How to Use IMPORTRANGE Function in Google Sheets?

How to Use IMPORTRANGE Function in Google Sheets?

When working with Google Sheets, we can have multiple tables, multiple sheets. We may need to use the same data on different pages. You may think of getting data with copy-paste. But this would not be a tiring and continuous practice. We can easily make this application with IMPORTRANGE. If you have worked with VLOOKUP before, you must have done similar work. If you want to review, you can find the detailed article here🡪 “How to use VLOOKUP function in Google Sheets”

What is the syntax for the IMPORTRANGE function?

The function may sound long, but it has a fairly easy syntax. It looks long because it contains the URL. Let me explain the syntax with the example below.

=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1RlFw25ePjhvRYMjVuXjkXChjorpQLY3Dr6ZsfkfaUfo/edit#gid=0","Sheet1!A1:E15")

=IMPORTRANGE(“URL”,”Page name!cell range”)

Let's fill the function in order.

Function

=IMPORTRAGANGE(

URL

https://docs.google.com/spreadsheets/d/1RlFw25ePjhvRYMjVuXjkXChjorpQLY3Dr6ZsfkfaUfo/edit#gid=0” 🡪The page URL from which we want to get the data. Don't forget to write it in (").

Come to the worksheet where we want to get data for the URL, Copy the location indicated in the screenshot above. Paste the data into the function on the page we want to move

Page Name

The page name is written under the page from which we want to retrieve the data. We write the page name here, starting with (“ ). The sheet name in my example is the sheet name given by the table. Sheet1 for changing it. If you want, you can change it by right-clicking here and clicking 'rename'

Don't forget to put (!) after the sheet name.-->”Sheet1!

Cell Range

Now I can enter the cell range from which we want to get data. The sheet I want to get data from is "Sheet1". I come to this page and I want to get the whole table. For this, I write A1:E15 in my function.

If I just want to get column A1 I have to write A1:A. It has the advantage of being like this. If I write it like this, every cell I add to column A will also be on my added. If I specify certain ranges (like A1:A15) and add a new cell to the sheet I want to get data from, it will not be added to my new worksheet. Don't forget to put(“) after adding the cell range.

After writing our cell range, we can close the parenthesis and finish the function. And a warning will come as follows.

We must not make sure that we have access to the page. If we don't have access, the data will not arrive.

You can find detailed information about permissions here ”How to lock cells in Google Sheets?”

After giving permission, we moved our table as we wanted.

Make your business data transparent!
  • Subscribe to a package

    Subscribe and explore the limits of your business with data or thinking to expand your agency value proposition with Google Data Studio dashboards?

  • Request unlimited dashboards

    You can request as many dashbaords you might have and as many revisions as you might need. We create a queue of your tasks, the first tasks that come in are the tasks that we’ll deliver first.

  • Your Data Studio Department

    Optimise your business with complete transparency through dashboards or provide value-added Google Data Studio service to your agency clients.

Make your business transparent

The fastest easy-to-use Google Data Studio dashboards without any recurring cost.