📊 Excel Formula Explainer
Explain Excel and Google Sheets formulas in plain language — paste a formula to see arguments, descriptions, and examples for each function.
About this tool
Excel formulas are powerful but hard to read — especially when they nest multiple functions. This tool parses your =VLOOKUP(...), =IF(...), or =INDEX(MATCH(...)) and breaks it into a tree: each function gets its own card showing what it does, what each argument means, and a practical tip.
Example: =IF(A1>90, "Excellent", IF(A1>75, "Good", "Needs Work")) → two IF nodes, each with its condition, true-value, and false-value arguments labeled and explained.
Covers 80+ functions across Math, Text, Lookup, Logical, and Date categories. Works with both Excel and Google Sheets formulas (just strip the leading = if you prefer — the tool handles it automatically).
FAQ
Does this work with Google Sheets formulas? ›
Yes. Most Google Sheets functions use the same syntax as Excel. The tool also recognizes Sheets-specific functions like SPLIT.
Can it handle deeply nested formulas? ›
Yes — the parser handles any nesting depth. However, extremely long formulas (thousands of characters) may take a moment to render.
Why does the tool show "(unrecognized)" for my function? ›
The knowledge base covers 80+ of the most common functions. Functions not in the database still appear in the tree with their arguments parsed, just without the description card.
Does it handle array formulas with curly braces { }? ›
Yes — array constants like {1,2,3;4,5,6} are parsed and shown as array nodes. Dynamic array functions like FILTER and SORT are also recognized.