How To Import One Google Spreadsheet Into Another

Google Spreadsheet is a very powerful tool. Those are commonly used for our official or personal purposes. Google sheets can be easily 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 can not be the same, and we always required some amount of data from one sheet to make the analyzation reports, we can also import multiple spreadsheets into one, for preparing multiple reports. But importing multiple spreadsheets may slow down the spreadsheet a bit. 
Importing Data from another sheet using “import range”
Google Spreadsheet has a number of functions, to make our work simpler. Any kind of calculations can be done in Google Spreadsheet. Array, Text, Filter, Lookup, Parser etc. 
 
Which I will be posting in details in my next articles. You can follow my website for those updates.


Amongst all the functions, we will here be looking into, how to import one spreadsheet data into the another one.


Function 

=ImportRange

Import 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 Spreadsheet “student_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)”.

Hoping this tutorial could be helpful. Do let me know your feedback into the comment section or any queries. will be happy to help out.

One Response

Reply

CommentLuv badge