Skip to main content
skill CX Codex

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

Install into Claude Code · Skills CLI (Vercel) All methods and platforms ↓
npx skills add reason-machines/mcp-skills --skill excel-mcp-automation -a claude-code
Open on GitHub

What 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, 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.

How to install excel-mcp-automation

1Skills CLI (Vercel)

npx skills add reason-machines/mcp-skills --skill excel-mcp-automation -a claude-code

2Manually: put the files in place

~/.claude/skills/excel-mcp-automation/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/excel-mcp-automation/

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.

Similar skills

All skills for Office documents →

From the same set98

The whole set →
mcp-server-catalog-reference mcp-server-catalog-reference is a Claude Code skill listing 50 MCP servers in nine categories, with install commands, risk flags, and selection rules. It helps choose what to connect to an agent. CX Codex +1 111installs 50-essential-mcp-servers-reference 50-essential-mcp-servers-reference is a skill for Claude Code, Codex, and Gemini CLI that guides the selection, configuration, and secure installation of MCP servers without context bloat. CX Codex +1 110installs mcp-servers-essential-reference mcp-servers-essential-reference is a Claude Code skill with installation commands and security guidance for 50+ MCP servers across development, data, ops, and integrations. CX Codex +1 110installs multi-llm-mcp-server The multi-llm-mcp-server skill connects Claude Code with Codex CLI and multiple language models. Use it to compare parallel model responses or hand code analysis to Codex. CX Codex +1 107installs claude-tradingview-mcp-autotrading The claude-tradingview-mcp-autotrading is a Claude Code skill connecting an agent to TradingView charts and executing BitGet trades. It checks all strategy conditions before each trade and logs executions to CSV for tax records. CX Codex +1 104installs huolala-figma-mcp huolala-figma-mcp connects an MCP service that translates Figma designs into interface code packages with sliced graphics and intermediate DSL data. CX Codex +1 102installs matlab-mcp-server Skill for executing MATLAB code from AI assistants via Model Context Protocol. Lets agents run calculations, assess code quality, and manage MATLAB sessions. CX Codex +1 102installs codex-control-plane-mcp codex-control-plane-mcp is a Claude Code and Codex skill that turns Codex Desktop into a durable worker for long tasks via an MCP server. CX Codex +1 100installs

Project sponsors

Companies that keep this analytics open