View Options
Formatting
Formula Tree
Match
Mismatch
Excel Formula Analyzer & Tree Visualizer
Format, break down, and visualize any Excel formula. Get instant structure, stats, inline docs, and a copyâready version. Compare two formulas sideâbyâside with Diff.
đ
Formatted Formula Complexity: â Performance: â
Formula Tree
Formula A
Formatted Formula Complexity: â Performance: â
Formula Tree
Formula B
Formatted Formula Complexity: â Performance: â
Formula Tree
The colored squares match node types:
Æ Function
+ Binary Op
± Unary Op
â Range
⧠Array
x Variable
â Identifier
λ LAMBDA
â Boolean
# Number
T Text
- Click a node to expand/collapse its children. The chevron rotates when expanded.
- Summary dots show child arguments. Hover to preview; click to focus that part.
- Grey out mode dims nonâfocused parts to reveal structure inside parents.
- Sync highlighting links tree nodes with the formatted code view.