You've written Excel formulas for fifteen years. Now your team works in Google Sheets and half the function names are wrong. Set Formula Foundry's editor dialect to Microsoft Excel, paste the formula you would have written in Excel, and the editor produces a working Google Sheets version — with the smart fixes you'd have made by hand.
Free plan — no credit card required.
Three steps. The Excel formula you'd have written, working in Sheets.
Open Formula Foundry's editor in Google Sheets and pick Microsoft Excel as the dialect. The editor now reads what you type as Excel syntax instead of Sheets.
Drop in the formula the way you'd write it in Excel — CONCATENATE, STDEV.S, AGGREGATE, IF(ISERROR(...)), the lot. The translator runs as part of the paste.
The editor gives you back a formula that works in Google Sheets — function names remapped, IFERROR collapsed, AGGREGATE turned into SUBTOTAL, TEXT() format strings corrected. Insert it into your cell.
The Excel-to-Sheets fixes the editor handles for you.
Collapses IF(ISERROR(expr), val, expr) into IFERROR(expr, val). Translates AGGREGATE(func, 5, ...) into SUBTOTAL(func+100, ...). Turns TEXTSPLIT into SPLIT and TEXTBEFORE / TEXTAFTER into REGEXEXTRACT patterns. Strips the redundant '--' coercion in SUMPRODUCT patterns.
Names only one app knows are renamed (VALUETOTEXT → TO_TEXT), and names both apps share (CONCATENATE, STDEV.S, PERCENTILE.INC, RANK.EQ, the byte variants LEFTB / LENB) pass through untouched, because renaming inside those families changes the result. Functions with no Sheets counterpart get an amber underline that says so.
Strips Excel's implicit-intersection '@' operator. Wraps implicit-array operations in ARRAYFORMULA() so they evaluate the way you expected. Fixes the TEXT() date / time format mismatch (mm → MM for months, m → m for minutes).
The translated formula lands in the multi-line editor with color coding, indentation, and find-and-replace. You can save it as a snippet so the same Excel-style formula works on next month's workbook with one click.
The translator, on a real Excel formula.
Translator FAQs
Type Excel. Land in Sheets.
Install Formula Foundry, set the editor dialect to Microsoft Excel, and paste the next formula the way you would have written it five years ago.