Spreadsheet Formula Helper
SkillFiles & storageHelps your agent write and debug Excel and Google Sheets formulas, pivot tables, and array formulas.
Available today. Use it from your connected AI after setup.
No other account needed.
Connect ahel once, and every AI you use reads what you have installed.
Then ask your AI: use the Spreadsheet Formula Helper skill
About this capability
Write and debug spreadsheet formulas (Excel/Google Sheets), pivot tables, and array formulas; translate between dialects; use when users need working formulas with examples and edge-case checks.
What this skill tells your AI
The instructions your AI receives, as published by composio-community/awesome-codex-skills in spreadsheet-formula-helper/SKILL.md and read by ahel’s review.
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
- Restate the problem with explicit ranges and sheet names; propose a minimal sample to verify.
- Draft formula(s); when dynamic arrays are available, prefer them over copy-down formulas.
- Explain how it works and where to place it; include named ranges if helpful.
- Edge cases: blank rows, mixed types, timezone/date quirks, duplicates; offer guardrails (e.g.,
IFERROR,LET,LAMBDA). - 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.
Signals
- GitHub stars
- 16k
- Forks
- 2k
- Last commit
- Jul 2026
Advanced
- Catalog kind
- skill
- Gateway key
spreadsheet-formula-helper- Source
- github.com/composio-community/awesome-codex-skills