IMPORTRANGE in Excel? Rebuild with Power Query | ComTools

Excel has no IMPORTRANGE. Full IMPORTRANGE equivalent for Excel walkthrough: /excel-importrange-equivalent (Power Query or links).

Excel does not support IMPORTRANGE

Imports a range from another Google spreadsheet. Excel has no IMPORTRANGE—use Power Query, Get Data, or workbook links instead.

Recommended Excel alternatives

1) Power Query Get Data From Workbook 2) Workbook links 3) Copy/paste values for one-off pulls. Full walkthrough: /excel-importrange-equivalent.

Convert related formulas

Paste Sheets formulas into /excel-formula-converter to see which functions Excel supports after you replace IMPORTRANGE with a query load.

FAQ

QDoes Excel have IMPORTRANGE?

No. Use Power Query or workbook links—see /excel-importrange-equivalent.