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.

0

1 Answer 1

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.

7
  • 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
    Commented Apr 15, 2013 at 16:07
  • 5
    the delimiter is ; not , as in =importrange("key"; "Cell:Cell")
    – Rufinus
    Commented May 31, 2014 at 9:26
  • 3
    @Rufinus That depends on your locale. Commented May 31, 2014 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")' Commented Oct 14, 2014 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 Commented Feb 16, 2017 at 9:16

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