Excel ↔ Google Sheets converter
Move formulas between Excel and Google Sheets
Paste a formula and choose where it needs to work. App-only functions are swapped for working equivalents, and every change is explained.
- Both directions
- Explains every change
- Version-aware for Excel
Your recent formulas
Saved in this browser only.
Cheat sheet
Common Excel and Google Sheets equivalents
| Excel | Google Sheets | Note |
|---|---|---|
| Dynamic array spill (365) | ARRAYFORMULA(…) | Sheets needs ARRAYFORMULA for most whole-column calculations. |
| TEXTSPLIT(A2, ",") | SPLIT(A2, ",") | Same idea, different name. |
| TEXTBEFORE(A2, " ") | REGEXEXTRACT(A2, "^[^ ]+") | Sheets has no TEXTBEFORE/TEXTAFTER. |
| PivotTable or GROUPBY | QUERY(A1:D, "select A, sum(D) group by A", 1) | QUERY does SQL-style summaries in one formula. |
| Link to another workbook | IMPORTRANGE("url", "Sheet1!A:C") | Sheets pulls data from another file by URL. |
| Stocks data type | GOOGLEFINANCE("NASDAQ:GOOG") | No direct formula equivalent in Excel. |
| Table[Column] references | A2:A or named ranges | Structured references become plain ranges. |
| REGEXTEST(A2, "…") | REGEXMATCH(A2, "…") | Sheets uses RE2, which has no lookarounds. |
More free spreadsheet tools
Everything you need when a formula gets in the way.
- Formula generatorDescribe it in plain English, get a working formula.Open tool
- Formula explainerPaste any formula and see what each part does.Open tool
- Formula fixerFix #N/A, #VALUE!, #REF! and wrong results.Open tool
- Clean my dataTrim, dedupe and tidy a table, privately in your browser.Open tool
- VBA & Apps ScriptMacros for Excel and scripts for Google Sheets.Open tool
- Regex formulasExtract, match and replace text with REGEX functions.Open tool
- Conditional formattingCustom-formula rules to highlight cells and rows.Open tool
Frequently asked questions
Which formulas need converting between Excel and Google Sheets?
Most everyday functions such as SUM, IF, VLOOKUP, XLOOKUP, SUMIFS and INDEX/MATCH work in both. Conversion is needed for app-specific functions: QUERY, ARRAYFORMULA, IMPORTRANGE and GOOGLEFINANCE in Sheets, and TEXTSPLIT, TEXTBEFORE, GROUPBY and table references in Excel.
Which way does it convert?
Both ways. Choose the app you want the formula for in "Convert to". Choose Excel and pick your version if you are moving a Sheets formula into Excel.
What if there is no exact equivalent?
The converter gives the closest working approach and explains what is different. For example, live stock prices from GOOGLEFINANCE need Excel's Stocks data type instead of a formula.
Do I need to change commas to semicolons?
Only if your region uses a comma as the decimal mark. Pick "Semicolon" and the result is shown that way.