Your files never leave your device. All processing happens locally in your browser.
How do I understand what an Excel or Google Sheets formula does?
Paste the formula and the Spreadsheet Formula Explainer breaks it into plain English. It tokenizes the formula, builds a nesting tree of the functions and their arguments, and shows three things: an indented tree where every part is explained, a step-by-step walkthrough from the innermost calculation outward, and a glossary of just the functions used — drawn from a built-in dictionary of 110+ functions. It also explains cell references, ranges, absolute $ references and operators. Everything is parsed in your browser; nothing is uploaded.
Paste any Excel or Google Sheets formula (the leading “=” is optional)
See a nesting tree, an inside-out narrative and a functions glossary
Cell refs, ranges (A2:A100), $ absolute refs and operators all explained
Built-in dictionary of 110+ functions with descriptions and arguments
Unknown functions and malformed formulas are handled gracefully
100% client-side — parsed locally, nothing is uploaded
What is
Formula Explainer
A formula explainer parses a spreadsheet formula and describes, in plain English, what each part does — for example breaking =IF(VLOOKUP(A2, Sheet2!A:D, 3, FALSE)>100, "High", "Low") into the VLOOKUP that finds A2 in Sheet2 and returns column 3, the comparison to 100, and the IF that picks "High" or "Low". This tool tokenizes the formula, builds a nesting tree and explains the functions used from a built-in dictionary, without executing it or reading your data.
Work from the inside out: the innermost function runs first and its result feeds the function around it. This tool lists those steps in order for you.
Nested formulas are evaluated inside-out — the innermost function is calculated first, then its result becomes an argument for the function that wraps it, and so on outward. The Formula Explainer mirrors that: it parses the formula into a nesting tree and produces a step-by-step narrative starting from the innermost calculation, so for =IF(VLOOKUP(A2, Sheet2!A:D, 3, FALSE)>100, "High", "Low") it first explains the VLOOKUP, then the comparison to 100, then the IF that returns "High" or "Low". An indented tree and a glossary of the functions used accompany the steps.
A2:A100 is the range of cells from A2 down to A100. Dollar signs like $A$2 make a reference absolute so it does not shift when you copy the formula.
A colon makes a range, so A2:A100 is every cell from A2 down to A100, and A:A means the entire column A. A dollar sign locks part of a reference: $A$2 is fully absolute and never moves when copied, A$2 locks only the row, and $A2 locks only the column. The Formula Explainer detects ranges and absolute references and spells out both — for example noting that B$2:B$100 is a range locked so it stays fixed as the formula is filled down.
Yes — it explains formulas from either app, since they share most functions, and it accepts both comma and semicolon argument separators.
Excel and Google Sheets share the vast majority of functions — SUM, IF, VLOOKUP, XLOOKUP, INDEX, MATCH, SUMIFS, TEXTJOIN, DATEDIF, FILTER and more all behave the same — so the explainer covers formulas from either app. It accepts both the comma separator and the semicolon that some regional setups use. A few functions exist in only one app (for example ARRAYFORMULA, SPLIT, QUERY and REGEX functions in Google Sheets), and those are still recognised and described where they appear in the dictionary.
No — it parses and explains the syntax but does not execute the formula or read your data, and it is fully private: nothing is uploaded.
The tool reads standard spreadsheet syntax and explains the known functions from a built-in dictionary; it does not execute the formula and does not know your cell values, so it describes what each part is for rather than the actual result. Very obscure functions, LAMBDA and LET definitions and complex array formulas may be explained only partially, and a malformed formula returns a friendly diagnostic instead of crashing. The tokenizer, parser and dictionary run entirely in your browser, so the formula and any references it mentions are never uploaded, logged or stored, and the tool works offline once cached.
Detailed Explanation
⚙️Methodology
Tokenizer, Recursive Parser and Nesting Tree
The Spreadsheet Formula Explainer takes a pasted Excel or Google Sheets formula (the leading “=” is optional) and tokenizes it into functions, cell references (A1, $A$1), ranges (A1:B10, whole columns A:A), sheet references (Sheet1!A1 and quoted ’My Sheet’!A1), numbers, quoted strings (with "" escapes), error literals (#N/A, #REF!), parentheses, commas/semicolons and operators (+ - * / ^ & = <> <= >= %). A recursive-descent parser then assembles those tokens into a nesting tree of function calls and their arguments. From the tree the tool renders an indented breakdown where each node is explained, a step-by-step narrative from the innermost calculation outward, and a glossary of only the functions used.
Accepts formulas with or without the leading equals sign
Recursive-descent parser builds the function-nesting tree
Renders nesting tree, inside-out narrative and a used-functions glossary
Cell and range references are explained (e.g. A2:A100 is the range from A2 to A100)
🔧Technical Details
Built-in Dictionary of 110+ Functions
Explanations are drawn from a built-in dictionary of more than 110 common Excel and Google Sheets functions, each with a one-line plain-English description and named arguments, grouped into math/aggregation (SUM, SUMIF, SUMIFS, COUNTIF, AVERAGE, ROUND, RANK), logic (IF, IFS, IFERROR, AND, OR, SWITCH, IS-functions), lookup (VLOOKUP, HLOOKUP, XLOOKUP, INDEX, MATCH, OFFSET, INDIRECT, CHOOSE), text (CONCAT, TEXTJOIN, LEFT/RIGHT/MID, TRIM, SUBSTITUTE, FIND, SEARCH, TEXT, TEXTSPLIT), dates (TODAY, NOW, DATE, DATEDIF, NETWORKDAYS, EOMONTH), dynamic arrays (UNIQUE, SORT, FILTER, SEQUENCE, LAMBDA, LET, MAP, REDUCE, QUERY) and finance (PMT, FV, PV, NPV, IRR). Absolute ($) references, operators and unknown functions are explained too — an unrecognised function is shown with its argument count and a note rather than guessed.
More than 110 functions with descriptions and argument names
Covers math, logic, lookup, text, date, dynamic-array and finance functions
Operators and absolute $ references are explained inline
Unknown functions are shown with their arguments and a clear note
A copy button exports the formula, summary, steps and glossary as text
⚠️Limitations
Parses and Explains — Does Not Execute — and Is Fully Private
The tool is explicit that it parses standard syntax and explains known functions from a dictionary; it does not execute the formula and does not know the user’s data, so it describes what each part is for rather than the actual result. Very obscure functions, LAMBDA/LET definitions and complex array formulas may be explained only partially, and malformed formulas (for example an unclosed parenthesis or quote) return a friendly diagnostic instead of a crash. The tokenizer, parser and dictionary run entirely as pure functions in the browser, so the formula and any references it mentions are never uploaded, logged or stored, and the tool works offline once cached.
Explains intent, not a computed result — it does not run the formula or read your data
Obscure, LAMBDA/LET and array formulas may be explained only partially
Malformed formulas get a friendly diagnostic (unbalanced parens, unclosed quote)
Excel and Google Sheets share most functions but differ in a few
Tokenizer, parser and dictionary are pure in-browser functions — nothing uploaded
Formula explanation: in-browser parser (AnyTool) vs typical AI formula explainers
Capability
AnyTool
Typical AI explainers
Processing
Tokenized and parsed in your browser
Sends your formula to a server/LLM
Nesting tree
Indented tree, every part explained
Usually a prose paragraph only
Inside-out steps
Step-by-step from innermost outward
Rarely structured
Function glossary
Just the functions you used, with arguments
Often generic or missing
Unknown functions
Shown with arguments and an honest note
May hallucinate a meaning
Malformed input
Friendly diagnostic (unbalanced parens, etc.)
May error or guess
Privacy
Nothing uploaded, works offline
Formula transmitted and may be logged
Cost / signup
Free, no signup
Often gated or rate-limited
AnyTool parses and explains locally in the browser and uploads nothing you paste.
