What is Excel MCP Server?
Excel MCP Server, also called ExcelMcp, is a community project by Stefan Broenner that controls desktop Microsoft Excel through its official COM automation interface rather than editing .xlsx files directly. Because Excel does the work, an agent can refresh Power Query, recalculate, build PivotTables and charts, query the Data Model with DAX, edit and run VBA, and write Python in Excel formulas, and the workbook keeps its macros and formatting. It exposes 64 MCP tools covering 437 operations, and the same commands through a CLI, excelcli, aimed at coding agents.
It needs Windows 10 or later, Excel 2016 or later and a signed-in desktop session. The project is MIT-licensed C# on .NET 10, started in October 2025, and had about 887 GitHub stars and 201 releases when checked; v2.6.12 came out on 10 November 2026. The npm package was downloaded 2,201 times in the week to 12 November 2026.
How to install Excel MCP Server
npx -y @sbroenne/mcp-server-excel@latestIs Excel MCP Server worth it?
Most spreadsheet servers parse the file, which is fine for reading cells and useless for anything Excel computes. A Power Query that needs refreshing, a PivotTable over the Data Model or a macro-driven model only behaves correctly inside Excel. Excel MCP Server works there, through the same COM interface that VBA and Office add-ins use, so a refresh, a recalculation or a Goal Seek gives the numbers Excel itself would show.
The breadth is unusual: 64 tools spanning ranges, tables, Power Query, DAX queries, PivotTables, charts, slicers, conditional formatting, named ranges, scenarios and VBA. It is also maintained at a pace few MCP servers match, with 201 releases in about 13 months. The 2.6.12 notes are typical of the care involved: refresh-all had been reporting PivotTables as refreshed while their totals were still stale, and now refreshes each one.
Be clear about what it can run. It can import, replace and run VBA procedures, which is code execution on your machine with your user rights. The docs say normal opens keep macros disabled, running a macro needs a separately approved reopen during which auto-run code may fire, and editing a VBA project needs Excel's trust setting switched on by hand. Python in Excel sends code and referenced cells to Microsoft's cloud, and optional M and DAX formatting sends that code to two outside formatter sites. The privacy policy says release builds send pseudonymous usage telemetry, without file names or cell contents, to Azure Application Insights by default; EXCELMCP_TELEMETRY_MODE=off stops it.
The catch: it is Windows-only and needs an interactive desktop, so Mac users, Linux servers and unattended batch jobs are out. Excel runs hidden by default, a blocking dialog can stall a session, batch operations do not roll back after a failure, and closing without saving discards edits for good. Any program running as your user can reach the CLI's background service.
Our take: if the workbook's value lives in its queries, pivots and macros, this is the server that can actually touch them; if you only need to read numbers out of files, a file parser is simpler and runs anywhere.
Where it earns its place
A financial analyst at a 200-person company closing the month
Refresh the Power Query sources, update the PivotTables and check the totals
Ask the agent to open the workbook, run refresh-all and read back the pivot totals against last month. The workbook stays a normal Excel file; save a copy first, since failed batches do not roll back.
A BI developer maintaining Power Pivot models for a sales team
Write and test DAX measures without hand-editing in the Power Pivot window
The agent adds measures to the Data Model and evaluates DAX queries to check results. DAX queries need the MSOLAP provider, which Power BI Desktop installs; leave DAX formatting off unless you accept sending formulas to DAX Formatter.
An operations manager inheriting a macro-heavy .xlsm planning file
Understand what the VBA modules do before changing anything
List the procedures, read them and search across modules for a sheet name, all without running code. Reading needs Excel's VBA trust setting on; only approve the macro-enabled reopen once you have read what will run.
Before you commit
- Setup
- Install the VS Code extension, double-click the .mcpb bundle for Claude Desktop, or add npx -y @sbroenne/mcp-server-excel@latest to any MCP client; a standalone exe and a dotnet tool are also offered. Needs Windows 10 or later, Excel 2016 or later and Node.js 18 for the npm routes. Restart the client after updates so it reloads the tool list.
- Integrations
- 64 tools over 437 operations; the excelcli CLI exposes the same commands for coding agents with fewer tokens. GitHub Copilot plugins, a VS Code extension and an MCP bundle for Claude Desktop. Works on .xlsx and .xlsm files.
- Data and privacy
- Workbooks are read and written locally through Excel; data the agent asks for goes to your model provider. Release builds send pseudonymous usage telemetry to Azure Application Insights unless EXCELMCP_TELEMETRY_MODE=off. Python in Excel sends code and cell data to Microsoft's cloud; M and DAX formatting, off by default, sends code to outside formatters. VBA tools can edit and run macros with your user rights.
- Cost at scale
- Free under MIT, but each machine needs a licensed desktop Excel, and Python in Excel needs a Microsoft 365 plan that includes it. There is no paid tier or hosted service.
- Limits
- No macOS, Linux or server-side batch use. Calls in one session run one at a time; a blocking Excel dialog can stall them. Only .xlsx and .xlsm are accepted, up to 1 GB. Closing without saving loses edits, and batch failures are not rolled back.
What’s good
- Works in real Excel, so refreshes and recalculations are exact
- 64 tools covering Power Query, DAX, PivotTables, charts and VBA
- Very active: 201 releases since October 2025
- MCP server and CLI share the same commands
What’s not
- Windows, desktop Excel and a signed-in session required
- Telemetry is on by default in release builds
- Can run VBA macros with your user rights
- Failed batch operations do not roll back
Best for
Finance, operations and BI analysts on Windows whose workbooks depend on Power Query, PivotTables, the Data Model or VBA, and who want an agent to work in them.
Excel MCP Server alternatives
Excel MCP Server: common questions
- Is Excel MCP Server worth it?
- The serious choice for agents that must work inside real Excel workbooks, as long as you run it on Windows, turn off its telemetry if that matters to you, and treat VBA as code execution. We rate it 4.2 out of 5.
- How much does Excel MCP Server cost?
- Free and open source (MIT). Needs a licensed copy of desktop Excel 2016 or later; Python in Excel needs a Microsoft 365 plan that includes it.
- What are the downsides of Excel MCP Server?
- Windows, desktop Excel and a signed-in session required; telemetry is on by default in release builds; can run VBA macros with your user rights; failed batch operations do not roll back.
- Who is Excel MCP Server best for?
- Finance, operations and BI analysts on Windows whose workbooks depend on Power Query, PivotTables, the Data Model or VBA, and who want an agent to work in them.
- How much does Excel MCP Server cost for a team or in production?
- Free under MIT, but each machine needs a licensed desktop Excel, and Python in Excel needs a Microsoft 365 plan that includes it. There is no paid tier or hosted service.
- Is Excel MCP Server safe for company data?
- Workbooks are read and written locally through Excel; data the agent asks for goes to your model provider. Release builds send pseudonymous usage telemetry to Azure Application Insights unless EXCELMCP_TELEMETRY_MODE=off. Python in Excel sends code and cell data to Microsoft's cloud; M and DAX formatting, off by default, sends code to outside formatters. VBA tools can edit and run macros with your user rights.
- What are the best Excel MCP Server alternatives?
- The closest alternatives we have reviewed are MarkItDown MCP and LocalData MCP.
Answers checked Nov 13, 2026.
Make Excel MCP Server? Show this rating on your site
