Spreadsheet Formula Helper skill for Claude and Codex
A working spreadsheet formula matched to your actual layout, with a plain breakdown so you can adapt it, and notes on where it breaks.
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 someone is stuck on an Excel or Google Sheets formula and needs one that fits their real sheet layout. Do not use for building a full model or writing macros and scripts. Related topics: Data, Spreadsheets, Productivity.
What it will ask you for
- What I am trying to do (longer free text)
- How my sheet is laid out (longer free text)
- Tool (choose one: Excel, Google Sheets, LibreOffice, Numbers)
- What I have tried (longer free text)
How it works
- Restate the goal and the layout in one sentence, and pick functions available in the stated tool.
- Diagnose the failed attempts, naming the cause of each error message.
- Write the formula with references matching the described layout, handling blanks, duplicates, and mixed text and numbers.
- Break the formula into parts and explain each so it can be adapted.
- State what happens when rows or columns are inserted and give the sturdier form if needed.
What you get
The formula in a code block, a part-by-part explanation, any helper column setup, and a short note on failure cases.
What it watches out for
- Using a function the chosen tool does not have, such as a newer Excel-only function in LibreOffice.
- Assuming clean data, so one blank or text-formatted number returns an error.
- Hardcoding ranges that silently exclude rows added later.
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.