Categories
Interior

How to import data from another google sheet

What you need to know about the IMPORTRANGE function

Of all of the G Suite web applications, Google Sheets may be the most impressive. Released in 2006, it quickly became a fierce competitor to stand up against Microsoft Excel as an up-and-coming spreadsheet editor.

Today, Google Sheets includes a wealth of editing and collaboration features that millions of students, workers, and hobbyists use on a daily basis.

How to import data from another google sheet

One of Google Sheets’ most appreciated features is its robust set of functions. Functions are a core component to what makes spreadsheets so powerful, and each spreadsheet editing platform usually has several of its own unique functions.

Google Sheet’s IMPORTRANGE function allows a level of seamless connectivity between two or more spreadsheets, enabling many interesting possibilities. It allows you to import data into Google Sheets.

What Is IMPORTRANGE?

IMPORTRANGE is one of the many functions supported by Google Sheets. Functions are used to create formulas that can manipulate your spreadsheet data, make calculations, and more.

Some of the more than 100 supported functions include DATE, to convert a string into a date, COS, to return the cosine of an angle provided in radiances, and ROUND, allowing decimals to be rounded to a certain decimal place.

How to import data from another google sheet

Included in this long list of functions is IMPORTRANGE. IMPORTRANGE enables a form of cross-spreadsheet integration, allowing a range of cells from another spreadsheet (or worksheet within the same sheet) to be imported.

This allows Google Sheets users to split up their data into multiple different sheets while still being able to view it using a simple formula. Uniquely, it also allows a level of collaboration where you can import data from a third-party sheet (if permitted) into your own.

How To Use IMPORTRANGE

The first step to making use of this powerful function is to have a spreadsheet that you want to import data from into Google Sheets. Either locate one or, as I’ll do in this example, create a dummy sheet with a few rows of data.

Here, we have a simple sheet of two columns and three rows. Our goal is to take this data and import it into another spreadsheet that we’re using. Create a new sheet or go into an existing sheet and let’s set it up.

You’ll begin with the same process as you would when using any function—click a blank cell so that you can access the function bar. In it, type =IMPORTRANGE. This is the function keyword we can use for importing sheet data.

The IMPORTRANGE function uses two parameters in its basic syntax: IMPORTRANGE(spreadsheet_url, range_string). Let’s go over both.

spreadsheet_url is exactly what it sounds like—the URL of the spreadsheet that you’re attempting to import a range of data from. You simply copy and paste the spreadsheet’s URL and here. Even easier, you can optionally just use the spreadsheet’s identifier string, also found in the URL.

This identifier is the long string of text found between “spreadsheets/d/” and “/edit” in the sheet’s URL. In this example, it’s “1bHbpbisrzaLF34r91UD1SLdDCpx7gD4v_4RnFBvgbfI”.

The range_string parameter is just as simple. Instead of printing all of the spreadsheet data from another sheet, you can return a specific range. To import the data shown in the entire sheet of our example, the range would be A1:B4.

This can be simplified to just A:B if we’re fine with importing all future data from these columns. If we wanted to import the data without headers, that’d be A2:B4.

Let’s put together our full formula: =IMPORTRANGE(“1bHbpbisrzaLF34r91UD1SLdDCpx7gD4v_4RnFBvgbfI”, “A:B”)

You’ll notice that attempting to use this formula, assuming you’ve properly replaced spreadsheet_url, will initially show a reference error. You’ll need to then click on the cell to connect these two sheets.

How to import data from another google sheet

If everything has been done correctly, you should now see the data imported into your current sheet.

Simple, right? It’s worth noting that formatting will not be preserved during this import, as you can see above, but all of the plaintext data will be.

Why Use IMPORTRANGE?

Now that you see how easy it is to use IMPORTRANGE, why would you ever use it? Let’s go over a few quick example use cases.

Better Organization

You may find yourself involved in a very complex sheet that has moving variables that you want to separate completely from other parts of your data. IMPORTRANGE is perfect for this, as it allows you to do just that.

Since IMPORTRANGE easily allows you to import data from another worksheet within the same spreadsheet, you can create a “Variables” worksheet where you can store anything with moving parts. A combination of IMPORTRANGE, QUERY, and CONCATENATE could then be used to bring everything together.

Collaborating With a Friend

