Import data from another spreadsheet
|
If you keep data in separate Google Sheets, copy a range of data from one spreadsheet to another with the IMPORTRANGE function. For example, you may track quarterly sales data for a product in a different spreadsheet for each region. To combine all that quarterly sales data, copy the data from each region's spreadsheet into a single spreadsheet using IMPORTRANGE. |
Use the IMPORTRANGE function

For example: To import cells A1 through C10 from sheet 1 of the abcd123abcd123 spreadsheet, you enter: =IMPORTRANGE("abcd123abcd123", "sheet1!A1:C10") |
Was this helpful?
How can we improve it?