Google Docs: Import Data from One Spreadsheet into Another

Print Page

Google Docs has a handy ImportRange function that lets you pull in data from one spreadsheet into another. You can use this function to reference one or more cell values from a sheet.

ImportRange syntax:

=importRange(spreadsheet_key, sheet!range)
  • spreadsheet_key : It is the value in the key= attribute on the URL of the target spreadsheet. For example, the key for URL https://docs.google.com/spreadsheet/ccc?key=0AlFzmmp2Q2x4NGFOc19GekE is “0AlFzmmp2Q2x4NGFOc19GekE“.
  • sheet!range : It is the range of cells in the sheet which you want to import from.

Example:

=ImportRange("0AlFzmmp2Q2x4NGFOc19GekE", "Sheet2!A1:C10")

Import data from another worksheet in the same spreadsheet

If you want to import data from another worksheet in the same spreadsheet (workbook), use the following formula:

=Sheet2!A1:C10

It’s the same as in Microsoft Excel.