Two heads are better than one, and IMPORTRANGE will even allow you to connect to sheets that your account doesn’t own, as long as it’s shared with you. If you’re working on a collaborative project, the work of two or more people can be dynamically consolidated into a single sheet using IMPORTRANGE.

Hiding Sensitive Data

If you have a private spreadsheet with rows or columns that you want to show publicly, IMPORTRANGE is great for that.

One example would be if you were to create a form with Google Forms. In it, you may ask for some of the respondents’ personal information—you obviously don’t want to give that out, right? However, the form may also ask less personal questions that you want to display in a public shared link. By setting the range_string accordingly and connecting the form’s response sheet, this can be achieved.

IMPORTRANGE is a powerful Google Sheets tool that serves well in a variety of different situations where you need to import data into Google Sheets. It’s one of my picks for the most important differences between Google Sheets and Microsoft Excel.

Do you have any questions on how you can use this function, or want to share one like it with us? Drop a comment below and we’ll check it out!

Craig is a long-time writer, coder, and marketer with years of experience in the technology and gaming spaces. Since 2008, he’s worked remotely with some of the most notable publications in these industries, specializing in Windows, PC hardware and software, automation, and the like. Read Craig’s Full Bio

5-MINUTE READ | By Sophie Michaud

How to import data from another google sheet

If you’re using Google Sheets, you probably need to reference or import data from another sheet every once in a while. It’s not very complicated, and there are a few ways to do that.

You can copy/paste the data, of course. For a tiny, select dataset, that might work. But that way, your data won’t be linked to the original source, which means it won’t update automatically if there are changes to the source data. Besides, we’re not fans of copy/pasting.

We have three ways for you to import your data from one Google Sheet to another — whether your sheets are in the same doc or not, we’ve got you covered.

1. Import data from another sheet in the same document

If the data you want to import is in the same document and comes from one cell only, you can use the simple formula [=SheetName!CellName] in the destination cell.

This method works fine for simple imports and calculations. It also links both cells. So when you make a change in the original cell, it’s reflected automatically in the destination cell.

What if your data is in another document or you want to transfer more than one cell at a time? ⬇️

2. Import data from a sheet in another document

You might keep your data in separate docs to calculate in one and report in another or keep your client’s data separate but want to combine it for your internal overview reporting.

In this case, you can use the [=IMPORTRANGE] formula.

  1. Open your destination sheet.
  2. Select an empty cell. Note that your data will transfer in the top left corner.

Make sure all the cells covered by your data are empty — otherwise, you’ll get an error message.

  1. Enter [=IMPORTRANGE(“SheetURL”,”SheetName!CellRange”)] in your top-left cell.
  2. Use the URL for the sheet you want to import data from. The sheet name and cell range are optional.
  1. Press “Enter”.
  2. Allow access to your sheet.
  3. That’s it! Your data is now imported and linked. Every time you update your original sheet, the destination sheet will update as well.

But wait, there has to be an easier way.

3. The easiest way to import data from one sheet to another

Whether you want to import your data from a sheet in the same doc or a different one, follow these simple steps to import and connect your data to another sheet.

If you don’t have a Supermetrics license for Google Sheets yet, get started with a trial.

  1. Open your destination sheet.
  2. Select an empty cell. Note that your data will transfer in the top left corner.
  3. Click on “Add-ons” ➡️ “Supermetrics” ➡️ “Launch sidebar”.

“Supermetrics” -> “Launch sidebar””/>

  1. Select your data source ↘️ scroll to Google Sheets.
  1. Enter the URL for the sheet you want to import your data from in the “Report configuration” field.
  1. Press “Get Data to Table”.
  2. Voilà!

Pro tip: You can set up an automatic refresh and email for your imported data. Simply click on the “Schedule” tab in the sidebar.

This method is especially useful if you’re sharing a report with an external partner or client. So when you update your original sheet, they can get an email with the refreshed data.

How to import data from another google sheet

Try Supermetrics today

Start your free, full-feature trial of Supermetrics for Google Sheets. No credit card required.

Looking for some advanced settings to customize your imported data? Here are the ones we’ve included so far. Simply enter the setting name in the “Options” ➡️ “Advanced Settings” section of the sidebar.

