Working with remote and in-office colleagues? Learn how to thrive in hybrid work environments.

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

  1. In Sheets, open a spreadsheet.
  2. In an empty cell, enter =IMPORTRANGE.
  3. In parenthesis, add the following specifications in quotation marks and separated by a comma*:
    • The URL of the spreadsheet in Sheets.
    • The sheet name (optional) and the range of cells to import.

    *Note: If you are in a Spanish-speaking country, use the semicolon as a separator instead of the comma.

  4. Press Enter.
  5. Click Allow access to connect the 2 spreadsheets.

For example:

To import cells A1 through C10 from sheet 1 of the abcd123abcd123 spreadsheet, you enter: =IMPORTRANGE("", "sheet1!A1:C10")

Was this helpful?
How can we improve it?
Clear search
Close search
Google apps
Main menu
Search Help Center