Import Google Spreadsheet data into another spreadsheet

Google added a new function called “importRange” into Google Spreadsheets, that’ll import your saved data from a Google Docs spreadsheet into another spreadsheet. Say, you’ve a spreadsheet with following URL: spreadsheets.google.com/ccc?key= pvm6FPiylicLb_2cwmpkHfw&hl=en….just define a range to make referring to this data easier named “PeopleAges” . In your second spreadsheet, edit a cell and copy the key of above URL as first parameter. The second parameter will […]

Share online:

Google added a new function called “importRange” into Google Spreadsheets, that’ll import your saved data from a Google Docs spreadsheet into another spreadsheet. Say, you’ve a spreadsheet with following URL:

spreadsheets.google.com/ccc?key=
pvm6FPiylicLb_2cwmpkHfw&hl=en
….just define a range to make referring to this data easier named “PeopleAges” . In your second spreadsheet, edit a cell and copy the key of above URL as first parameter. The second parameter will be the range name:
=importRange("pvm6FPiylicLb_2cwmpkHfw", "PeopleAges")

….now hit return on the above formula, the second spreadsheet will briefly display a “loading” message and then shows the age data from the other spreadsheet.

German GoogleWatchBlog reports, Google added a split function to split a string into an array, and they now allow you to search and replace in spreadsheets.

Source:→ Google Blogoscoped

About The Author

Deepak Gupta is a IT & Web Consultant. He is the founder and CEO of diTii.com & DIT Technologies, where he's engaged in providing Technology Consultancy, Design and Development of Desktop, Web and Mobile applications using various tools and softwares. Sign-up for the Email for daily updates. Google+ Profile.