ALLOW_SUM_UNIQUE disables the safeguards we have against summing values of unique count metrics (e.g. users or unique pageviews)

COMBINE_DIMENSIONS concatenates dimension values when multiple dimensions have been specified

DATES_NOTE displays the query date range (and comparison date range if used) above the results table

KEEP_RESULTS_ON_REFRESH_ERROR in case a query refresh returns an error, with this setting, the results of a previous successful refresh are preserved

STORE_ERROR_QUERY stores the query even if it returns an error

TIME_DISP_START_DATE shows first day of month or week, instead of month/week number

DISABLE_DIMENSION_AUTOFORMAT prevents Google Sheets from applying automatic formatting to the dimension values

Over to you!

Those were the three ways to import your data from one Google Sheet to another.

How to import data from another google sheet

Check out our Google Sheets template roundup

Looking for templates to get you started on your marketing analytics journey?

How do I add a link in a Google Sheets to a specific paragraph or header in a Google Docs?

3 Answers 3

To add a link in a Google Spreadsheet you can use the formula =HYPERLINK( “www.google.com” ; “Search Google” ) .

For that link to point to a specific position in a Google Doc, use the Headings feature and create a Table of contents, from which you can take the anchor link to that specific part of the document.

To add a table of contents follow these steps:

  1. Add headings to your document by clicking Format >Paragraph styles in the toolbar, and selecting a heading.
  2. Click Table of contents from the Insert menu. The table of contents appears wherever you’ve clicked in the document, so make sure you place your cursor where you want to add the table of contents. If you need to move the table of contents, select it as you would select text and either move it with your cursor or cut it and paste it.
  3. You can continue to add headings to your document or change current headings. However, if you’d like a change to become part of the table of contents, you need to click first the table and then the Update now button.
  4. Each item in your table of contents links to the titled sections of your document that use the heading styles (that you added in step 1 above).

So, take the document’s link and add to it the anchor from the respective heading.

Here is a document I’ve created, that opens to a specific point.

How to import data from another google sheet

In the previous tutorial, we discussed how to import data from another Sheet in the same Google Spreadsheet. This tutorial will show you how to import data from one Google Sheet to another. And also, you can use this method to import data from multiple Google Spreadsheets.

For importing data from one Google Sheet to another, we need to have a way to identify each Google Spreadsheet uniquely.

How to uniquely identify each Google Spreadsheet

In Google Sheets, you can uniquely identify the Spreadsheet using the Spreadsheet URL or the Spreadsheet ID. We are going to use these unique identifiers when referring to other Spreadsheets.

The structure of the Spreadsheet URL looks like below. The value between the “d/” and “/edit” is the spreadsheet id. The red color part of the following URL is the Spreadsheet ID .

Remember the following function to import data from one Google Sheet to another

=IMPORTRANGE( spreadsheet_url , range_string )

The IMPORTRANGE function lets you import data from other Google spreadsheets.

The first parameter of the function is the URL of the spreadsheet which contains your data to be imported.

The second parameter is the range of the cell that contains your data to be imported.

How to use the IMPORTRANGE function to import data from other Spreadsheets

The above video explains how to use the IMPORTRANGE function to import data from other Google Spreadsheets.

You can set the IMPORTRANGE function to dynamically incorporate every new row added to the data source. To do that, you need to change the data range parameter as showed below.

Sheet1!A1:Y2824 into Sheet1!A1:Y (Remove row number)

You can replace the URL with the Spreadsheet ID explained above to clean the function a little.

For example, the following also should yield the same result above.

Include the IMPORTRANGE function inside other functions

The IMPORTRANGE function yields a range of cells. Therefore, you can include inside other Google Sheets function that requires a range of cells as a parameter. That way you can do more with the IMPORTRANGE function than importing data into Google Sheets directly.

Import data in Google Sheets and QUERY on them

You can provide this IMPORTRANGE function as the first parameter of the QUERY function. Then you can write your queries for that range.

Since this is a generated range, you should use column numbers as Col1, Col2, Col3, etc… to refer to the columns .

In the above data set, if you want to import only the sales record where the quantity ordered is greater than 60. You can use IMPORTRANGE and QUERY function together as explained below.

In the above example, the first parameter of the QUERY function is the Entire data range you imported from the other Google Spreadsheet using the IMPORTRANGE function.

The second parameter,

of the QUERY function is the SQL statement. In this query, we request to return all rows where values in column 2 are greater than 60.

Sort data in the IMPORTRANGE function

You can easily sort your imported data using the SORT function. The sort function Sorts the rows of an array or range by the values in one or more columns.

To sort the data, provide the IMPORTRANGE function as the first parameter (range – the range you are going to sort). Then provide the index of the column containing the values by which to sort.

For example , the following formula, sort the range based on the values in column 2 in ascending order.

Filter data in the IMPORTRANGE function

Using the FILTER function with IMPORTRANGE is a little of trickery. You cannot use the FILTER function directly to filter data in the IMPORTRANGE function.

For the first parameter of the FILTER function, provide the IMPORTRANGE function. Then you need to use the INDEX function to return the required array of cells. As the first parameter of the INDEX function, provide the column which you expect to apply a filter condition using the IMPORTRANGE function.

For example , the following formula returns the rows in which the column ‘B’ values are greater than ’60’.

Note: You can easily filter the data in the IMPORTRANGE function using the QUERY function.

Import Data from Multiple Spreadsheets into One Range

You can import data from multiple Spreadsheets to a single range. This is important when you want to perform analysis on them as a whole or when you want to display them on a dashboard like Google Data Studio.

To do this, you need to add semicolon-separated multiple IMPORTRANGE functions for each data source inside curly brackets.

Let’s say you have three separate Google Spreadsheets, that contain 2003, 2004, and 2005 sales data, and datasheets are Y2003, Y2004, and Y2005 respectively. If data is in the A2:Y range in each sheet.

You can import data in all those three Spreadsheets to a single range using the IMPORTRANGE function as explained below.

As of the time this post is written, you need to test each IMPORTRANGE function separately for each sheet and allow access. Otherwise, if you put all the IMPORTRANGE functions together and try to grant access, it will show you an error before you allow access for all the sheets.

The following video explains how to import data from multiple Google Sheets to a single range using the IMPORTRANGE function.

Using this method, you can dynamically import data added to your data sources (spreadsheets) to this range.

Wrapping Up

When you are working with spreadsheets, you occasionally need to link multiple spreadsheets together to do more complex analysis or display them in a dashboard.

It is easier to import data from one google sheet to another than in other types of spreadsheets. The only thing you need to Import data from other Google Spreadsheets is the IMPORTRANGE function. We can use this function with many other functions to import only the data you want. And also, unlike in other spreadsheets applications, you will not break the links even if you change the file location.

How to import data from another google sheet

Spreadsheets are the most flexible tool for managing your financial life.

However, no one wants to spend time manually entering bank transactions into a spreadsheet.

If you don’t use Tiller Money to automate your financial spreadsheets, you can still export your bank data with a CSV file and import it into a Google spreadsheet.

What is a CSV File?

CSV, or comma-separated values, is a file type that contains a list of data separated by–you guessed it–commas.

These files allow for the data to be quickly and easily transported from one source to another. While you can open a CSV file with many different programs, the most commonly used program is a spreadsheet editor like Google Sheets.

How to Create a CSV File

To create a CSV file of your bank transactions, go to your bank’s website, locate the export feature, and choose CSV from the available file types.

When you export the file, it will appear in the downloads folder in your computer’s file explorer.

To make it easier to locate the file later, find it in your downloads folder and transfer it to your Documents or Desktop folder.

How To Paste CSV Into Google Spreadsheet

To get your CSV file into a Google spreadsheet:

  1. Open Google Sheets
  2. Choose “File” → “Import” → “Upload” → “Select a file from your computer.”
  3. Choose your CSV file from your Documents or Desktop folder.
  4. The following window will pop up. Choose “Import data.”

How to import data from another google sheet

How To Clean Up A Spreadsheet CSV File

The imported data will look ugly. There will be extra information you probably won’t need, and the information you do need won’t be formatted correctly.

How to import data from another google sheet

Get rid of what you don’t need

Start by removing the columns you don’t need. Right click on the column letter. In the pop-up menu, choose “Delete column” to get rid of the data or “Hide column” if you don’t want to see the data but think you may find it useful later.

How to import data from another google sheet

Use the CONCATENATE formula to combine columns

