SumTips

Google Docs: Import Data from One Spreadsheet into Another

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)

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.