IMPORTRANGE Equivalent for Excel – Power Query (Free)

IMPORTRANGE equivalent for Excel

The IMPORTRANGE equivalent for Excel is Power Query (Data → Get Data), not a worksheet function. Excel importrange equiv searches mean the same: there is no =IMPORTRANGE(). Rebuild with Get Data from workbook/folder/web, or workbook links.

There is no IMPORTRANGE in Excel

Google Sheets IMPORTRANGE pulls a range from another spreadsheet by URL. Microsoft Excel does not implement this function. Searching for an Excel version of IMPORTRANGE or importrange excel equivalent means you need a different feature—usually Power Query (Get Data) or workbook links.

Option 1: Power Query (best equivalent)

Data → Get Data → From File → From Workbook (or From Folder for many files). Select the sheet/table, transform if needed, Close & Load. Refresh when the source changes—closest to live IMPORTRANGE for desktop Excel.

Option 2: Workbook links

Open both workbooks and reference ='[Source.xlsx]Sheet1'!A1:D100. Links work when files stay on a shared path/OneDrive. They break more easily than Power Query when files move.

Option 3: Stay in Google Sheets

If cross-file live sync is mandatory and both files are Sheets, keep IMPORTRANGE. Use ComTools formula converter to check which other functions need rewriting when you migrate formulas to Excel.

Alternative to IMPORTRANGE inside Google Sheets

If you are not migrating: wrap IMPORTRANGE in QUERY or FILTER so less data is pulled; use Apps Script for scheduled copies; or Connected Sheets for BigQuery. Full comparison of every alternative to IMPORTRANGE: /Blog/excel-importrange-equivalent-en (中文 /Blog/excel-importrange-equivalent).

FAQ