Some banks import the debits and credits in different columns, which isn’t ideal for a budget spreadsheet. To combine the data into one column, add a column to the left of the debit column by right-clicking on the column letter and choosing “Insert 1 left.”

Next, use CONCATENATE formula. CONCATENATE allows you to combine the data in multiple columns without manually copying and pasting or retyping each cell.

Because of the syntax, the formula is slightly different for the debits than it is for the credits.

For the credits:

How to import data from another google sheet

Once your data is combined, you can hide the original debits and credits columns. Be careful not to delete them; if you do, the data for the CONCATENATE function will be erased.

By following these steps to import CSV into a Google Sheet, you can quickly create a budget spreadsheet or manually import your bank data into your Tiller Money-powered spreadsheet.

How to import data from another google sheet

It is easy to do your analysis when your raw/ source data is in a separate Sheet. Because it makes your analysis Sheet cleaner. In this post, I will show you how to import data from one sheet to another in Google Sheets. Then you can store your raw data in another Sheet and import them as a when required to your analysis using the method described here.

There are multiple ways to import data from one sheet to another in google sheets. The “QUERY” and “SORT” functions given below are unique to Google Sheets. You can use these functions to import data from one sheet to another in Google Sheets easily.

Refer to a single cell in another sheet

Like in any other spreadsheet, you can directly refer them in the formula typing sheet’s name followed by an exclamation mark and the cell is being copied. You can also use named ranges.

Include sheet name inside two single quotes if sheet name contains spaces.

Import range of data from one Sheet to another in Google Sheets

You can use formulas like QUERY or SORT when you want to import a range of data from another sheet of the same Google Sheet.

Use QUERY function to import data from one sheet to another in Google Sheets

The QUERY function is one of the most useful functions in Google Sheets. This function may be one reason for someone to move from Microsoft Excel to Google Sheets. You can use the QUERY function in multiple ways.

In the below examples, I will show you how you can use the QUERY function to pull data from another sheet. You can import either the entire range or a few columns that require your analysis. This is the simplest use of the Google Sheets QUERY function.

In the QUERY function, you need to give your data range as the first parameter. Then you can write your query (SQL Code) as the second parameter.

If your data is in a tab named as “ Sheet 3″ and the data range is “ A1:Y “, your data range can be referred from another tab as ‘Sheet 3’!A1:Y

Case 1: Import all the data in the range

The SQL code “ SELECT * ” retrieves all the columns in your range given as the first parameter. Your function should like below.

Case 2: Import only selected columns

You can modify the above formula by replacing the * with the column headings as shown below.

Use SORT function to sort and import data from one sheet to another in Google Sheets

You can sorts the rows of a given array or range by the values in one or more columns with the SORT function. You can use this SORT function also to import data from one sheet to another by sorting them in numerical or alphabetical order.

The following formula import data from the range “ Sheet2!A2:Y ” and sort the range by “customer name” in alphabetical order.

In this formula, the second parameter value “14” is the column number of the “customer name” column. By providing “true” or “false” for the third parameter, you can sort the range either ascending or descending order respectively.

Wrapping Up

Keeping your raw data untouched make your life easy when doing complex analysis. However, copying and pasting data every time is a tedious task. In that case, you can get the help of various Google Sheet functions to import data from other sheets to your analysis sheet.

In this post, I explained a few functions and methods that you can use to import data from one sheet to another in Google Sheets. You can customize those formulas depending on your requirement. And also these methods are not limited to the functions described above, you can also use functions like VLOOKUP, FILTER, etc… also to pull data from another sheet.

If you want to learn how to import data from one Google Sheet to another, or import data from CSV, you can read our other posts mentioned above.

Easily import data from other tabs and spreadsheets

How to import data from another google sheet

  • Facebook
  • Twitter
  • LinkedIn
  • Tweet
  • Share
  • Email

Before you can use Google Sheets to reference data from another sheet, you need to determine where that source data is coming from. If the data is in another tab inside the same spreadsheet, you only need to use a simple sheet reference to reference data from other sheets. If the data is in an entirely different Google Sheets file, you need to use a special spreadsheet key to pull data from another sheet.

Use Google Sheets to Pull Cell Data From Another Sheet

The most common reason people want to pull data from another sheet in Google Sheets is because those other tables are usually lookup tables.

