What does this tool do?

It tokenizes and parses an Excel formula into an abstract syntax tree, then renders that tree and a readable explanation. It shows the structure and meaning of a formula but does not evaluate it against real cell values, since it has no workbook.

Which operators and precedence does it support?

It supports the full Excel operator set: ^ for power, * and / for multiply and divide, + and - for add and subtract, & for text concatenation, the comparison operators = <> >=, unary minus, and the trailing % percent operator, all with Excel's standard precedence and right-associative ^.

Can it parse nested functions and ranges?

Yes. It handles arbitrarily nested function calls like IF(SUM(A1:A10)>100, ...), cell and range references with absolute markers such as $A$1 and A1:B2, sheet-qualified references like Sheet1!A1, and defined names.

Does it work with Google Sheets formulas?

Mostly, yes. Google Sheets shares Excel's formula grammar for functions, operators and references, so common formulas parse identically. A few Google-only functions will parse structurally even though their descriptions are not in the built-in glossary.

Is my formula sent anywhere?

No. The formula is tokenized and parsed entirely in your browser. Nothing is uploaded, so you can safely paste formulas from confidential models.

Excel Formula Parser & Explainer

This tool takes an Excel formula and breaks it down into the functions, operators and references it is built from, then explains in plain English what it does. It is built for auditing spreadsheets you inherited, untangling a formula someone else wrote, or teaching how a complex calculation is structured.

How it works

The parser runs in two stages, exactly like a programming-language compiler front end.

First, a tokenizer scans the formula character by character and emits tokens: numbers, quoted text, booleans (TRUE/FALSE), error literals (#REF!, #DIV/0!), cell and range references (A1, $A$1, A1:B2, Sheet1!A1), function names, operators and parentheses.

Second, a precedence-climbing parser turns that flat list of tokens into a tree. Excel’s operator precedence is respected — ^ binds tightest, then * and /, then + and -, then &, then the comparison operators — and ^ is treated as right-associative, so 2^3^2 parses as 2^(3^2). Function calls capture their comma-separated arguments, and each argument is itself a full sub-expression, which is how nested formulas are represented.

The resulting tree is then walked twice: once to render the indented parse tree, and once to produce the plain-English explanation, describing the formula from the outermost operation inward.

Example

Given =IF(SUM(A1:A10)>100, B1*1.2, "under budget"), the parser identifies IF as the outermost function with three arguments. The first argument is a comparison: the function SUM over the range A1:A10, compared with > against the number 100. The second argument multiplies cell B1 by 1.2, and the third is the text "under budget". The explanation reads it back as a sentence so the intent is obvious at a glance.

Tips

You can paste the formula with or without the leading =; both are accepted.
If you get a parse error, the message points at the position of the unexpected token — usually a missing parenthesis or a stray comma.
The tool describes structure, not results. To know the value, the spreadsheet still has to evaluate it against real data; this tool tells you what that evaluation will do.