29

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.

ale
  • 52,972
  • 42
  • 165
  • 314
sam
  • 7,107
  • 42
  • 100
  • 140

1 Answers1

59

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.

William Jackson
  • 6,375
  • 1
  • 36
  • 44