Search code examples
google-sheetsformulas

Linking one google docs spreadsheet to another

I have data in one google docs. Call it docA.

I would like to reference this data in docB. Something along the lines of =docA!Sheet1!A2

How would I be able to go about this? I do not mind changing security settings and the like

Solution

  • First go to the spreadsheet that you want to import the data from (docA) and observe the value of the key mentioned in the URL (Eg: https://docs.google.com/spreadsheet/ccc?key=ABC#gid=0, in this case the key is "ABC").

    Now go to the cell in docB and use the importRange function to import the data.

    =importRange(, !:)

    Eg: =importRange("ABC", "Sheet1!A1:B10")

    If you want to import just one cell: E.g. =importRange("ABC", "Sheet1!A1");

    If you don't mention the name of the sheet, the first sheet is used.