Excel MCP Server
Microsoft Excel automation via COM API for live workbook data manipulation.
Data last scanned yesterday · Reviewed 3 weeks ago
Overview
This server utilizes the official Microsoft Excel COM API to provide a bridge between conversational AI and your local desktop Excel application. By interacting with the actual Excel process running on your machine, it preserves all complex workbook features, including existing formulas, macros, VBA scripts, and data models that standard file-parsing tools often struggle to maintain. The toolset covers a wide array of functionality, spanning 26 specific tools and 234 distinct operations. Users can automate tasks such as managing Power Query workflows, executing DAX measures, refreshing PivotTables, generating charts, and performing data formatting. Because it drives the live Excel engine, it supports advanced features like recalculating the data model and running Python code directly within Excel's environment.
Our verdict
With a security score of 48/100, this project is classified as high-risk. The primary concerns stem from the lack of an independent editorial review and the fact that its authentication mechanisms have not been vetted. Furthermore, because it operates via the Windows COM API, it requires direct control over your local Excel process. This tool is best suited for experienced developers working in isolated environments who understand the risks of third-party automation tools and who can verify the integrity of the code themselves.
- Supports live Excel engine operations including Power Query and DAX.
- Zero direct dependencies reduces the supply-chain attack surface.
- Validates tool usage via automated pytest-skill-engineering workflows.
- High-risk security score due to unreviewed authentication and API usage.
- Requires Windows and a locally installed desktop copy of Excel.
- Community-maintained rather than official Microsoft software.
Setup
{
"mcpServers": {
"mcp-server-excel": {
"args": [
"-y",
"excelmcp"
],
"command": "npx"
}
}
}Paste into ~/Library/Application Support/Claude/claude_desktop_config.json (macOS) or %APPDATA%\Claude\claude_desktop_config.json (Windows), then restart Claude Desktop. Some servers require API keys or tokens as environment variables — check the project's README and add an "env" object if needed.
- No read-only mode — running this grants full read/write access.
- No built-in authentication — anyone with access to this config can invoke every tool it exposes.
Tools
| Tool | Description | Risk |
|---|---|---|
| powerquery | import and reshape data from files, databases, and APIs | medium |
| range | read and write cell values, formulas, and formatting | medium |
| range_format | read and write cell values, formulas, and formatting | medium |
| pivottable | summarize and analyze data | medium |
| chart | visualize results | medium |
| datamodel | build a Power Pivot model with DAX measures | medium |
| vba | run macros and scripted automation | high |
| Get/Set Values | Read or write cell values | medium |
| Get/Set Formulas | Read or write formulas | medium |
| Clear All/Contents/Formats | Clear a range's contents, formats, or both | medium |
Compatibility
| Client | Local | Docker | Remote | Read-only |
|---|---|---|---|---|
| ChatGPT | ||||
| Claude Desktop | ||||
| Cursor | ||||
| VS Code | ||||
| Windsurf |
Frequently asked questions
›What are the core system requirements to run this server?
This server requires a Windows environment and Microsoft Excel 2016 or later to be installed on the machine.
›Can I use this server for server-side Excel processing?
No, the server is not intended for server-side processing because it controls the actual Excel desktop application process via COM interop.
›Does this tool work by parsing Excel files directly?
No, it interacts directly with the live Excel application through its official COM API, allowing it to perform live operations like refreshing Power Query, evaluating DAX, and running VBA macros.
›Are there limitations on the types of Excel files this server can open?
The server supports IRM and AIP-protected files, as it leverages the full capabilities of the installed Excel application.
Changelog
- FixExcelMcp 1.10.5
2026-08-07
- FixExcelMcp 1.10.4
2026-08-07
- NewExcelMcp 1.10.3
2026-07-27
- FixExcelMcp 1.10.2
2026-07-26
- FixExcelMcp 1.10.1
2026-07-23
- FixExcelMcp 1.10.0
2026-07-23
- FixExcelMcp 1.9.5
2026-07-14
- FixExcelMcp 1.9.4
2026-07-10
- FixExcelMcp 1.9.1
2026-07-09
- NewExcelMcp 1.9.0
2026-07-08
Badge
Maintain this server? Add the live badge to your README.