Developer Tools
Excel Formula Explainer
Paste an Excel or Google Sheets formula and get a plain-English, step-by-step breakdown of every function, reference and operator — including nested IFs, lookups and ranges.
How to use
- 1Paste a formula (with or without the leading =).
- 2Read the summary and the indented step-by-step breakdown.
How it's calculated
The formula is tokenized into functions, cell references, ranges, text, numbers and operators; nesting is shown by indentation. Descriptions cover about 110 common Excel/Sheets functions.
Frequently asked questions
What do the $ signs mean?
They make a reference absolute: $A$1 doesn't change when you copy the formula; A$1 locks only the row, $A1 only the column.
Does it calculate the result?
No — it explains what the formula does. Paste it into your spreadsheet to calculate.
Does it work for Google Sheets?
Yes — Sheets uses the same formula syntax for almost all common functions.
Worked example: Excel Formula Explainer
=IFERROR(VLOOKUP(A2,Products!$A$2:$C$100,3,FALSE),"Not found") breaks into a nested, indented structure: IFERROR wraps everything and explains itself first, then indented beneath it is VLOOKUP with its four arguments each on their own line — cell A2, range $A$2:$C$100 on sheet "Products" (flagged specifically as absolute, meaning it won't shift if the formula is copied to another cell), number 3, and FALSE — and finally the fallback text "Not found" sits back at IFERROR's own indentation level, since it's IFERROR's second argument, not part of VLOOKUP. The indentation directly mirrors the formula's actual nesting depth, which is exactly what makes a deeply nested real-world formula with five or six stacked functions readable instead of an unparseable wall of parentheses.
Why unbalanced parentheses get a specific warning instead of silent failure
Paste =SUM(B2:B10 (missing the closing parenthesis) and the tool still explains what it can tokenize — SUM adds up the numbers, with the range B2:B10 listed underneath — but prepends an explicit ⚠ Parentheses don't balance (1 opening, 0 closing) warning. That's a deliberate design choice: a formula you're actively drafting is very often temporarily incomplete, so refusing to explain anything until it's syntactically perfect would make the tool useless for the exact moment you need it most — while you're still writing and debugging the formula, not after it's finished.
What the $ signs actually control, and why it's easy to get backwards
In a reference like A$1, the $ immediately before the row number locks the row but leaves the column (A) free to shift when the formula is copied sideways; in $A1, it's the reverse — column locked, row free. This mixed-absolute-reference pattern is exactly what you want when building something like a multiplication table or a formula that needs to reference a fixed header row while varying the column as it's dragged across — and it's also one of the most common sources of a spreadsheet formula silently producing wrong values after being copied, because the $ placement that worked for copying down a column often needs to be different for copying across a row.
A missing parenthesis is counted, and the walkthrough still runs
The box opens on an IFERROR wrapped around a VLOOKUP, with a sheet name, locked columns, and a fallback of Not found. A formula whose parentheses do not match still gets a walkthrough. The warning says they do not balance and gives the opening count and the closing count, so a single missing close reads as 1 opening and 0 closing. I use that when a long formula will not paste cleanly and I want the structure anyway, with the warning above the steps rather than a blank result. The steps still list each argument.
Related tools
- Regex Explainer (Explain a Regular Expression)
Paste a regular expression and get a plain-English, token-by-token explanation — character classes, groups, lookarounds, quantifiers, anchors and flags. Works with JavaScript and PCRE-style syntax. No AI, instant.
- Cron Expression Explainer
Translate cron expressions into plain English and list the next run times — supports ranges, steps, names and @daily-style macros.
- CSV to JSON Converter
Convert CSV or spreadsheet data to a JSON array of objects, with header detection, number/boolean typing and any delimiter.
- JSON to CSV Converter
Turn a JSON array of objects into CSV for Excel or Google Sheets — nested objects are flattened into dot-notation columns.
- Excel & Google Sheets Formula Generator
Build Excel and Google Sheets formulas without memorizing syntax — SUMIF, COUNTIF, XLOOKUP, IF, date differences, TEXTJOIN, UNIQUE and more. Pick a task, fill in your cells, copy the formula.
- Emoji Meanings Dictionary
Look up what popular emoji mean — and how people actually use them in texts and social media (like 💀 for 'I'm dead' laughing).