28

This question already has an answer here:

Is there a way i can reference data from another Google Spreadsheet in Google Docs/Drive?

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

I'm not talking about copying 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.

marked as duplicate by ale, 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.

57

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.

  • 1
    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
  • 5
    the delimiter is ; not , as in =importrange("key"; "Cell:Cell") – Rufinus May 31 '14 at 9:26
  • 3
    @Rufinus That depends on your locale. – William Jackson May 31 '14 at 12:47
  • 7
    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
  • 1
    @sam while a late reply, this should be for others that just see this answer. It could be related to File > Spreadsheet settings... > Calculations > Recalculation – Christopher Rucinski Feb 16 '17 at 9:16

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