How to Use the Google Sheets to Excel Formula Converter

Type a Google Sheets function name into the search box (e.g.
QUERY
,
VLOOKUP
,
ARRAYFORMULA
).
The table filters live as you type — no separate "convert" button needed.
Read the Excel column: either the equivalent function name (with any version caveats noted), or a clear No direct equivalent badge.
Nothing you type is uploaded anywhere — this is a static reference table filtered entirely in your browser.

Why This Tool Exists

Google Sheets and Excel share a huge amount of formula syntax —

SUM

IF

VLOOKUP

work identically in both — which makes it easy to assume every Sheets function has a one-to-one Excel counterpart. It doesn't. Some of Sheets' most-used functions (

QUERY

ARRAYFORMULA

IMPORTRANGE

, the whole

IMPORT*

family) were built specifically around Google's cloud/web-connected architecture and have no direct Excel equivalent at all — not a differently-named function, not a close approximation, nothing. Presenting a fake "equivalent" for these would actively mislead anyone migrating a real spreadsheet. This tool states that honestly, function by function, rather than inventing a mapping to look complete.

Functions That Match Exactly (or Nearly)

A large group of commonly used functions are either identical in both products (

VLOOKUP

INDEX

MATCH

SUMIFS

COUNTIFS

IFERROR

) or share the same name with only a version-availability caveat — for example

IFS

TEXTJOIN

, and

SEQUENCE

all exist in Excel under the identical name, but only in Excel 2019 / Microsoft 365, not in older perpetual-license Excel 2016 and earlier.

UNIQUE

SORT

, and

FILTER

are dynamic-array functions in both products' current versions, with matching syntax.

Functions With No Direct Excel Equivalent

These Google Sheets functions genuinely have nothing that maps to them one-to-one in Excel:

ARRAYFORMULA
— Sheets uses this as an explicit wrapper to force a formula to operate on an entire range at once. Modern Excel (Microsoft 365) achieves the equivalent result through automatic array "spilling" — but that's a different underlying mechanism, not a matching function you'd swap in.
QUERY
— Sheets' SQL-like query language inside a single cell has no Excel counterpart; the closest you can get in Excel is combining
FILTER
/
SORT
, or switching to Power Query/PivotTables entirely.
IMPORTRANGE
,
IMPORTXML
,
IMPORTHTML
,
IMPORTDATA
— this whole family pulls live data from other sheets or the open web directly inside a formula. Excel's equivalent capability lives in a completely different tool (Power Query / Get & Transform), not a drop-in formula.
GOOGLEFINANCE
— Excel's closest analog is the
STOCKHISTORY
function plus linked stock data types, but the syntax, available fields, and data source are all substantially different — not a direct swap.
SPARKLINE
— in Sheets this is a cell formula; in Excel, sparklines are a chart-style feature you insert via the ribbon (Insert → Sparklines), not something you type into a cell.
GOOGLETRANSLATE
,
DETECTLANGUAGE
— Excel has no built-in translation or language-detection function at all.

A Recent Exception: Excel Finally Got Native Regex

Until 2024, Sheets'

REGEXMATCH

REGEXEXTRACT

REGEXREPLACE

were a clean example of "no Excel equivalent." That changed: Microsoft shipped native

REGEXTEST

REGEXEXTRACT

, and

REGEXREPLACE

functions to Excel starting in 2024 — but only in Microsoft 365 (the subscription version and Excel for the web). If you're on a perpetual-license Excel 2021, 2019, or earlier, these still don't exist for you, and the honest answer for those versions is still "no direct equivalent."

Frequently Asked Questions

Is this list complete? No single reference table can cover every function in both products — this covers the ones people search for most often, verified against official Microsoft and Google documentation, and it will keep growing.

Why do some rows show the SAME function name on both sides? Because that function genuinely exists with identical syntax in both products (e.g.

VLOOKUP

) — the row confirms there's nothing to convert, which is itself useful information.

Is my search uploaded or stored anywhere? No. The table is static reference data filtered entirely as JavaScript in your browser tab — nothing is sent to a server, logged, or stored.

Is this tool free? Yes, completely free, no login, no limit.

Google Sheets	Excel	Note
VLOOKUP	VLOOKUP	Identical syntax and behavior in both.
XLOOKUP	XLOOKUP	Identical syntax. Added to Sheets in Aug 2022; in Excel via Microsoft 365 (2019+).
INDEX	INDEX	Identical syntax and behavior in both.
MATCH	MATCH	Identical syntax and behavior in both.
SUMIFS	SUMIFS	Identical syntax and behavior in both.
COUNTIFS	COUNTIFS	Identical syntax and behavior in both.
IFS	IFS	Identical syntax. Excel 2019 / Microsoft 365 only — not in Excel 2016 or earlier.
IFERROR	IFERROR	Identical syntax and behavior in both.
TEXTJOIN	TEXTJOIN	Identical syntax. Excel 2019 / Microsoft 365 only.
UNIQUE	UNIQUE	Identical syntax. Both are dynamic-array functions in their current versions.
SORT	SORT	Identical syntax. Both are dynamic-array functions in their current versions.
FILTER	FILTER	Identical syntax. Both are dynamic-array functions in their current versions.
SEQUENCE	SEQUENCE	Identical syntax. Microsoft 365 only in Excel.
SPLIT	TEXTSPLIT	Similar purpose, different syntax (SPLIT splits into columns by a delimiter; TEXTSPLIT is Microsoft 365 only — older Excel needs Text to Columns or formulas instead).
REGEXMATCH	REGEXTEST	Similar purpose. Excel's REGEX functions shipped in 2024, Microsoft 365 only — not in Excel 2021/2019 or earlier.
REGEXEXTRACT	REGEXEXTRACT	Same name, similar purpose. Microsoft 365 only, added 2024.
REGEXREPLACE	REGEXREPLACE	Same name, similar purpose. Microsoft 365 only, added 2024.
ARRAYFORMULA	No direct equivalent	No direct Excel equivalent. Modern Excel (365) auto-spills array formulas without needing a wrapper function — the two products solve the same problem with different mechanisms, not a matching function.
QUERY	No direct equivalent	No direct Excel equivalent. QUERY's SQL-like syntax has no single-function match; Excel users typically combine FILTER/SORT or use Power Query/PivotTables instead.
IMPORTRANGE	No direct equivalent	No direct Excel equivalent. Excel links to other workbooks via external cell references or Power Query, not a single formula function.
IMPORTXML	No direct equivalent	No direct Excel equivalent. Excel would use Power Query (Get & Transform) to pull structured web data instead of a formula.
IMPORTHTML	No direct equivalent	No direct Excel equivalent. Excel would use Power Query to import an HTML table instead of a formula.
IMPORTDATA	No direct equivalent	No direct Excel equivalent. Excel would use Power Query or a manual CSV/data import instead of a formula.
GOOGLEFINANCE	No direct equivalent	No direct Excel equivalent. Excel's closest analog is the STOCKHISTORY function plus linked stock data types, but the syntax, data source, and coverage all differ substantially.
GOOGLETRANSLATE	No direct equivalent	No direct Excel equivalent — Excel has no built-in translation function.
SPARKLINE	No direct equivalent	No direct formula equivalent. Excel implements sparklines as a chart-style feature (Insert > Sparklines), not a cell formula.
DETECTLANGUAGE	No direct equivalent	No direct Excel equivalent — Excel has no built-in language-detection function.