# MCP Server for Excel

> MCP Server for Excel is an open-source MCP server for files and documents. Drive real desktop Excel from AI: Power Query, DAX, VBA, PivotTables and charts. It runs locally on your machine and is started by your AI client.

- **Kind:** MCP server
- **Pricing:** Open source
- **Platforms:** Windows, CLI, vscode
- **Website:** https://excelmcpserver.dev
- **Repository:** https://github.com/sbroenne/mcp-server-excel
- **MCP Registry name:** io.github.sbroenne/mcp-server-excel
- **Categories:** files and documents, productivity
- **Listing updated:** 2026-11-14

## About

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.

## Features

- **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

## Install

### Claude Code (Terminal)

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

### Claude Desktop (claude_desktop_config.json)

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

### Cursor (~/.cursor/mcp.json)

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

### VS Code (.vscode/mcp.json)

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

### Windsurf (~/.codeium/windsurf/mcp_config.json)

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

### Other clients (your client's MCP settings (most use this shape))

```json
{
  "mcpServers": {
    "mcp-server-excel": {
      "command": "npx",
      "args": [
        "-y",
        "@sbroenne/mcp-server-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

- [Ha MCP](https://ai-powered.com/mcp/ha-mcp): Ha MCP is an open-source MCP server for productivity.
- [Concord MCP](https://ai-powered.com/mcp/concord-mcp): Concord MCP is a freemium MCP server for developer tools.
- [note1](https://ai-powered.com/mcp/note1): note1 is an MCP server for productivity.
- [ASTra](https://ai-powered.com/mcp/astra): ASTra is a freemium MCP server for files and documents.
- [CalderFlow](https://ai-powered.com/mcp/calderflow): CalderFlow is a free MCP server for design and media.
- [CARTESIAN ECU](https://ai-powered.com/mcp/cartesian-ecu): CARTESIAN ECU is a paid MCP server for files and documents.
- [nicemails](https://ai-powered.com/mcp/nicemails): nicemails is a freemium MCP server for communication.
- [Invoices](https://ai-powered.com/mcp/invoices): Invoices is a paid MCP server for files and documents.

---
Source: https://ai-powered.com/mcp/mcp-server-for-excel
