Select Page

I’ve been playing around a lot in Google Documents lately. Spreadsheets in Google Documents are perfect for keeping Family Budgets etc. because they’re centrally based and can be edited and changed by multiple users as and when they need to be.

However, what happens if you need to create a personal budget for use only by you and still use some of the information from another ‘file’ in Google Documents?

Here’s what I found works. If you have other formulae drop a comment and share!

Well, it turns out that you can import data across multiple Google Documents to streamline processes and make life generally more bearable and managed.

Note If you do not have permission/access to the document you’re bringing data from this will not work.

Every spreadsheet in Google Documents has a key, this is similar to a uniquely assigned file name.

Take a look at the address bar of the Google Document Spreadsheet with the data you need in it. It should look something like this: (some letters have been changed)

I put the key in bold, italics for you, in case the “key=” wasn’t enough of a clue for you 🙂

You’ll need to highlight and copy this key.

In your second spreadsheet you’ll need a formula, I used the importrange but I’m sure you can use others.

=importrange(“0At3Haem3Sd88dDJ0dUgxa3VTWGFkQUhCNzQxanVMemc“, “Sheet1!d21”)

In plain english:

=importrange(“Document Key”, “Worksheet name!cell number”)

This brings the data from another file (static or dynamic cell data) and loads it into your file and your cell.

It’s really handy!

Enhanced by Zemanta

Author: Andy Quayle

Andy was born in the Isle of Man and currently lives in Pittsburgh.
Known globally as a willing source for tech news and views, Andy takes great pride in consultation and education.

Should his schedule permit, Andy is available to help you with your SEO and Web Analytics needs.