spreadsheet-formula-helper — Claude Code skill: how it works
spreadsheet-formula-helper is a Claude Code skill for building and debugging Excel and Google Sheets formulas, migrating formulas across dialects, and cleaning dynamic arrays.
no license 3 installs ★ 17,383 updated 2026-07-26
npx skills add composio-community/awesome-codex-skills --skill spreadsheet-formula-helper -a claude-codeWhat spreadsheet-formula-helper does
The skill instructs the agent to ask for sheet details up front: host software, separators for your locale, sample headers, and constraints around volatile functions. Missing locale details mean formula parsing can fail immediately because of comma or semicolon mismatches.
When drafting solutions, the agent leans toward dynamic array formulas rather than copy-down cells. It also adds safeguards with IFERROR, LET, or LAMBDA to handle blank values, duplicate entries, and inconsistent data types.
Every response includes the primary formula, placement instructions, and a two-to-three row worked example displaying inputs beside outputs.
What it helps with
- construct formulas for Excel or Google Sheets
- translate dynamic array formulas between spreadsheet engines
- protect cell calculations against blank rows and mixed data types
- generate worked examples that show sample rows and outputs
Example prompts for the agent
- Build a Google Sheets formula to aggregate sales by customer ID from column A
- Convert this Excel formula using LET and LAMBDA to Google Sheets with semicolon separators
- Add error handling to this lookup formula to bypass blank rows and duplicates
How to install spreadsheet-formula-helper
1Skills CLI (Vercel)
npx skills add composio-community/awesome-codex-skills --skill spreadsheet-formula-helper -a claude-code2Manually: put the files in place
~/.claude/skills/spreadsheet-formula-helper/SKILL.mdCopy the whole skill folder; for one project use .claude/skills/spreadsheet-formula-helper/
1Skills CLI (Vercel)
npx skills add composio-community/awesome-codex-skills --skill spreadsheet-formula-helper -a codex2Manually: put the files in place
.agents/skills/spreadsheet-formula-helper/SKILL.mdFor all projects use ~/.agents/skills/
1Skills CLI (Vercel)
npx skills add composio-community/awesome-codex-skills --skill spreadsheet-formula-helper -a cursor2Manually: put the files in place
.cursor/skills/spreadsheet-formula-helper/SKILL.mdCursor also reads .agents/skills/ and .claude/skills/
1GitHub CLI
gh skill install composio-community/awesome-codex-skills spreadsheet-formula-helper2Manually: put the files in place
.github/skills/spreadsheet-formula-helper/SKILL.md1Skills CLI (Vercel)
npx skills add composio-community/awesome-codex-skills --skill spreadsheet-formula-helper -a gemini-cli2Platform CLI
gemini skills install https://github.com/composio-community/awesome-codex-skills --path spreadsheet-formula-helperManually: put the files in place
.devin/skills/spreadsheet-formula-helper/SKILL.mdThe legacy .windsurf/skills/ path still works
Skills CLI (Vercel)
npx skills add composio-community/awesome-codex-skills --skill spreadsheet-formula-helper -a opencodeClaude.ai
Zip the folder and upload it in Settings → Capabilities → Skills
Step by step, with commands for each platform: How to install skills in Claude Code: five ways
Questions about spreadsheet-formula-helper
How to install spreadsheet-formula-helper in Claude Code?
Run npx skills add composio-community/awesome-codex-skills --skill spreadsheet-formula-helper -a claude-code.
What does spreadsheet-formula-helper do?
It structures formula writing for Excel and Google Sheets, emphasizing dynamic arrays, edge cases, and verification samples.
Why does the skill check for spreadsheet locale?
Formulas use either commas or semicolons to separate arguments depending on the user locale, which breaks calculations if selected incorrectly.