Excel Formula Explainer
Paste any Excel / Google Sheets formula to see its structure explained.
Overview
The Excel formula explainer parses a spreadsheet formula and prints a tree-shaped breakdown of its functions, arguments, references, and operators. Paste anything from a simple =SUM(A1:A10) to a deeply nested IFERROR(INDEX(MATCH(...))) and see the structure laid out one level at a time.
It's an essential tool when you inherit a sheet from a colleague or vendor and need to understand what every nested call is doing. Analysts, finance pros, and anyone debugging spreadsheet logic use an excel formula parser to demystify a wall of parentheses without manually counting them.
How it works
The parser tokenises the formula text into function names, cell and range references, literals, named ranges, and operators (+, -, *, /, ^, &, comparisons). It then builds an abstract syntax tree following Excel's operator precedence and function call structure — both Excel and Google Sheets share the same syntax, so the same parse applies to either.
Each node is rendered with indentation showing nesting depth. Function arguments are numbered, range references are normalised ($A$1:$A$10 shown alongside A1:A10), and array constants are flattened so you can read them at a glance.
Examples
=IF(SUM(A1:A10)>100, "yes", "no")
IF
├─ SUM(A1:A10) > 100
│ ├─ SUM
│ │ └─ A1:A10
│ └─ 100
├─ "yes"
└─ "no"
=VLOOKUP(B2, Sheet2!A:C, 3, FALSE)
VLOOKUP
├─ B2 (lookup value)
├─ Sheet2!A:C (table array)
├─ 3 (column index)
└─ FALSE (exact match)
FAQ
Does it evaluate the formula?
No — it explains the structure, not the result. You'd need a spreadsheet engine to compute values, and that requires the surrounding workbook data.
Are dynamic-array functions like LET and LAMBDA supported?
Yes. LET shows its name/value bindings as a list, and LAMBDA displays parameter names alongside the body expression so closures stay readable.
What about R1C1-style references?
The parser accepts both A1 and R1C1 notation. Output preserves whichever style the source used so the rewritten tree matches what's in the original cell.