# kimi-xlsx

A skill for spreadsheet work: builds .xlsx with openpyxl and pandas, checks formulas for errors, and creates pivot tables with charts.

- skill · `type=skill` · Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, OpenCode · 430 installs · ★ 240
- Author: thvroyal
- License: not stated · policy=link-only · description only; the file stays with the author
- Source: https://github.com/thvroyal/kimi-skills/tree/HEAD/skills/kimi-xlsx/SKILL.md
- Updated: 2026-03-28
- HTML: https://affpapa.org/en/nevibecode/skills/kimi-xlsx

## What it does

The skill turns the agent into a spreadsheet analyst. It creates XLSX, XLSM and CSV files, writes formulas, styles cells and adds charts. Everything runs on Python 3: pandas handles the data, openpyxl writes the file and applies formatting. Code runs in `ipython`, validation commands run in `shell`.

A CLI tool called KimiXlsx ships inside with six commands. `recheck` finds formula errors such as `#VALUE!` and `#DIV/0!`, zero-value results, and formulas that work in LibreOffice but break in MS Excel. `reference-check` flags ranges that overshoot the data and formulas that break the column pattern, `inspect` dumps the file structure as JSON, and `pivot` builds a pivot table with a chart. Read `pivot-table.md` before calling `pivot` — the command will not work without it.

When data comes from outside, the skill insists on citations: two columns `Source Name` and `Source URL`, or a dedicated Sources sheet. URLs go in as plain text, not the HYPERLINK function. Expect only the file you asked for. The skill skips readme docs and other extras to keep context small.

## Install

### Claude Code (native platform)

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

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

### Codex

1. **Skills CLI (Vercel)**
```bash
npx skills add thvroyal/kimi-skills --skill kimi-xlsx -a codex
```

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

### Cursor

1. **Skills CLI (Vercel)**
```bash
npx skills add thvroyal/kimi-skills --skill kimi-xlsx -a cursor
```

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

### GitHub Copilot

1. **GitHub CLI**
```bash
gh skill install thvroyal/kimi-skills kimi-xlsx
```

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

### Gemini CLI

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

2. **Platform CLI**
```bash
gemini skills install https://github.com/thvroyal/kimi-skills --path skills/kimi-xlsx
```

### Windsurf (Devin Desktop)

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

### OpenCode

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

## When to use it
- build an .xlsx from data and a template
- catch formula errors and zero-value cells
- create a pivot table with a chart
- spot references that overshoot the data range
- format a financial sheet with currency styling

## Example prompts
- build a sales report in output.xlsx with formulas and a chart
- check output.xlsx for formula errors
- create a pivot table from the Sales sheet summing Revenue

## Similar
- [xlsx](https://affpapa.org/en/nevibecode/skills/appautomaton-xlsx.md) — skill · 1300 installs
- [agent-xlsx](https://affpapa.org/en/nevibecode/skills/agent-xlsx.md) — skill · 766 installs
- [xlsx-manipulation](https://affpapa.org/en/nevibecode/skills/xlsx-manipulation.md) — skill · 6500 installs
- [minimax-xlsx](https://affpapa.org/en/nevibecode/skills/minimax-xlsx.md) — skill · 3800 installs
- [xlsx-generator](https://affpapa.org/en/nevibecode/skills/xlsx-generator.md) — skill · 393 installs
- [xlsx-author](https://affpapa.org/en/nevibecode/skills/xlsx-author.md) — skill · 1400 installs

From the same set: [thvroyal/kimi-skills](https://affpapa.org/en/nevibecode/by/thvroyal/kimi-skills.md) — 3 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