Developer Tools

Spreadsheet Formula Explainer

Paste an Excel or Google Sheets formula and get a plain English breakdown of every function, cell reference, range, and operator, color coded and nested.

Paste an Excel or Google Sheets formula63 chars

Paste the formula exactly as it appears in the cell or the formula bar. A leading equals sign is optional. The formula is read in your browser and never uploaded.

Color-coded formula

=IFERROR(VLOOKUP(A2, Sheet2!$A$2:$D$50, 4, FALSE), "Not found")

FunctionA built-in operation
Cell or rangeWhere data is read
TextA quoted string value
NumberA numeric constant
OperatorMath, comparison, or join
ErrorA spreadsheet error value

Functions used

Cells referenced

Ranges referenced

Structure outline

Read top to bottom. Indentation shows which parts sit inside the parentheses of the function above them.

IFERRORFunctionReturns a fallback value when the first expression would otherwise produce an error.IFERROR(value, value_if_error)
(Open callStarts the list of arguments passed to the function on the left.
VLOOKUPFunctionSearches the first column of a range for a key and returns a value from a column to its right.VLOOKUP(search_key, range, index, [is_sorted])
(Open callStarts the list of arguments passed to the function on the left.
A2Cell referenceCell A2. A relative reference that shifts when the formula is copied to other cells.
,Argument separatorSeparates one argument from the next.
Sheet2!$A$2:$D$50Range on another sheetThe rectangular block of cells from $A$2 to $D$50 on the sheet Sheet2.
,Argument separatorSeparates one argument from the next.
4NumberThe number 4.
,Argument separatorSeparates one argument from the next.
FALSEBooleanThe logical value FALSE.
)Close callEnds the function's argument list.
,Argument separatorSeparates one argument from the next.
"Not found"Text valueThe literal text "Not found".
)Close callEnds the function's argument list.

Functions in this formula

IFERROR
IFERROR(value, value_if_error)
Returns a fallback value when the first expression would otherwise produce an error.
VLOOKUP
VLOOKUP(search_key, range, index, [is_sorted])
Searches the first column of a range for a key and returns a value from a column to its right.

Cells and ranges this formula reads

Cells

Ranges

Sheet2!$A$2:$D$50

How to use

Copy the formula from the cell or the formula bar in Excel or Google Sheets.
Paste it into the box. The leading equals sign is optional, and regional formulas that use semicolons between arguments are supported.
Read the color-coded formula to see at a glance which parts are functions, cells, text, numbers, and operators.
Follow the structure outline from top to bottom; the indentation shows which parts are nested inside each function's parentheses.
Check the function cards for a signature and plain English description of every function used, plus the list of cells and ranges the formula reads.
Review the things to check panel for any unbalanced parentheses or unterminated text. Everything runs locally in your browser.

About this tool

Spreadsheet Formula Explainer takes a formula you inherited, copied from a colleague, or found online and reads it back to you in plain English, one piece at a time. Spreadsheet formulas pack a lot into a single line: a function name, the cells and ranges it works on, text and number values, comparison and math operators, and often several more functions nested inside the first. When that line is something like =IFERROR(VLOOKUP(A2, Sheet2!$A$2:$D$50, 4, FALSE), "Not found"), it is hard to tell at a glance what it actually does without taking it apart by hand. This tool does the taking-apart for you. Paste the formula exactly as it appears in the cell or the formula bar, with or without the leading equals sign, and it is parsed in a single pass into labeled tokens. Every part is given a color and a short explanation: functions in blue with a one-line summary of what they return, cells and ranges in cyan with a note about whether the dollar signs lock the row or column when the formula is copied, quoted text in green, numbers in amber, operators in indigo, and spreadsheet error values like #N/A or #REF! in red so they stand out. A structure outline lists the same tokens top to bottom and indents each one to show exactly which function's parentheses it sits inside, which is the fastest way to understand a deeply nested formula and to see which argument is which. The tool recognizes dozens of the functions people most often need explained across both Microsoft Excel and Google Sheets, including the lookup family (VLOOKUP, HLOOKUP, XLOOKUP, INDEX, MATCH, OFFSET, INDIRECT), the conditional aggregates (SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF), logical functions (IF, IFS, IFERROR, AND, OR, SWITCH), text functions (LEFT, MID, SUBSTITUTE, TEXTJOIN, TEXT, REGEXEXTRACT), date functions (TODAY, DATE, EOMONTH, NETWORKDAYS), and the Google Sheets array tools (ARRAYFORMULA, QUERY, FILTER, SORT, UNIQUE, IMPORTRANGE). For each one it shows the function signature with named arguments and a sentence describing the result. It also separates out every distinct cell and range the formula reads, handles sheet-qualified references such as Sheet1!A1 and 'My Sheet'!A1:B2, understands whole-column and whole-row ranges like A:A and 2:2, and flags structural problems such as a missing closing parenthesis or a piece of text without its closing quote. This is the mirror image of the Spreadsheet Formula Builder: where the builder composes a correct formula from labeled fields, this reads an existing formula back so you can understand, audit, or fix it. Everything is computed in your browser. The formula you paste is never uploaded, logged, or sent anywhere.

Free to use. Works in your browser. No signup, no login.

Related tools

Spreadsheet Formula Explainer

How to use

About this tool

You may also like

Spreadsheet Formula Builder

Regex Explainer

Crontab Explainer