sbroenne/mcp-server-excel

**Website** ·
**Installation** ·
**Features** ·
**Troubleshooting** ·
**2-minute demo**
**Automate real Microsoft Excel with AI.** Excel MCP Server lets GitHub Copilot,
Claude, ChatGPT, and other agents control Excel through natural-language
requests—using either MCP or a token-efficient CLI.
Unlike file-parser tools, ExcelMcp drives the **actual Excel application** through
its official COM API. It can refresh Power Query, recalculate formulas, evaluate
DAX, run VBA and Python =PY(), and preserve PivotTables, charts, macros, the
Data Model, and workbook formatting.
**60 MCP tools across 31 feature areas, with 414 operations**, cover end-to-end Excel automation.
> [!IMPORTANT]
> Requires **Windows**, **Microsoft Excel 2016 or later**, and an interactive
> desktop. It is not intended for Linux, macOS, or server-side batch processing.
🚀 Get Started
| Use case | Recommended path |
|---|---|
| **VS Code** | Install the extension |
| **Claude Desktop or another MCP client** | Install the MCP Server |
| **Coding agents (fewer AI tokens)** | Install the CLI |
| **Not sure which to choose?** | Read the installation overview |
For **GitHub Copilot CLI**, install either plugin from the
Awesome Copilot Excel listings:
Close open Excel workbooks before starting; ExcelMcp requires exclusive access
while automating them.
What You Can Automate
- **Data & analytics:**
Power Query, DAX, Power Pivot, Excel Tables, PivotTables, and data connections.
- **Cells & workbooks:**
ranges, formulas, formatting, worksheets, files, calculation, and named ranges.
- **Charts & visuals:**
charts, slicers, conditional formatting, screenshots, drawings, and sparklines.
- **Automation & advanced:**
VBA, Python in Excel, Goal Seek, scenarios, data tables, windows, and XML Maps.
Explore the capabilities behind all 414 operations.
Current command details come from CLI help or the MCP tool descriptions.
See It in Action
Ask in plain language:
- *"Import products.csv with Power Query and load it to the Data Model."*
- *"Create a PivotTable showing revenue by region, then add a column chart."*
- *"Use Goal Seek to find the price that produces $100,000 profit."*
- *"Show me Excel while you work."*
Because Excel performs the work, you can inspect results live and continue editing
the workbook normally.
See more examples and use cases.
MCP Server or CLI?
Both entry points expose the same Core commands and behavior, so the choice is
technical. Coding agents can use either one.
| Interface | Works with | Why |
|---|---|---|
| **MCP Server** | Any MCP-compatible client | Tool discovery and persistent sessions |
| **CLI (excelcli)** | Agents that can run terminal commands | Built-in help without loading MCP tool definitions, usually with fewer AI tokens |