Excel IMPORTRANGE Equivalent – Power Query & Links Guide | ComTools

Looking for an Excel version of IMPORTRANGE or an IMPORTRANGE equivalent for Excel? Use Power Query, Get Data, or workbook links. Free comparison guide + formula converter.

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.

FAQ

QWhat is the Excel equivalent of IMPORTRANGE?

Power Query Get Data from workbook/folder/web is the closest. Workbook formula links are a lighter alternative. There is no =IMPORTRANGE() in Excel.

QIs there an Excel version of IMPORTRANGE?

No native function. Rebuild the pull with Power Query or links. See also /google-sheets-functions/importrange and /excel-vs-google-sheets/importrange.

QAlternative to IMPORTRANGE in Google Sheets itself?

Within Sheets you can also use IMPORTRANGE + QUERY/FILTER, or Apps Script. Moving to Excel still requires Power Query/links.