A
licenseNot graded
qualityC
maintenanceA Model Context Protocol (MCP) server that enables AI assistants to interact with Excel Power Pivot data models. Create and manage DAX measures, relationships, and more through natural language.
4
MIT
Excel MCP Server (uses Excel App, 100% Compatibility)
by sbroenne
Enables GitHub Copilot to automate Excel through natural language commands, including Power Query, DAX measures, VBA macros, PivotTables, charts, formatting, and data transformations using Excel's native COM API.
Click on "Install Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@Excel MCP Server (uses Excel App, 100% Compatibility)create a pivot table from the SalesData table showing top 10 products by region"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
ExcelMcp - MCP Server for Microsoft Excel
Website · Installation · Features · Troubleshooting · 1-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.
31 tools with 326 operations cover end-to-end Excel automation.
IMPORTANT
RequiresWindows, 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 | |
Claude Desktop or another MCP client | |
Coding agents and scripts | |
Not sure which to choose? |
Close open Excel workbooks before starting; ExcelMcp requires exclusive access while automating them.
Related MCP server: fcp-sheets
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 complete reference for all 326 operations.
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.
Interface | Best for | Why |
MCP Server | Conversational assistants and exploratory work | Rich schemas, tool discovery, and persistent sessions |
CLI ( | Coding agents, automation, and scripts | One compact tool surface and substantially lower token usage |
The MCP Server calls the ExcelMcp service in-process. The CLI uses a background daemon so workbook sessions persist across commands.
AI assistant or script
│
MCP Server / CLI
│
ExcelMcp Core commands
│
Real Excel COM APIRead the architecture or browse the MCP Server and CLI guides.
⭐ GitHub Star History
📋 Additional Information
Documentation · Changelog · Contributing · Security · Privacy
License: MIT License - see LICENSE file
Related Projects
Other projects by the author:
PowerPoint MCP Server — AI-powered PowerPoint automation via MCP, the sister project to this one
pytest-skill-engineering — LLM-powered testing framework for AI agents
Windows MCP Server — AI-powered Windows automation via MCP
OBS Studio MCP Server — AI-powered OBS Studio automation
This server cannot be installed
Maintenance
–Maintainers
1dResponse time
1dRelease cycle
147Releases (12mo)
Commit activity
Issues opened vs closed
Resources
Unclaimed servers have limited discoverability.
Looking for Admin?
If you are the server author, to access and configure the admin panel.
Related MCP Servers
- AlicenseBqualityCmaintenanceMCP server for semantic spreadsheet operations that lets LLMs create and edit Excel workbooks by describing spreadsheet intent.42MIT
- AlicenseCqualityBmaintenanceLocal-first MCP server for Power BI Desktop automation. Automate semantic model changes, DAX, Power Query, Excel, and report layout from MCP-capable AI clients.100MIT
- AlicenseNot gradedqualityCmaintenanceA Python-based MCP server that exposes Power BI semantic models to Claude, enabling natural-language querying of Power BI data through tools like listing workspaces, exploring datasets, executing DAX queries, and triggering refreshes.MIT
Related MCP Connectors
Official Microsoft MCP Server to query Microsoft Entra data using natural language
GibsonAI MCP server: manage your databases with natural language
Hosted Amazon Seller and Vendor MCP server for Claude, ChatGPT, Cursor, Codex, Gemini, Copilot.
Appeared in Searches
Latest Blog Posts
- Who's Calling? MCP Hosts Are an Identity Blind Spot (And the Spec Knows It)By Om-Shree-0709 on .mcpAgent IdentityOAuth 2.1
- Your AI Chatbot Just Exposed Your CEO's Salary to an InternBy Om-Shree-0709 on .Agent IdentityMCP SecurityOAuth Delegation
- Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)By Om-Shree-0709 on .Agentic AiPrompt InjectionWebAssembly
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/sbroenne/mcp-server-excel'
If you have feedback or need assistance with the MCP directory API, please join our Discord server