What the Excel and Google Sheets Formula Converter does
Excel and Google Sheets share most function names, so many formulas work in both without change. The differences appear in text functions, array handling, regular expressions, and a few functions that exist in only one program. The converter replaces the functions it knows how to translate and adds a note when a formula needs manual work.
Use it when a colleague shares a Google Sheet that you need to rebuild in Excel, when you publish an Excel template for Sheets users, or when a formula copied from a European locale uses semicolons between arguments.
How to use it
- Choose the direction: Excel to Google Sheets, or Google Sheets to Excel.
- Paste the formula into the input box. You can also start from one of the examples.
- Read the converted formula and any notes shown below it.
- Copy the result into the other program and test it on a few rows.
- If a note says there is no equivalent, rebuild that part manually, for example with FILTER or Power Query in place of QUERY.
Worked examples
Splitting text
Input: =SPLIT(A2,",") in Google Sheets
Result: =TEXTSPLIT(A2,",") in Excel
Why: Both split the text in A2 at each comma and spill the parts across columns. TEXTSPLIT is available in Microsoft 365 and Excel for the web.
Joining a range
Input: =JOIN(", ",A2:A5) in Google Sheets
Result: =TEXTJOIN(", ",FALSE,A2:A5) in Excel
Why: TEXTJOIN needs a second argument that says whether to skip empty cells. FALSE keeps them, which matches how JOIN behaves.
Regional separators
Input: =IF(A2>0;"Yes";"No")
Result: =IF(A2>0,"Yes","No")
Why: Some locales use semicolons between arguments. English-locale Excel and Sheets expect commas, so the separators are replaced.
What the conversion notes mean
- No equivalent
- QUERY and IMPORTRANGE have no single Excel function. FILTER, SORT, Power Query or a linked workbook are the usual replacements.
- ARRAYFORMULA removed
- In Microsoft 365, a formula such as =A2:A10*B2:B10 spills on its own, so the wrapper is not needed.
- REGEXMATCH to REGEXTEST
- Excel added REGEXTEST to Microsoft 365. Older Excel versions do not have a regular expression function.
- Version required
- TEXTSPLIT, FILTER and other dynamic array functions show #NAME? in Excel 2019 and earlier.
Frequently asked questions
Do most formulas need converting?
No. Common functions such as SUM, IF, VLOOKUP, INDEX, MATCH and SUMIFS work the same way in both programs.
What replaces QUERY in Excel?
For simple filters, FILTER combined with SORT. For grouping and reshaping larger data, Power Query or a PivotTable.
Is the formula sent anywhere?
No. The conversion rules run in your browser.