Skip to main content
skill CX Codex

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

Install into Claude Code · Skills CLI (Vercel) All methods and platforms ↓
npx skills add composio-community/awesome-codex-skills --skill spreadsheet-formula-helper -a claude-code
Open on GitHub

What 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-code

2Manually: put the files in place

~/.claude/skills/spreadsheet-formula-helper/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/spreadsheet-formula-helper/

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.

Similar skills

All skills for Office documents →

From the same set2

More in the catalog

Project sponsors

Companies that keep this analytics open