How to understand complex excel formulas with a plain-english breakdown
- Step 1Paste your formula — Type or paste any Excel formula into the input field. Start with = or omit it — both work.
- Step 2Click Run — The formula is parsed into a function tree. Each function's description and arguments are expanded.
- Step 3Read the explanation — A plain-English breakdown shows every nested function, its purpose, and each argument described.
Frequently asked questions
Does it support array formulas and dynamic arrays?+
SEQUENCE, FILTER, SORT, and UNIQUE are in the description library. Array-formula braces { } are stripped before parsing.
What about LAMBDA and LET?+
LAMBDA and LET are recognised and described. The tool does not evaluate the formula — it only explains structure.
Can it handle localized function names (e.g. German SE() instead of SUM())?+
Currently English function names only. Localised formula support is on the roadmap.
Privacy first
Every JAD Excel tool runs entirely in your browser using SheetJS and ExcelJS. Your spreadsheets, formulas, and data never leave your device — verified by zero outbound network requests during processing.