Is there an Excel version of IMPORTRANGE?
No. Google Sheets IMPORTRANGE pulls a range from another spreadsheet by URL. Microsoft Excel does not implement =IMPORTRANGE().
If you searched for any of these, this guide is for you:
- excel version of importrange
- excel importrange equiv / equivalent
- importrange equivalent for excel
- alternative to importrange in google sheets (when migrating to Excel)
Use the free pillar page: Excel IMPORTRANGE equivalent.
Best Excel equivalent: Power Query
- Open the destination workbook in Excel.
- Data → Get Data → From File → From Workbook (or From Folder for many files).
- Select the sheet or table, transform if needed, then Close & Load.
- When the source changes, right-click the query → Refresh.
This is the closest live equivalent to Sheets IMPORTRANGE on desktop Excel (Microsoft 365 / Excel 2016+).
Lighter option: workbook links
With both workbooks open:
='[Source.xlsx]Sheet1'!A1:D100
Links work well on a shared drive or OneDrive. They break more easily than Power Query when files move or are renamed.
When to stay on Google Sheets
If your team already syncs many files with IMPORTRANGE on Google Workspace, staying on Sheets is often cheaper than rebuilding every pull in Excel.
Check other formulas when migrating
After you replace IMPORTRANGE with a query load, paste remaining formulas into the Excel Formula Converter to catch Sheets-only functions (QUERY, ARRAYFORMULA, etc.).
Related pages: