# xlsx

Teaches agents to generate clean spreadsheets, keep formulas dynamic, and enforce financial modeling standards.

- skill · `type=skill` · Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, OpenCode · 2500 installs · ★ 841
- Author: tfriedel
- License: not stated · policy=link-only · description only; the file stays with the author
- Source: https://github.com/tfriedel/claude-office-skills/tree/HEAD/public/xlsx/SKILL.md
- Updated: 2026-04-01
- HTML: https://affpapa.org/en/nevibecode/skills/tfriedel-xlsx

## What it does

The skill stops the agent from baking Python-calculated numbers directly into cells. It requires native Excel formulas through openpyxl and reserves pandas for data inspection and summaries. This ensures the output remains interactive when inputs change.

For financial workbooks, it applies strict styling conventions. Hardcoded inputs use blue text, calculations stay black, cross-sheet references turn green, and assumptions needing review receive yellow fills. Broken outputs containing `#REF!` or `#DIV/0!` are rejected immediately.

Without a local LibreOffice installation, the bundled `recalc.py` script cannot recalculate cells to produce the error report. Every generation step expects this verification to run before the file is treated as ready.

## Install

### Claude Code (native platform)

1. **Skills CLI (Vercel)**
```bash
npx skills add tfriedel/claude-office-skills --skill xlsx -a claude-code
```

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

### Codex

1. **Skills CLI (Vercel)**
```bash
npx skills add tfriedel/claude-office-skills --skill xlsx -a codex
```

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

### Cursor

1. **Skills CLI (Vercel)**
```bash
npx skills add tfriedel/claude-office-skills --skill xlsx -a cursor
```

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

### GitHub Copilot

1. **GitHub CLI**
```bash
gh skill install tfriedel/claude-office-skills xlsx
```

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

### Gemini CLI

1. **Skills CLI (Vercel)**
```bash
npx skills add tfriedel/claude-office-skills --skill xlsx -a gemini-cli
```

2. **Platform CLI**
```bash
gemini skills install https://github.com/tfriedel/claude-office-skills --path public/xlsx
```

### Windsurf (Devin Desktop)

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

### OpenCode

**Skills CLI (Vercel)**
```bash
npx skills add tfriedel/claude-office-skills --skill xlsx -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/tfriedel/claude-office-skills/tree/HEAD/public/xlsx/SKILL.md

## When to use it
- build financial models with standard color coding and cell references
- update existing xlsx workbooks while preserving layout and formatting
- detect formula errors like #REF! and #DIV/0! before delivery
- replace static Python calculations with dynamic spreadsheet formulas

## Example prompts
- Build a revenue forecast in model.xlsx, put assumptions into dedicated cells, and verify formulas.
- Update data.xlsx with dynamic margin formulas instead of hardcoded numbers and run recalc.py.
- Inspect the sheets in report.xlsx and format all negative values with parentheses.

## Similar
- [kimi-xlsx](https://affpapa.org/en/nevibecode/skills/kimi-xlsx.md) — skill · 430 installs
- [xlsx-manipulation](https://affpapa.org/en/nevibecode/skills/xlsx-manipulation.md) — skill · 6500 installs
- [agent-xlsx](https://affpapa.org/en/nevibecode/skills/agent-xlsx.md) — skill · 766 installs
- [xlsx-author](https://affpapa.org/en/nevibecode/skills/xlsx-author.md) — skill · 1400 installs
- [minimax-xlsx](https://affpapa.org/en/nevibecode/skills/minimax-xlsx.md) — skill · 3800 installs
- [excel-automation](https://affpapa.org/en/nevibecode/skills/excel-automation.md) — skill · 1500 installs

## Other versions with the same name
- [xlsx · anthropics](https://affpapa.org/en/nevibecode/skills/xlsx.md) — 187223 installs
- [xlsx · appautomaton](https://affpapa.org/en/nevibecode/skills/appautomaton-xlsx.md) — 1300 installs
- [xlsx · bobmatnyc](https://affpapa.org/en/nevibecode/skills/bobmatnyc-xlsx.md) — 588 installs

From the same set: [tfriedel/claude-office-skills](https://affpapa.org/en/nevibecode/by/tfriedel/claude-office-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