# excel-mcp-automation

excel-mcp-automation is a Claude Code skill for working with Excel ranges, PivotTables, Power Query, DAX, VBA, and charts through an AI agent. It can inspect or change an Excel workbook.

- skill · `type=skill` · Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, OpenCode, Windsurf (Devin Desktop), Claude.ai · 105 installs · ★ 9 repo stars
- Author: reason-machines
- License: not stated · policy=link-only · description only; the file stays with the author
- Source: https://github.com/reason-machines/mcp-skills/tree/HEAD/skills/excel-mcp-automation/SKILL.md
- Updated: 2026-10-09
- Security check: automated, 2026-11-16 (text) — no signs of malicious code found.
- HTML: https://affpapa.org/en/nevibecode/skills/excel-mcp-automation

## What it does

The skill covers Excel automation through COM. It describes operations for editing ranges, formulas, and tables, building PivotTables and charts, and working with Power Query, the data model, and VBA. It also covers connections and slicers; ranges or sheets can be captured as PNG images.

The documented setup requires Windows, Microsoft Excel 2016 or later, and a desktop environment. Server-side processing is outside its scope. That Windows requirement matters: COM-based control of Excel will not run on a non-Windows machine. The documentation presents both a CLI and an MCP server, with CLI commands arranged by operation category.

## Install

### Claude Code (native platform)

1. **Skills CLI (Vercel)**
```bash
npx skills add reason-machines/mcp-skills --skill excel-mcp-automation -a claude-code
```

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

### Codex

1. **Skills CLI (Vercel)**
```bash
npx skills add reason-machines/mcp-skills --skill excel-mcp-automation -a codex
```

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

### Cursor

1. **Skills CLI (Vercel)**
```bash
npx skills add reason-machines/mcp-skills --skill excel-mcp-automation -a cursor
```

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

### GitHub Copilot

1. **GitHub CLI**
```bash
gh skill install reason-machines/mcp-skills skills/excel-mcp-automation
```

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

### Gemini CLI

1. **Skills CLI (Vercel)**
```bash
npx skills add reason-machines/mcp-skills --skill excel-mcp-automation -a gemini-cli
```

2. **Platform CLI**
```bash
gemini skills install https://github.com/reason-machines/mcp-skills --path skills/excel-mcp-automation
```

### Windsurf (Devin Desktop)

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

### OpenCode

**Skills CLI (Vercel)**
```bash
npx skills add reason-machines/mcp-skills --skill excel-mcp-automation -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/reason-machines/mcp-skills/tree/HEAD/skills/excel-mcp-automation/SKILL.md

## When to use it
- fill an Excel range with values and turn it into a table
- create a PivotTable with selected fields and an aggregation
- write a Power Query import for a CSV file
- add a DAX measure or connect tables in the data model
- build a chart and configure its data series

## Example prompts
- Create `Sales.xlsx`, fill `A1:D10` with the data, and format it as an Excel table.
- Build a PivotTable from `A1:D100`; put `Product` in the rows and sum `Sales`.
- Create a Power Query named `ImportCSV` that imports data from `data.csv`.

## Similar
- [MCP Server for Excel](https://affpapa.org/en/nevibecode/mcp/mcp-server-for-excel.md) — MCP server · ★ 933 repo stars
- [excel-mcp](https://affpapa.org/en/nevibecode/plugins/excel-mcp.md) — plugin · ★ 2 repo stars
- [excel](https://affpapa.org/en/nevibecode/skills/excel.md) — skill · 3 installs
- [excel-automation](https://affpapa.org/en/nevibecode/skills/excel-automation.md) — skill · 1500 installs
- [power-bi-retail-analytics-dashboard](https://affpapa.org/en/nevibecode/skills/power-bi-retail-analytics-dashboard.md) — skill · 384 installs
- [agent-xlsx](https://affpapa.org/en/nevibecode/skills/agent-xlsx.md) — skill · 782 installs

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