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.
