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.
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 “
sheet!range: It is the range of cells in the sheet which you want to import from.
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:
It’s the same as in Microsoft Excel.