For example, you might have one sheet that holds all of the products you sell along with their UPC code and unit price, while another sheet may contain a log of your sales. To calculate the total sale, you’ll need to pull pricing data from the product sheet.

Here’s how to do this:

In the original sheet where you want to pull data into, place your cursor in the cell where you’d like the data to go.

How to import data from another google sheet

Type = (the equal sign) into the cell. Select the second sheet and, then, the cell that contains the data you want to bring into the original sheet.

How to import data from another google sheet

Press Enter finish. This will bring the cell data you selected into the first spreadsheet.

How to import data from another google sheet

The final formula in this case is =Sheet2!C2. ‘Sheet2’ is the name of the sheet where the data comes from. This method is good for referencing individual cell data from a different spreadsheet into an original one.

Looking up Data From Another Google Sheets Spreadsheet

The method above works well to pull individual cell data from one sheet into another, but what if you want to look up data from the other sheet?

In the original sheet where you want to pull data into, place your cursor in the cell where you’d like the data to go, then type =VLOOKUP( into the cell. Formula syntax help will appear.

How to import data from another google sheet

For the search_key, select the cell in the original sheet you want to use as the lookup.

Type a comma (,) and switch to the sheet you want to pull data from. For range, select the entire range of cells you want to use as the lookup table.

How to import data from another google sheet

Type a comma (,) again, and for the index, type the number of the column that contains the data you want to retrieve from the second spreadsheet.

How to import data from another google sheet

Finally, type ,FALSE). This finishes the formula with a parameter that says the data in the other sheet isn’t sorted. If the data is sorted, then you’d make this TRUE.

How to import data from another google sheet

Press Enter and you’ll see that the resulting Unit Price comes from the appropriate data cell from the other spreadsheet. Fill in the rest of the cells using this same formula.

How to import data from another google sheet

This should fill out all of the correct data values, pulled in from the other spreadsheet, into the original sheet.

Pull Cell Data From a Different Spreadsheet File

While all of the formulas above work well for pulling data from another spreadsheet tab in the same Google Sheets file, you can also reference data from a different spreadsheet file.

To pull in data from another Google Sheets file, you need to use the IMPORTRANGE formula.

Before you can use the IMPORTRANGE formula, you’ll need the URL link to the Google Sheets file where you want to reference data. Highlight and copy the URL link to the end of the long code before the last forward slash (/) in the URL.

How to import data from another google sheet

In the original sheet where you want to pull data to, place the cursor in the destination cell and type:

