Skip to content
MCP server

MCP Server for Excel

Drive real desktop Excel from AI: Power Query, DAX, VBA, PivotTables and charts

Runs locallyStatus and history
Pricing
Open source
Platforms
Windows, CLI, vscode
Runs
Locally
Version
2.6.12
Listing updated
3 days ago

About MCP Server for Excel

MCP Server for Excel is an open-source MCP server for files and documents. It runs locally on your machine and is started by your AI client.

This server controls the installed Excel application through its COM API instead of rewriting .xlsx files with a parser library. The maintainers argue that this keeps PivotTables, charts, macros and the Data Model intact, and lets Excel itself refresh Power Query, recalculate, evaluate DAX and run VBA or Python in Excel. Excel opens and saves the workbook, though requested edits can still change its data or formatting.

The README counts 64 MCP tools across 33 feature areas and 437 operations, spanning data and analytics, cells and workbooks, charts and visuals, and automation topics such as Goal Seek, scenarios and data tables. A command-line interface exposes the same commands for coding agents that want fewer tokens.

It needs Windows, Microsoft Excel 2016 or later and an interactive desktop session, and the README says it is not meant for Linux, macOS or server-side batch jobs. It ships on NuGet and npm, has a VS Code extension, and is MIT licensed.

Install

Run in a terminal

claude mcp add mcp-server-excel -- npx -y @sbroenne/mcp-server-excel

Add to claude_desktop_config.json

{
  "mcpServers": {
    "mcp-server-excel": {
      "command": "npx",
      "args": [
        "-y",
        "@sbroenne/mcp-server-excel"
      ]
    }
  }
}
Install in CursorOpens Cursor, which asks you to confirm. Or add it by hand:

Add to ~/.cursor/mcp.json

{
  "mcpServers": {
    "mcp-server-excel": {
      "command": "npx",
      "args": [
        "-y",
        "@sbroenne/mcp-server-excel"
      ]
    }
  }
}
Install in VS CodeOpens VS Code, which asks you to confirm. Or add it by hand:

Add to .vscode/mcp.json

{
  "servers": {
    "mcp-server-excel": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@sbroenne/mcp-server-excel"
      ]
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json

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

Add to your client's MCP settings (most use this shape)

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

What it does

Real Excel engine
Automates the actual Excel app through COM rather than parsing files.
Power Query and M code
Create, edit and refresh queries and manage load destinations.
Power Pivot and DAX
Build Data Models, DAX measures and table relationships.
PivotTables and charts
Create PivotTables and charts from ranges, tables or the Data Model.
VBA and Python in Excel
View, import and run VBA modules and =PY() formulas.
Live view of the work
Ask the agent to show Excel while it works and keep editing normally.
CLI alternative
The same commands are available as a token-efficient command line.

Good for

  • Import a CSV with Power Query and load it to the Data Model
  • Build a PivotTable of revenue by region with a chart
  • Run Goal Seek to find a price that hits a profit target
  • Export VBA modules for version control
  • Refresh data connections and recalculate a workbook

Pricing

Open source

MIT licensed; requires a licensed Excel install

Prices change. Check excelmcpserver.dev before you buy.

MCP Server for Excel FAQ

What does it require?

Windows, desktop Microsoft Excel 2016 or later and an interactive desktop session.

Does it work on macOS or Linux?

No. The README says it is not intended for Linux, macOS or server-side batch processing.

How is it different from file-parser Excel servers?

It drives Excel itself, so Power Query, DAX and VBA actually run and PivotTables, charts and macros are preserved.

How do I install it?

Via NuGet or npm, the VS Code extension, or the Copilot CLI plugin; the website has install guides for the MCP server and the CLI.

Is MCP Server for Excel free?

Yes. MCP Server for Excel is open source, so you can use and self-host it for free.

How do I add MCP Server for Excel to Claude Code?

Run this command in your terminal: claude mcp add mcp-server-excel -- npx -y @sbroenne/mcp-server-excel

What are the best alternatives to MCP Server for Excel?

The closest alternatives to MCP Server for Excel are Ha MCP, Concord MCP, note1, ASTra and CalderFlow.

Alternatives to MCP Server for Excel

  1. Ha MCP

    MCP server

    MCP server for managing and automating Home Assistant from AI assistants

    Runs locally
    • 8 tools
    • Open source
    • 7.9K GitHub stars
    • Productivity
  2. Concord MCP

    MCP server

    Local-first MCP server for messaging and shared work-state between coding agents

    Runs locally
    • Freemium
    • 1.3K GitHub stars
    • Developer tools
  3. note1

    MCP server

    MCP server giving AI assistants search and summaries across your note1 meetings

    • 4 tools
    • Remote
    • Free trial
    • 1 GitHub star
    • Productivity
  4. ASTra

    MCP server

    Let agents read, edit, validate and undo Word .docx files with exact operations

    Runs locally
    • 5 tools
    • Freemium
    • Files and documents
  5. CalderFlow

    MCP server

    Turn notes or specs into editable flowcharts, timelines and funnels from an AI assistant

    • 10 tools
    • Remote
    • Free
    • Design and media
  6. CARTESIAN ECU

    MCP server

    Check and repair ECU and TCU flash-file checksums from Claude (Ultimate plan)

    Not checked yet
    • 5 tools
    • Remote
    • Paid
    • Files and documents