Paste an Excel formula and instantly see every nested function, argument, and logical step explained — by a deterministic parser, not an AI that can hallucinate. No sign-up, no upload, runs in your browser.
Free is enough for most one-off jobs. Pro raises the file and batch caps; Pro + Media unlocks GB-scale streaming and unlimited duration.
Larger files supported on Developer (5 GB CSV) and Enterprise (unlimited). All processing happens in your browser — files never reach a server.
Paste your Excel formula (e.g. =IF(VLOOKUP(A1,B:C,2,0)>100,"High","Low"))
A real formula parser builds the syntax tree (AST) and labels each function, argument, and nested layer
Read the step-by-step breakdown and the annotated formula tree — instantly, with no data sent anywhere
0 bytes uploaded. Formula Tree Explainer runs entirely in your browser using SheetJS and ExcelJS. Your spreadsheets never leave your device.
It's a deterministic parser, not a language model. It builds the actual syntax tree of your formula and describes each function and argument from Excel's documented behaviour — so the same formula always gets the same, correct explanation, with no risk of an AI confidently inventing a function or mis-describing an argument. It's also instant, needs no sign-up, and sends nothing to a server.
All standard Excel functions (IF, VLOOKUP, INDEX/MATCH, SUMIF, COUNTIFS, LET, LAMBDA, array formulas, and more) are recognised and explained. Custom VBA/user-defined functions are identified as 'User-defined function' since their behaviour lives in your workbook's code, not in Excel itself.
No — it's static analysis. It explains what the formula does and how its parts nest together without needing your actual cell values, so you can paste a formula from anywhere and understand it. To see a result, run the formula in Excel; to understand it, use this.
Yes — nesting depth is exactly what it's built for. It parses the formula into a tree and explains it layer by layer from the outermost function inward, which is far easier to follow than reading a wall of nested parentheses. Long INDEX/MATCH and multi-condition IF chains are the common cases.
No. Parsing happens entirely in your browser — the formula text never leaves your device. Nothing is logged or stored, which matters when the formula references confidential business logic.
Mostly — Sheets shares most of Excel's function set and syntax, so common formulas explain correctly. Sheets-only functions (e.g. QUERY, ARRAYFORMULA, GOOGLEFINANCE) may be flagged as unrecognised since they aren't part of Excel's function set.