Google Sheets IMPORTRANGE Function Guide | ComTools

What IMPORTRANGE does in Google Sheets. For an alternative to IMPORTRANGE in Google Sheets (QUERY, Apps Script) see the blog; Excel equivalent is Power Query.

What is IMPORTRANGE?

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

Excel compatibility

On Excel, IMPORTRANGE is not supported. Excel IMPORTRANGE equivalent: Data > Get Data (Power Query) from workbook/folder/web, or paste links between workbooks. See /excel-importrange-equivalent.

Migration path

Replace live IMPORTRANGE pulls with Power Query connections before converting other Sheets-only functions. Pillar guide: /excel-importrange-equivalent.

FAQ

QIs IMPORTRANGE available in Excel?

No. Status: Not supported. Alternative: Power Query / links.

QWhat is an alternative to IMPORTRANGE in Google Sheets?

QUERY/FILTER wrappers, Apps Script, Connected Sheets. Long guide: /Blog/excel-importrange-equivalent-en. Excel: /excel-importrange-equivalent.