Spreadsheet Formula Explainer & Builder skill for Claude and Codex
Gives you a working Excel or Google Sheets formula, a plain-English breakdown of each part, and the likely ways it breaks, or fixes one that errors.
Install it once and Claude or Codex runs it for you. When your request matches, your AI loads the skill, asks for anything it is missing, and works through the template itself. Prefer to fill it in by hand? See the full prompt template.
Download the skill (.zip) · View SKILL.md
When it is used
Use when you need a spreadsheet formula built, explained, or fixed in Excel or Google Sheets, including VLOOKUP or SUMIFS style problems and error values. Do not use for building a full spreadsheet model, pivot tables, or macros and scripts. Related topics: Productivity, Spreadsheets, Data.
What it will ask you for
- Tool (choose one: Google Sheets, Microsoft Excel, Either with the most portable version)
- What I am trying to do (longer free text)
- My data layout (longer free text)
- Mode (choose one: Build a new formula, Explain a formula I already have, Fix a formula that is erroring)
- Existing formula (free text, e.g. "Paste it here or leave blank")
- Avoid array formulas and newer functions for compatibility (choose one: Yes, No)
How it works
- Read the data layout and map each column letter to its meaning before touching any formula.
- In build mode pick the simplest function that fits, in explain mode unpack the formula innermost call first, and in fix mode name the cause of the error first.
- Check the formula against the chosen tool and the compatibility toggle, swapping out unsupported functions.
- Test the formula on a small worked example with sample values and show the result.
- List the two most likely failure cases with a guard for each.
What you get
The formula in a code block, a part-by-part explanation, one worked example with sample values, and two failure cases each with a guard.
What it watches out for
- Using functions that exist in only one product when the user chose Either.
- Hard-coding a range that stops growing as rows are added.
- Changing a broken formula before diagnosing the cause, which hides the real bug.
How to install
Claude.ai and the Claude desktop app
- Download the skill .zip.
- Open Settings, then Capabilities, and find Skills.
- Choose Upload skill and select the .zip.
- Ask Claude for help with the task. It loads the skill when your request matches.
Claude Code
- Download the skill .zip.
- Unzip it into ~/.claude/skills/ (or .claude/skills/ inside a project).
- Start a new session. Claude Code loads the skill when your request matches.
Codex
- Download the skill .zip.
- Unzip it into ~/.agents/skills/ (or .agents/skills/ inside a project).
- Codex picks it up on its own. Type $ and the skill name to use it, or just ask for the task.
Cursor
- Download the Cursor rule (.mdc).
- Save it in .cursor/rules/ inside your project.
- Cursor's agent applies the rule when your request matches its description.
AGENTS.md (Codex, Cursor, and other coding agents)
- Copy the AGENTS.md section.
- Paste it into AGENTS.md at the root of your repository, creating the file if needed.
- Coding agents that read AGENTS.md follow it when your request fits.