Excel ↔ Google Sheets function equivalents

Moving a formula between Excel and Google Sheets? Most functions are identical — VLOOKUP, SUMIFS, INDEX/MATCH, IF, the whole everyday toolkit works the same name, same arguments. This page covers the ones that don’t, in both directions, with the verified replacement to use instead.

Need it for one specific formula? Paste it into the compatibility checker and pick a target app for an instant migration report.

Only in Google Sheets — what to use in Excel

Google Sheets	Excel equivalent
`QUERY`	No single equivalent. Use FILTER for SELECT/WHERE; add SUMIFS/UNIQUE/SORT for grouping and aggregation. For heavy reshaping, Power Query.
`ARRAYFORMULA`	Not needed — Excel 365 spills array expressions natively. Just write =A2:A10*B2:B10.
`REGEXMATCH`	No regex in Excel. Use ISNUMBER(SEARCH("text",A2)) for contains, or wildcards in COUNTIF/SUMIF.
`REGEXEXTRACT`	Use LEFT/MID/RIGHT with FIND, or TEXTBEFORE/TEXTAFTER (Excel 365).
`REGEXREPLACE`	Use SUBSTITUTE (by text), nested for multiple patterns.
`GOOGLEFINANCE`	No native equivalent. Excel 365 has the STOCKHISTORY function and Stocks data type for some of this.
`IMPORTRANGE`	Link workbooks with external references, or pull data via Power Query.
`IMPORTHTML`	Power Query: Data → From Web imports HTML tables and lists.
`IMPORTXML`	Power Query (Data → From Web) for structured web data.
`SPLIT`	TEXTSPLIT (Excel 365), or the Text to Columns wizard.
`JOIN`	TEXTJOIN(delimiter, TRUE, range) — same idea, works in both.
`FLATTEN`	TOCOL(range) in Excel 365 flattens a range to one column.

Full list: all Google Sheets functions not in Excel.

Only in Excel — what to use in Google Sheets

Excel	Google Sheets equivalent
`GROUPBY`	Not in Sheets yet. Use a pivot table, or SUMIFS/COUNTIFS over UNIQUE keys.
`PIVOTBY`	Use a pivot table, or QUERY with GROUP BY.
`STOCKHISTORY`	GOOGLEFINANCE(ticker, ...) pulls historical prices in Sheets.
`AGGREGATE`	No direct equivalent; SUBTOTAL covers the filter-aware subset, or FILTER out errors then aggregate.
`TEXTBEFORE`	Available in Sheets too; older sheets use LEFT(A2,FIND(delim,A2)-1).
`ARRAYTOTEXT`	TEXTJOIN(", ",TRUE,range) approximates it in Sheets.
`IMAGE`	Sheets has IMAGE(url) too — one of the few that matches.

Full list: all Excel functions not in Google Sheets.

Same name, watch the difference

Function	What differs between Excel and Sheets
`SORT`	Direction argument differs: Excel uses 1/-1 (asc/desc); Google Sheets uses TRUE/FALSE.
`WEEKDAY`	Both support the return-type argument, but be explicit about it — the default (Sunday=1) trips up weekend logic in both.
`TEXT`	Format codes mostly match, but locale affects date/number separators — a comma-decimal locale reads codes differently.
`CONCATENATE`	Works in both, but Sheets also allows CONCATENATE of a whole range; Excel's version is cell-by-cell (use CONCAT/TEXTJOIN).
`FILTER`	Same core behavior; the 'no matches' fallback argument exists in both (Excel 365), but error text differs.

A note on versions

Some “differences” are really just version age. XLOOKUP, FILTER, SORT, LET, LAMBDA and the dynamic-array family need Excel 2021 or 365 — current Google Sheets has had them for years, so a modern Sheet can be more compatible with these than an Excel 2019 install. Full support-by-version detail (including LibreOffice) is on each function page, and the app-level picture is in the Excel vs Google Sheets guide.