Skip to content
Google Sheets functionNot in Excel

IMPORTRANGE function in Excel

Excel doesn't have IMPORTRANGE — here's what does.

Excel links workbooks with external references instead of URLs — and for live feeds, Power Query is the real replacement.

What IMPORTRANGE does in Google Sheets

Imports a range of cells from a specified spreadsheet.

=IMPORTRANGE(spreadsheet_url, range_string)

Convert IMPORTRANGE formulas to Excel

Before and after, formula by formula.

  1. Pull a range from another workbook:

    Google Sheets
    =IMPORTRANGE("https://docs.google.com/spreadsheets/d/abc123", "Sheet1!A1:C100")
    Excel
    ='[Sales 2026.xlsx]Sheet1'!A1:C100

    External references need the source workbook reachable on disk, OneDrive, or SharePoint — Excel doesn't fetch by URL.

Worth knowing

  • For refreshable cross-workbook feeds, use Power Query (Data → Get Data → From Workbook) rather than a formula.

Converting more than one formula? The Excel ↔ Sheets translator rewrites whole workbooks and flags every IMPORTRANGE so none slip through silently.

Browse Google Sheets web functions

More conversions to Excel