Understand any formula in one click.

SheetPilot is a small add-in for Excel and Google Sheets that explains formulas in plain English, highlights broken references and tidies up messy ranges — without leaving your spreadsheet.

Start free trialRead the docs
A
B
C
Region
Q3 sales
=IFERROR(VLOOKUP(A2,Rates!A:B,2,0)*B2,0)
North
128 400
→ Looks up the rate for “North”, multiplies by Q3 sales, returns 0 if missing.
South
97 210
⚠ Rates!A:B has 2 duplicate keys

Formula explainer

Select a cell and get a step-by-step description of what the formula does, including nested functions.

Reference audit

Find #REF!, circular dependencies and lookups that point at empty or duplicated keys before your manager does.

Range cleanup

Trim whitespace, unify number formats and split merged cells across a whole sheet in one pass.

Simple pricing

Free for personal use. Teams from $4 per seat per month. No card required for the trial.