excel-mcp-automation — Claude Code skill: features and setup
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.
no license 105 installs ★ 9 updated 2026-10-09
npx skills add reason-machines/mcp-skills --skill excel-mcp-automation -a claude-codeWhat excel-mcp-automation 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.
What it helps with
- 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 for the agent
- Create
Sales.xlsx, fillA1:D10with the data, and format it as an Excel table. - Build a PivotTable from
A1:D100; putProductin the rows and sumSales. - Create a Power Query named
ImportCSVthat imports data fromdata.csv.
How to install excel-mcp-automation
1Skills CLI (Vercel)
npx skills add reason-machines/mcp-skills --skill excel-mcp-automation -a claude-code2Manually: put the files in place
~/.claude/skills/excel-mcp-automation/SKILL.mdCopy the whole skill folder; for one project use .claude/skills/excel-mcp-automation/
1Skills CLI (Vercel)
npx skills add reason-machines/mcp-skills --skill excel-mcp-automation -a codex2Manually: put the files in place
.agents/skills/excel-mcp-automation/SKILL.mdFor all projects use ~/.agents/skills/
1Skills CLI (Vercel)
npx skills add reason-machines/mcp-skills --skill excel-mcp-automation -a cursor2Manually: put the files in place
.cursor/skills/excel-mcp-automation/SKILL.mdCursor also reads .agents/skills/ and .claude/skills/
1GitHub CLI
gh skill install reason-machines/mcp-skills skills/excel-mcp-automation2Manually: put the files in place
.github/skills/excel-mcp-automation/SKILL.md1Skills CLI (Vercel)
npx skills add reason-machines/mcp-skills --skill excel-mcp-automation -a gemini-cli2Platform CLI
gemini skills install https://github.com/reason-machines/mcp-skills --path skills/excel-mcp-automationManually: put the files in place
.devin/skills/excel-mcp-automation/SKILL.mdThe legacy .windsurf/skills/ path still works
Skills CLI (Vercel)
npx skills add reason-machines/mcp-skills --skill excel-mcp-automation -a opencodeClaude.ai
Zip the folder and upload it in Settings → Capabilities → Skills
Step by step, with commands for each platform: How to install skills in Claude Code: five ways
Questions about excel-mcp-automation
How do I install excel-mcp-automation in Claude Code?
Run npx skills add reason-machines/mcp-skills --skill excel-mcp-automation -a claude-code. The skill file will be at ~/.claude/skills/excel-mcp-automation/SKILL.md.
What does excel-mcp-automation do?
It guides an AI agent through Excel tasks, from editing ranges and formatting cells to working with PivotTables, Power Query, DAX, and VBA.
What does this skill need to control Excel?
It requires Windows, Microsoft Excel 2016 or later, and a desktop environment. Its COM-based Excel control is not intended for server-side processing.