SheetSense

Convert an Excel formula to Google Sheets

Most basic formulas such as SUMIFS, VLOOKUP, and IF are identical in Excel and Google Sheets. The differences show up in newer or specialized functions, and in how arrays are handled. The Formula Translator returns the Google Sheets version of any Excel formula next to the explanation, so you can see what changed and why.

Common differences: Google Sheets has QUERY and ARRAYFORMULA with no Excel equivalent, uses SPLIT where Excel 365 uses TEXTSPLIT, and its CONCAT accepts only two arguments. Excel dynamic-array formulas often need ARRAYFORMULA when a formula must fill a column.

Worked example: TEXTSPLIT becomes SPLIT

Column A holds tags such as red,blue,green and you want each tag in its own cell.

Excel 365
=TEXTSPLIT(A2,",")
Google Sheets
=SPLIT(A2,",")

The logic is the same, only the function name changes. Both spill the pieces to the right, so the cells beside the formula must be empty. Pasting the Excel version into Google Sheets would return #NAME?.

How it works

  1. 01Paste the Excel formula, including the equals sign, into the Formula Translator.
  2. 02Read the explanation to confirm it matches your intent.
  3. 03Copy the Google Sheets version from the result.
  4. 04Paste it into your sheet and compare one result with the original Excel file.

Common questions

Do I need to convert every formula?
No. Plain functions behave the same in both. The translator shows the Sheets version either way, so you can see when it matches your original.
Why does my Excel formula return #NAME? in Google Sheets?
The function does not exist there or has a different name. Examples are TEXTSPLIT, which is SPLIT in Sheets, and some newer Excel-only functions.
Can it convert a whole workbook?
No. It translates one formula at a time. You can upload a CSV or Excel file to the workspace, but that does not convert its formulas.

Try it on your own formula

The Formula Translator is free for 5 formulas a day, with no account.