# spreadsheet-formula-helper

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.

- skill · `type=skill` · Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, OpenCode, Windsurf (Devin Desktop), Claude.ai · 3 installs · ★ 17383 repo stars
- Author: composio-community
- License: not stated · policy=link-only · description only; the file stays with the author
- Source: https://github.com/composio-community/awesome-codex-skills/tree/HEAD/spreadsheet-formula-helper/SKILL.md
- Updated: 2026-07-26
- Security check: automated, 2026-11-16 (text) — no signs of malicious code found.
- HTML: https://affpapa.org/en/nevibecode/skills/spreadsheet-formula-helper

## What it 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.

## Requirements
- Works with: Google Workspace

## Install

### Claude Code (native platform)

1. **Skills CLI (Vercel)**
```bash
npx skills add composio-community/awesome-codex-skills --skill spreadsheet-formula-helper -a claude-code
```

2. **Manually: put the files in place**
- File: `~/.claude/skills/spreadsheet-formula-helper/SKILL.md` — Copy the whole skill folder; for one project use .claude/skills/spreadsheet-formula-helper/

### Codex

1. **Skills CLI (Vercel)**
```bash
npx skills add composio-community/awesome-codex-skills --skill spreadsheet-formula-helper -a codex
```

2. **Manually: put the files in place**
- File: `.agents/skills/spreadsheet-formula-helper/SKILL.md` — For all projects use ~/.agents/skills/

### Cursor

1. **Skills CLI (Vercel)**
```bash
npx skills add composio-community/awesome-codex-skills --skill spreadsheet-formula-helper -a cursor
```

2. **Manually: put the files in place**
- File: `.cursor/skills/spreadsheet-formula-helper/SKILL.md` — Cursor also reads .agents/skills/ and .claude/skills/

### GitHub Copilot

1. **GitHub CLI**
```bash
gh skill install composio-community/awesome-codex-skills spreadsheet-formula-helper
```

2. **Manually: put the files in place**
- File: `.github/skills/spreadsheet-formula-helper/SKILL.md`

### Gemini CLI

1. **Skills CLI (Vercel)**
```bash
npx skills add composio-community/awesome-codex-skills --skill spreadsheet-formula-helper -a gemini-cli
```

2. **Platform CLI**
```bash
gemini skills install https://github.com/composio-community/awesome-codex-skills --path spreadsheet-formula-helper
```

### Windsurf (Devin Desktop)

**Manually: put the files in place**
- File: `.devin/skills/spreadsheet-formula-helper/SKILL.md` — The legacy .windsurf/skills/ path still works

### OpenCode

**Skills CLI (Vercel)**
```bash
npx skills add composio-community/awesome-codex-skills --skill spreadsheet-formula-helper -a opencode
```

### Claude.ai

**Claude.ai**
- Zip the folder and upload it in Settings → Capabilities → Skills

Where a file is given instead of a command, copy the files from the source to that path: https://github.com/composio-community/awesome-codex-skills/tree/HEAD/spreadsheet-formula-helper/SKILL.md

## When to use it
- 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
- 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

## Similar
- [excel-formula-generator](https://affpapa.org/en/nevibecode/skills/excel-formula-generator.md) — skill · 2 installs
- [csv-formula-injection](https://affpapa.org/en/nevibecode/skills/csv-formula-injection.md) — skill · 4000 installs
- [gws-sheets](https://affpapa.org/en/nevibecode/skills/gws-sheets.md) — skill · 61900 installs
- [gws-sheets-read](https://affpapa.org/en/nevibecode/skills/gws-sheets-read.md) — skill · 52800 installs
- [Google Sheets](https://affpapa.org/en/nevibecode/mcp/google-sheets.md) — MCP server · 56138 installs
- [google-sheets](https://affpapa.org/en/nevibecode/skills/sanjay3290-google-sheets.md) — skill · 483 installs

From the same set: [composio-community/awesome-codex-skills](https://affpapa.org/en/nevibecode/by/composio-community/awesome-codex-skills.md) — 2 cards

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md
