Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

This question already has an answer here:

Is there a way i can reference data from another google spreadsheet in google docs / drive ?

ie. spreadsheet-A, sheet 1, column A is a dynamic reference of spreadsheet-B, sheet 1, column E

Im not talking about coping and pasting the data, but referencing its values, in the same way that you could if you were using =e:e if they were in the same spreadsheet.

share|improve this question

marked as duplicate by Al E., codingbadger Apr 16 '13 at 14:59

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

up vote 31 down vote accepted

You can import data from another spreadsheet using the importrange() function:

=importrange(spreadsheet-key, range)

spreadsheet-key is part of the url of the spreadsheet that contains the data you want to import. It looks like "0AsaQpHJE_LShdFhSRWZBWWMxem1pZGxhWG1XZzlic0E". range defines the cells you want to import.

In your example, you would look for the spreadsheet-key in the URL of spreadsheet B, and then in spreadsheet A, cell A1, you would put:

=importrange("key-of-spreadsheet-b", "E:E")

Don't forget to surround the key and range with quotation marks.

share|improve this answer
Thanks, ive implemented a test here - SPREADSHEET1 & SPREADSHEET2 But if you make a change in sheet2 it dosnt seem to update in sheet1 any ideas why that might be ? – sam Apr 15 '13 at 16:07
An update on my previous comment - the updates between the two sheets seem to be delayed – sam Sep 5 '13 at 9:34
the delimiter is ; not , as in =importrange("key"; "Cell:Cell") – Rufinus May 31 '14 at 9:26
@Rufinus That depends on your locale. – William Jackson May 31 '14 at 12:47
Just because it took me a minute to figure out, if there are multiple sheets in the target you reference them like this '=importrange("spreadsheet-key", "Sheet-name! range")' – tom stratton Oct 14 '14 at 23:41

Not the answer you're looking for? Browse other questions tagged or ask your own question.