Spreadsheet Formula Helper
- 503 installs
- 15.6k repo stars
- Updated July 26, 2026
- composiohq/awesome-codex-skills
spreadsheet-formula-helper is a Claude Code skill that authors, debugs, and explains Excel and Google Sheets formulas with locale-aware examples for developers who need reliable reporting and operational spreadsheets.
About
spreadsheet-formula-helper is a Codex-oriented agent skill for producing working Excel and Google Sheets formulas with plain-language explanations. The workflow gathers platform, locale separators, sample rows, expected outputs, and volatility constraints, then restates the problem, drafts formulas, and checks edge cases including pivot tables and array formulas. Developers reach for spreadsheet-formula-helper when translating between Excel and Sheets dialects, debugging #REF or circular errors, or building budgeting, inventory, and ad-hoc operational reports without leaving the coding agent. The skill emphasizes small example datasets and explicit expected results so formulas survive real sheet layouts.
- Writes formulas for common business calculations
- Debugs broken references and array spill errors
- Explains logic in plain language for stakeholders
- Suggests pivot, lookup, and aggregation patterns
- Adapts solutions across Sheets and Excel syntax
Spreadsheet Formula Helper by the numbers
- 503 all-time installs (skills.sh)
- Ranked #151 of 688 Office & Documents skills by installs in the Skillselion catalog
- Data as of Aug 5, 2026 (Skillselion catalog sync)
npx skills add https://github.com/composiohq/awesome-codex-skills --skill spreadsheet-formula-helperAdd your badge
Show developers this skill is listed on Skillselion. Paste this into your README.
| Installs | 503 |
|---|---|
| repo stars | ★ 15.6k |
| Last updated | July 26, 2026 |
| Repository | composiohq/awesome-codex-skills ↗ |
How do you debug Excel versus Google Sheets formula errors?
Author, debug, and explain spreadsheet formulas for reporting, budgeting, inventory tracking, and ad-hoc operational analysis in Sheets or Excel.
Who is it for?
Developers and data-minded engineers who maintain operational spreadsheets for reporting, budgeting, or inventory tracking in Excel or Google Sheets.
Skip if: Teams that need a full ETL pipeline, database-backed BI dashboards, or application code instead of sheet-native formulas.
When should I use this skill?
A user asks to write, fix, explain, or translate spreadsheet formulas, pivot tables, or array formulas between Excel and Google Sheets.
What you get
Working formulas, dialect translations, pivot or array variants, and step-by-step explanations tied to sample rows.
- working formulas
- formula explanations
- dialect translations
By the numbers
- Covers Excel and Google Sheets formula dialects in one workflow
- Supports pivot tables and array formulas alongside scalar functions
Files
Spreadsheet Formula Helper
Produce reliable spreadsheet formulas with explanations.
Inputs to gather
- Platform (Excel/Sheets), locale (comma vs. semicolon separators), sample data layout (headers, ranges), expected outputs, and constraints (volatile functions allowed?).
- Provide small example rows and the desired result for them.
Workflow
1) Restate the problem with explicit ranges and sheet names; propose a minimal sample to verify. 2) Draft formula(s); when dynamic arrays are available, prefer them over copy-down formulas. 3) Explain how it works and where to place it; include named ranges if helpful. 4) Edge cases: blank rows, mixed types, timezone/date quirks, duplicates; offer guardrails (e.g., IFERROR, LET, LAMBDA). 5) Variants: if porting between Excel and Sheets, provide both versions.
Output
- Primary formula, short explanation, and a 2–3 row worked example showing inputs → outputs.
- Optional: quick troubleshooting checklist for common errors.
Related skills
Lark DocGenerate, update, and maintain structured documentation directly inside Lark/Feishu using natural language and agentic workflows.494kLark DriveLet their coding agents read, create, update and search documents stored in Lark (Feishu) Drive directly from prompts.493kLark SheetsConnect Claude, Cursor or other agents directly to Feishu/Lark spreadsheets for live data reads, writes, and structured automation.493kLark WikiGenerate, update, and sync structured knowledge bases inside Lark (Feishu) directly from code, specs, or agent output.493kLark WhiteboardGenerate, edit, and collaborate on visual diagrams and flowcharts directly inside Claude, Cursor or other agents.493kLark SlidesInstantly generate polished, professional slide decks from specs, roadmaps, or meeting notes using Lark/Feishu.493kHow it compares
Pick spreadsheet-formula-helper for sheet-native formula work; use a database or BI skill when reports should live outside Excel or Sheets.
FAQ
Does spreadsheet-formula-helper support both Excel and Google Sheets?
spreadsheet-formula-helper supports Excel and Google Sheets, including dialect translation between platforms. The skill asks for locale separators, sample data layout, and expected outputs before proposing formulas with edge-case checks.
What inputs does spreadsheet-formula-helper need?
spreadsheet-formula-helper needs platform choice, locale separators, headers and ranges, sample rows, expected results, and whether volatile functions are allowed. Small worked examples produce more reliable formulas than abstract descriptions alone.