MCP server: One MCP server.

MCP Server for Excel

@sbroenneMCP server · External

Excel automation for AI - Sheets, Power Query, DAX, VBA, Tables, Ranges and more. Windows only.

Spreadsheetsv2.5.3MITC#
Freeno charge per call

Runs on your machine from its package; the steps are below.

A sales table, regional summary, and chart created in the real Excel application by Excel MCP Server
From the README

What it does

  1. Reads
  2. Writes
  3. High impact

At most: moves money, runs code or commands, deletes data, or sends messages for you.

What it costs

Free

Odel charges nothing per call. The publisher may charge for its own service.

Runs locally over stdio

This server isn't hosted — your MCP client launches it from a package registry. Use one of the commands below, or drop the config into your client (e.g. Claude Desktop).

NuGetSbroenne.ExcelMcp.McpServerv2.5.3

Published to NuGet as `Sbroenne.ExcelMcp.McpServer` — run it with your .NET MCP host.

npm@sbroenne/mcp-server-excelv2.5.3

Run

npx -y @sbroenne/mcp-server-excel

MCP client config

{
  "mcpServers": {
    "mcp-server-for-excel": {
      "command": "npx",
      "args": [
        "-y",
        "@sbroenne/mcp-server-excel"
      ]
    }
  }
}
README3 min read

ExcelMcp - MCP Server for Microsoft Excel

VS Code Marketplace Installs Downloads

CI Gate Release

License: MIT .NET Platform Built with Copilot

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.

63 MCP tools across 33 feature areas, with 424 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 caseRecommended path
VS CodeInstall the extension
Claude Desktop or another MCP clientInstall 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:

powershell
copilot plugin install excel-mcp@awesome-copilot
# Or, for command-line Excel automation:
copilot plugin install excel-cli@awesome-copilot

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 424 operations. Current command details come from CLI help or the MCP tool descriptions.

See It in Action

A sales table, regional summary, and chart created in the real Excel application by Excel MCP Server

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 Excel commands and behavior, so the choice is technical. Coding agents can use either one.

InterfaceWorks withWhy
MCP ServerAny MCP-compatible clientTool discovery and persistent sessions
CLI (excelcli)Agents that can run terminal commandsBuilt-in help without loading MCP tool definitions, usually with fewer AI tokens

The MCP Server calls the ExcelMcp service in-process. The CLI uses a background daemon so workbook sessions persist across commands.

text
AI assistant or script
        │
   MCP Server / CLI
        │
 Shared Excel commands
        │
 Real Excel COM API

Read the architecture or browse the MCP Server and CLI guides.

⭐ GitHub Star History

GitHub stars over time for ExcelMcp

📋 Additional Information

Documentation · Changelog · Contributing · Security · Privacy

License: MIT License - see LICENSE file

Other projects by the author:

Similar modules

Browse Spreadsheets