How To Import One Google Spreadsheet Into Another

Before getting into how to import one google spreadsheet into another, let us see the features of it. Google Spreadsheet is a very powerful tool. Those are commonly used for our official or personal purposes.

Google sheets can be quickly and safely managed online with our Gmail Account, and which can be accessed from our Google Drive, about which I had already posted in one of my articles.

It has too many features, but most of the people use with its very limited potential. We will discuss one simple one, about which we all think of but technically don’t know how to do it. It is about “how could we view data from one spreadsheet into another one.”

Before getting into how to import one spreadsheet data into the another one, Let us know why is it required to import the sheets.

Why Google Spreadsheet need to be imported

At the workplace, we work on the several Google spreadsheets, as all the spreadsheets are created for showing different statistics. And most of the time we required some amount of data from one sheet to make the reports.

We can also import multiple spreadsheets into one, for preparing various reports.

How To Import One Google Spreadsheet Into Another

Importing Data from another sheet using “import range.”
Google Spreadsheet has some number of functions, to simplify our work. Any calculations can be done in Google Spreadsheet. Array, Text, Filter, Lookup, Parser, etc
 
Amongst all the functions, we will here be looking into, how to import one spreadsheet data into the another one.

Pull Data from Another Spreadsheet

Google allows us to pull data from another spreadsheet by using a small piece of code(function) as mentioned below. The range of the data can also be defined according to our requirement in case you don’t want to import the entire sheet.

Function: 
=ImportRangeImport range
With the use of “=importrange”, we can import multiple spreadsheet data. So now the question is how to just mention “=importrange” another sheet can get imported. So for importing a particular spreadsheet, we have to make it identical, we need to mention the spreadsheet key, name, and range.

For an instance
=ImportRange(“SpreadsheetKey”,”Sheet!Range”)

Assume we have a document, called “students_marks”, and this data need to be imported into the other blank document in which we are supposed to add some more data along with the this imported one.


Example SpreadsheetStudent Marks

Import range key
Now the spreadsheet key which can be seen in the above image, need to be copied and should be provided in the blank new document (in which this data to be imported).
Import range

Next step is to mention the Sheet name and the range.
According to the provided document “student_marks”,  the final function should look like the below image. 

=IMPORTRANGE(“1CxxYXUEqrQ0ZNo96RaR40DXl3dUei0cQLTjMDadB7f8″,”students_Marks!A1:G8”)
Import Range

And now as we can see we have imported the “student_marks” data into “Untitled Spreadsheet (Blank Document)”.

Here we have seen how to import data one from another, you can follow the same process for importing data from multiple sheets as well to you master sheet.

Hoping this tutorial could be helpful. Do let us know if you use any other method to do so in the comment section below.

1

Don't Hesitate, Leave a Reply...!

Notify of
avatar
Sort by:   newest | oldest
wpDiscuz
Questioncage

Subscribe To QuestionCage

Glad to see your Visit at QuestionCage!

One more step to connect ahead "Subscribe to Us" and get the updates to your inbox directly.

You have Successfully Subscribed to QuestionCage!

0 Shares
Share
+1
Tweet
Stumble