Linking one google docs spreadsheet to another

google-sheets formulas
mhopkins321 picture mhopkins321 · Dec 23, 2012 · Viewed 92k times · Source

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

Answer

supreethwhoelse picture supreethwhoelse · Dec 23, 2012

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.

Related questions

Google SpreadSheet Query: Can I remove column header?

I'm doing this query at my google spreadsheet: =QUERY(H4:L35;"select sum(L) where H='First Week'"; -1) But it returns a little table with "sum" as header and result below it. What I want is just the result! …

Read More
How to format a duration as HH:mm in the new Google sheets

In the new Google sheets there's a way of formatting a number as a duration. Format -> Number -> Duration. 1 is formatted as 24:00:00 1.2 is formatted as 28:48:00 1.5 is formatted as 36:00:00 0.03125 is formatted as 0:45:00. I don't need the seconds in …

Read More
Google Sheets COUNTIF / COUNTIFS formulas based on multiple criteria

I'm looking for some expertise with formulas. I've got a raw data source and need to be able to summarise it in a separate sheet based on a number of different variables of both number and text formats. I've tried …

Read More