How to Import Data From one Google Sheet to Another

Author: Rahul | Guide: Google Sheets |

Every Google Sheets user will come across a situation when they need to import a certain data range from another sheet, or even a spreadsheet, in order to build a combined master view of both. This allows you to combine data from numerous worksheets into a single one. Some users may additionally wish for their master document for example Budgeting sheet, to update automatically when there is any change in any other attached sheets i.e expense sheet.

For this automatic update, many a time you need to import data from one google sheet to the other. This might sound very difficult to do but it is actually very easy.

In this article, we will look at How to Import Data From one Google Sheet to Another.

Import Data From one Google Sheet to Another: 5 Steps 

Step 1 - Open google sheets app: Let's start by getting you familiar with the Google Sheets application. Its logo resembles an A4-sized green sheet of paper. There is a small fold in the top-right corner.

  • It is surrounded by white-defined cells. Go to the play store app if you can't locate it on your device.
  • Type 'Google Sheets' into the search bar.
  • Look for the icon described, click install, and wait for it to download.
  • After that, open it to continue.

image titled Import Data From one Google Sheet to Another step 1

Step 2 - Tap on any cell: Now, you have the sheet onto which you want to import the data from any other sheet. Locate the cell to import data. You select the cell, just Left-Click on it. You can be sure the cell is selected when you see a blue rectangle on it.

image titled Import Data From one Google Sheet to Another step 2

Step 3 - Tap on fx option: We'll start with accessing the fx icon. You will find the fx Function in the bottom left corner of the sheet. It will show us a prompt for inserting inputs. Inputs can be formulas of all different sorts, for example, "SUB" is used for subtracting, "AVG" for finding the average of 2 or more numbers, etc.

  • The fx icon will provide you with a pulldown menu that contains all the formulas used in Google Sheets.
  • Selecting any of them will automatically add them to your spreadsheet.

image titled Import Data From one Google Sheet to Another step 3

Step 4 - Click on the search option: Once in the fx menu, find the search on it, to find different functions. For the purpose of importing data, find the function "IMPORTDATA".

  • Click on the Search icon in the Formula bar and type '=IMPORTDATA' to add this function.
  • There will be a list of formulas.  All you need to do is drag this formula down to any cell or cells you want it applied to.
  • Google Sheets has a built-in IMPORT function that works for one variable, but if you want to import an entire column or row, then you will have to create your formula for this purpose.

 

image titled Import Data From one Google Sheet to Another step 4

Step 5 - Click on IMPORT DATA: Its a roller-coaster ride from here. Just tap on the "IMPORTDATA" and you are good to go.

image titled Import Data From one Google Sheet to Another step 5

 

Conclusion

In the end, this is what might happen if you don't create an "IMPORTDATA" formula on your spreadsheet. You'd need to type in all the data manually. It can be time-consuming. You also might make mistakes while typing in all the numbers and then need to start over.
Importing data from one sheet to another might sound tedious task. But it is very simple.

Was this article helpful ?

No