diTii.com Digital News Hub

Sign up with your email address to be the first to know about latest news and more.

I agree to have my personal information transfered to MailChimp (more information)

Aug142008

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 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

Share This Story, Choose Your Platform!

Do NOT follow this link or you will be banned from the site!