Master Digital Marketing, WordPress, SEO
Unlock your potential with expert tips and in-depth guides. Stay ahead with the latest strategies in digital marketing, WordPress optimization, SEO.
Best practices, and essential tools to grow your online presence. Learn, apply, and thrive!
Before getting into how to import one Google spreadsheet into another, let us see the features of it. Google Spreadsheets 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 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 people use it 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’s data into another one, let us know why it is required to import the sheets.
At the workplace, we work on several Google spreadsheets, as all the spreadsheets are created to show 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.
Importing Data from another sheet using “import range.”Google Spreadsheets has several 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’s data into another one.
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:
=ImportRangeWith the use of “=importrange”, we can import multiple spreadsheets of 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 instance,
=ImportRange(“SpreadsheetKey”,”Sheet!Range”)Assume we have a document, called “students_marks”, and this data needs to be imported into the other blank document in which we are supposed to add some more data along with this imported one.
Example Spreadsheet “Student Marks“
Now the spreadsheet key, which can be seen in the above image, needs to be copied and should be provided in the blank new document (in which this data to be imported).
The 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 image below.
=IMPORTRANGE(“1CxxYXUEqrQ0ZNo96RaR40DXl3dUei0cQLTjMDadB7f8″,”students_Marks!A1:G8”)
And now, as we can see, we have imported the “student_marks” data into the “Untitled Spreadsheet (Blank Document)”.
Here we have seen how to import data from one another, you can follow the same process for importing data from multiple sheets as well to your 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.