=IMPORTRANGE(“URL”

Be sure to replace URL in this formula with the URL you want to reference.

How to import data from another google sheet

Follow the quotes after the URL with a comma (,), then type the name of the sheet and the cell you want to get data from.

In this example you’d enter:

=IMPORTRANGE(“URL”,”Sheet1!C2″).

Again, URL would be a full URL. We’re just keeping it short for example purposes.

How to import data from another google sheet

Press Enter. You’ll see that the data from the other Sheets spreadsheet file is pulled into this spreadsheet.

How to import data from another google sheet

You can use this same IMPORTRANGE function inside a VLOOKUP function to perform the same lookup method described in the previous section. This allows you to perform a VLOOKUP using data from another Google Sheets file.

How to import data from another google sheet

Written by Laura Tennyson

Google Sheets has transformed the way many of us work with spreadsheets. Instead of working in private, offline files, we can now collaborate with co-workers in real-time, in shared sheets. Emailing attachments and checking file versions are no longer necessary thanks to the cloud. And with powerful formulas like Importhtml you can pull live data directly into your spreadsheet from the internet, allowing you to create dashboards and charts. When you want to import Google Sheets data into another spreadsheet, however, the inbuilt functions are somewhat limited.

Google Sheets Importrange formula allows you to import a range of cells from one sheet to another and it’s great for one-off data transfers. But if you’ve ever tried to process large datasets or multiple imports, you’ll know that Importrange can struggle, leaving you with a bunch of error messages and a frozen spreadsheet.

If you want a simpler and more reliable way to import Google Sheets data into another Google Sheets file (or Excel file) you can connect your files and transfer data between them automatically. This enables you to:

  • Import data from one Google Sheets file into another
  • Pull data from Google Sheets into Excel
  • Share data with colleagues — without sharing your spreadsheet
  • Save time on copy-pasting and manual work
  • Combine data from multiple Google Sheets into one
  • Generate automated reports and dashboards
  • Control data access

How to import Google Sheets data

How to import data from another google sheet

Step 1: Open Sheetgo

Click on the blue button below to open Sheetgo.

Log in and click +Create workflow > Connect.

At the top of the screen, give the Untitled workflow a name so you can identify and edit the workflow later.

Easily import data from other tabs and spreadsheets

How to import data from another google sheet

  • Facebook
  • Twitter
  • LinkedIn
  • Tweet
  • Share
  • Email

Before you can use Google Sheets to reference data from another sheet, you need to determine where that source data is coming from. If the data is in another tab inside the same spreadsheet, you only need to use a simple sheet reference to reference data from other sheets. If the data is in an entirely different Google Sheets file, you need to use a special spreadsheet key to pull data from another sheet.

Use Google Sheets to Pull Cell Data From Another Sheet

The most common reason people want to pull data from another sheet in Google Sheets is because those other tables are usually lookup tables.

For example, you might have one sheet that holds all of the products you sell along with their UPC code and unit price, while another sheet may contain a log of your sales. To calculate the total sale, you’ll need to pull pricing data from the product sheet.

Here’s how to do this:

In the original sheet where you want to pull data into, place your cursor in the cell where you’d like the data to go.

How to import data from another google sheet

Type = (the equal sign) into the cell. Select the second sheet and, then, the cell that contains the data you want to bring into the original sheet.

How to import data from another google sheet

Press Enter finish. This will bring the cell data you selected into the first spreadsheet.

How to import data from another google sheet

The final formula in this case is =Sheet2!C2. ‘Sheet2’ is the name of the sheet where the data comes from. This method is good for referencing individual cell data from a different spreadsheet into an original one.

Looking up Data From Another Google Sheets Spreadsheet

The method above works well to pull individual cell data from one sheet into another, but what if you want to look up data from the other sheet?

In the original sheet where you want to pull data into, place your cursor in the cell where you’d like the data to go, then type =VLOOKUP( into the cell. Formula syntax help will appear.

How to import data from another google sheet

For the search_key, select the cell in the original sheet you want to use as the lookup.

Type a comma (,) and switch to the sheet you want to pull data from. For range, select the entire range of cells you want to use as the lookup table.

How to import data from another google sheet

Type a comma (,) again, and for the index, type the number of the column that contains the data you want to retrieve from the second spreadsheet.

How to import data from another google sheet

Finally, type ,FALSE). This finishes the formula with a parameter that says the data in the other sheet isn’t sorted. If the data is sorted, then you’d make this TRUE.

How to import data from another google sheet

Press Enter and you’ll see that the resulting Unit Price comes from the appropriate data cell from the other spreadsheet. Fill in the rest of the cells using this same formula.

How to import data from another google sheet

This should fill out all of the correct data values, pulled in from the other spreadsheet, into the original sheet.

Pull Cell Data From a Different Spreadsheet File

While all of the formulas above work well for pulling data from another spreadsheet tab in the same Google Sheets file, you can also reference data from a different spreadsheet file.

To pull in data from another Google Sheets file, you need to use the IMPORTRANGE formula.

Before you can use the IMPORTRANGE formula, you’ll need the URL link to the Google Sheets file where you want to reference data. Highlight and copy the URL link to the end of the long code before the last forward slash (/) in the URL.

How to import data from another google sheet

In the original sheet where you want to pull data to, place the cursor in the destination cell and type:

=IMPORTRANGE(“URL”

Be sure to replace URL in this formula with the URL you want to reference.

How to import data from another google sheet

Follow the quotes after the URL with a comma (,), then type the name of the sheet and the cell you want to get data from.

In this example you’d enter:

=IMPORTRANGE(“URL”,”Sheet1!C2″).

Again, URL would be a full URL. We’re just keeping it short for example purposes.

How to import data from another google sheet

Press Enter. You’ll see that the data from the other Sheets spreadsheet file is pulled into this spreadsheet.

How to import data from another google sheet

You can use this same IMPORTRANGE function inside a VLOOKUP function to perform the same lookup method described in the previous section. This allows you to perform a VLOOKUP using data from another Google Sheets file.