Smart structural fixes
Collapses IF(ISERROR(expr), val, expr) into IFERROR(expr, val). Translates AGGREGATE(func, 5, ...) into SUBTOTAL(func+100, ...). Strips the redundant '--' coercion in SUMPRODUCT patterns.
Use case
Spent your career in Excel?Keep typing it in Sheets.
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.
Formula translator is in Beta. Trial days only count when you actually open the add-on. No credit card.
How it works
Three steps. The Excel formula you'd have written, working in Sheets.
Set the editor dialect to Excel
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.
Paste (or write) the Excel formula
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.
Get the working Sheets version
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.
What the translator covers
The Excel-to-Sheets fixes the editor handles for you.
Function-name remaps
CONCATENATE → CONCAT, STDEV.S → STDEV, LEFTB / RIGHTB / MIDB / LENB → LEFT / RIGHT / MID / LEN, PERCENTILE.INC → PERCENTILE, RANK.EQ → RANK, and the rest of the remaps that bite Excel users in Sheets.
Syntax cleanup
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).
Plays nicely with the rest of the editor
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.
See it in action
The translator, on a real Excel formula.
Got questions?
Translator FAQs
- Three groups of changes. Structural fixes: IF(ISERROR(...)) collapses to IFERROR, AGGREGATE(...) becomes SUBTOTAL with the right func_num, and redundant '--' in SUMPRODUCT goes away. Name remaps: CONCATENATE → CONCAT, STDEV.S → STDEV, LEFTB / MIDB / RIGHTB / LENB → their unsuffixed Sheets versions, and a handful of others. Syntax cleanup: strips Excel's '@' implicit-intersection operator, wraps implicit arrays in ARRAYFORMULA, and fixes TEXT() format strings.
- Today's user-facing translator is Excel-syntax-into-Sheets. The reverse direction exists under the hood and may light up as a marketed flow later, but the feature you can rely on now is the one this page describes: write Excel, work in Sheets.
- No. The translator covers the function names and patterns above; functions that genuinely have no Google Sheets counterpart (the CUBE family, RTD, WEBSERVICE, certain new TEXT*-functions, and so on) get left as-is for you to rewrite. The feature is in Beta and we're expanding coverage based on what people actually paste in.
- Today's flow is one formula at a time, in the editor. That's intentional for now — silently auto-translating thousands of cells is how teams ship reports with quietly wrong totals. Save the working Sheets version as a snippet and you can drop it back in next month with a click.
Stop relearning syntax
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.