IMPORTRANGE: Excel vs Google Sheets Compatibility | ComTools
Compare IMPORTRANGE on Google Sheets (supported) vs Excel (not supported). Excel equivalents: Power Query and workbook links.
Side-by-side support
Excel: Not supported. Google Sheets: Supported. Excel alternative: Power Query / Get Data / workbook links.
When to keep Sheets
If many files sync live via IMPORTRANGE across a team on Google Workspace, staying on Sheets is often cheaper than rebuilding every pull in Excel.
Convert now
Use /excel-formula-converter?fn=importrange and read /excel-importrange-equivalent for the Excel rebuild steps.
FAQ
QCan I use IMPORTRANGE on both platforms?
Only Google Sheets. Excel needs Power Query or links.