What it is
ExcelMcp (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 (excelcli). Unlike file-parser tools, it drives the actual Excel application through its official COM API. The README states 60 MCP tools across 31 feature areas with 393 operations, which differs from the catalog description's figure of 326.
Who it's for
- Windows users who want an AI assistant to automate desktop Excel through natural-language requests
- VS Code or Claude Desktop users who want Excel available as an MCP tool
- Developers of coding agents and scripts who want a compact CLI for Excel automation
Requirements
Requirements
- Windows
- Microsoft Excel 2016 or later
- An interactive desktop
- Open Excel workbooks closed before starting, since ExcelMcp needs exclusive access while automating them
Setup
VS Code
Install the extension from the VS Code Marketplace (sbroenne.excel-mcp): https://marketplace.visualstudio.com/items?itemName=sbroenne.excel-mcp
Claude Desktop or another MCP client
Follow the MCP Server installation guide: https://excelmcpserver.dev/installation-mcp-server/
Coding agents and scripts
Follow the CLI installation guide: https://excelmcpserver.dev/installation-cli/
Close open workbooks
Close any open Excel workbooks before starting; ExcelMcp needs exclusive access while automating them.
Examples
Power Query import to Data Model
PromptImport products.csv with Power Query and load it to the Data Model.Expected output: Uses the Power Query and Data Model automation described in the README.
PivotTable and chart
PromptCreate a PivotTable showing revenue by region, then add a column chart.Expected output: Combines the PivotTable and chart features in a single request.
Goal Seek
PromptUse Goal Seek to find the price that produces $100,000 profit.Expected output: Runs Excel's Goal Seek, listed under the automation and advanced features.
Watch Excel live
PromptShow me Excel while you work.Expected output: Excel does the work, so you can inspect results live and keep editing the workbook.
Pros & cons
Pros
- Pro:Drives the real Excel application through its COM API, so it can refresh Power Query, recalculate formulas, evaluate DAX and run VBA
- Pro:Preserves PivotTables, charts, macros, the Data Model and workbook formatting
- Pro:Offers both an MCP Server (tool discovery, persistent sessions) and a CLI with substantially lower token usage
- Pro:You can watch results live in Excel and keep editing the workbook
Cons
- Con:Windows only; not intended for Linux or macOS
- Con:Requires Microsoft Excel 2016 or later and an interactive desktop; not for server-side batch processing
- Con:Needs exclusive access to workbooks, so open ones must be closed first
Images
Related
Repo hetpatel-11/Adobe_Premiere_Pro_MCP
Adobe Premiere Pro MCP. Tools for AI-driven video editing via MCP, for Codex, Claude, and other MCP clients.
Repo makafeli/n8n-workflow-builder
AI assistant integration for n8n workflow automation through Model Context Protocol (MCP). Connect Claude Desktop, ChatGPT, and other AI assistants to n8n for natural language workflow management.
Repo punkpeye/awesome-mcp-servers
A collection of MCP servers.
Repo morluto/rea
Reverse engineer anything with agents, from app behavior down to native binaries.
Repo ahujasid/mcp-for-blender
Community plugin to control Blender 3D with any LLM of your choice. Not affiliated with the official Blender Foundation.
Repo enescingoz/awesome-n8n-templates
280+ free n8n automation templates — ready-to-use workflows for Gmail, Telegram, Slack, Discord, WhatsApp, Google Drive, Notion, OpenAI, and more. AI agents, RAG chatbots, email automation, social media, DevOps, and document processing. The largest open-source n8n template collection.