Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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., Barry 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.

1 Answer 1

up vote 9 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
ah good to know.. thanks. –  Rufinus May 31 '14 at 12:48

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