Google Blogoscoped

Wednesday, August 13, 2008

Import Another Google Spreadsheet’s Data

Google provides a new function for spreadsheets: importRange. This will import the data from a Google Docs spreadsheet you saved into another spreadsheet. For instance, my first spreadsheet has the URL

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

Hitting return on this formula, the second spreadsheet will briefly display a "loading" message and then shows the age data from the other spreadsheet.

Google already has a couple of functions to import data from websites, too (they're importData, importFeed, importHtml, importXml).

Also, as 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.

Advertisement

 
Blog  |  Forum     more >> Archive | Feed | Google's blogs | About
Advertisement

 

This site unofficially covers Google™ and more with some rights reserved. Join our forum!