Excel Formula Explainer

Paste any Excel / Google Sheets formula to see its structure explained.

Paste a formula (with or without a leading =).

About this tool

Paste a complex Excel or Google Sheets formula and the tool will tokenise it, build a function call tree, and produce a plain-English explanation for every nested function. Knows the most common ~40 functions (IF, VLOOKUP, XLOOKUP, INDEX/MATCH, SUMIF, TEXTJOIN, EOMONTH, FILTER, ARRAYFORMULA, LAMBDA …). Does not evaluate the formula — it just explains what it does.

An unhandled error has occurred. Reload ×