The "Key" to the IMPORTRANGE formula for Google Sheets is the document's Sharing key. The document's sharing key is a unique identifier used by Google Apps.
The spreadsheet key is long sequence of characters in the "key=" attribute of the URL or between the slashes in the URL of the desired spreadsheet.
The spreadsheet key highlighted in red.
docs.google.com/spreadsheets/d/1IAP4HOacD4Az6q_PFfZgIX7lZVoHrRKM9KBX-IMO25s/edit?usp=sharing
The range_string
references the specific cell or cells you want to include in your sheet. "Sheet1!A2"
= Sheet1 Cell A2
"Sheet1!A2:B6" = Sheet 1 Cells A2:B6
"My tab name!A2" = Sheet "My tab name" cell A2
Note: The sheet_name
part of the range_string
is optional; by default the IMPORTRANGE formula
in Google spreadsheets will import from the given range of the first sheet.
Variables you need for the IMPORTRANGE formula in Google Sheets:
Spreadsheet Key - 1IAP4HOacD4Az6q_PFfZgIX7lZVoHrRKM9KBX-IMO25s
Sheet Name - Sheet1
Cell to Pickup - A1
IMPORTRANGE ( "spreadsheet_key", "range_string" )
Make sure to enclose both variables in Quotes " "
Importrange is one of a bunch of cool new formulas in Google Sheets. Here's our Blog post on the top features in the new Google Sheets and how to enable them.