# Excel MCP server

> Automate real Microsoft Excel on Windows: Power Query, DAX, VBA, PivotTables, charts, ranges and worksheets.

- Listing: https://mcp.tc/i/sbroenne-excel
- Connect: this is a local (stdio) server; install it on your machine (see Install). The listing link is a page, not an MCP endpoint.
- Type: local (stdio)
- Auth: no API key needed
- Category: [Productivity & Projects](https://mcp.tc/c/productivity)
- Vendor: sbroenne
- Homepage: <https://excelmcpserver.dev/>
- Repository: <https://github.com/sbroenne/mcp-server-excel>
- Package: npm `@sbroenne/mcp-server-excel`

## About

Drives the actual Microsoft Excel application through its COM API instead of parsing files. It can refresh Power Query, recalculate formulas, evaluate DAX, run VBA and Python in Excel, and work with PivotTables, charts, tables, named ranges and the Data Model while keeping workbook formatting intact.

Runs locally over stdio, installed with npx (@sbroenne/mcp-server-excel) or the NuGet package. It needs Windows, Microsoft Excel 2016 or later and an interactive desktop. Workbooks should be closed in Excel before automation starts. No API key or sign-in is documented.

## What it can do

- Read and write ranges, formulas, formatting and worksheets
- Create and refresh Power Query queries and data connections
- Evaluate DAX and manage the Power Pivot Data Model
- Build PivotTables, charts, slicers and conditional formatting
- Run VBA macros and Python in Excel
- Use Goal Seek, scenarios and data tables
- Manage Excel tables and named ranges

## Example prompts

- "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."
- "Run the VBA macro in my open budget workbook and show the results."

## Install

### Claude Code

1. Run this in a terminal, in your project folder:

```bash
claude mcp add --transport stdio sbroenne-excel -- npx -y @sbroenne/mcp-server-excel
```

2. Start Claude Code and type `/mcp`. **sbroenne-excel** should show as connected.

Add `--scope user` to make it available in every project.

### Claude Desktop

1. Open **Settings → Developer → Edit Config**. It opens `claude_desktop_config.json`. Add:

`claude_desktop_config.json`:

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

2. Save the file and restart Claude Desktop.

Needs Node.js on your computer. The file lives in `~/Library/Application Support/Claude/` on macOS and `%APPDATA%\Claude\` on Windows.

### Cursor

[Add to Cursor](<https://cursor.com/install-mcp?name=sbroenne-excel&config=eyJjb21tYW5kIjoibnB4IiwiYXJncyI6WyIteSIsIkBzYnJvZW5uZS9tY3Atc2VydmVyLWV4Y2VsIl19>) (opens Cursor)

Or add it by hand to `~/.cursor/mcp.json` (all projects) or `.cursor/mcp.json` (this project):

`mcp.json`:

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

Needs Node.js on your computer.

### VS Code

[Install in VS Code](<https://vscode.dev/redirect/mcp/install?name=sbroenne-excel&config=%7B%22type%22%3A%22stdio%22%2C%22command%22%3A%22npx%22%2C%22args%22%3A%5B%22-y%22%2C%22%40sbroenne%2Fmcp-server-excel%22%5D%7D>) (opens VS Code)

Or from a terminal:

```bash
code --add-mcp '{"name":"sbroenne-excel","type":"stdio","command":"npx","args":["-y","@sbroenne/mcp-server-excel"]}'
```

Or commit it to the repo in `.vscode/mcp.json`:

`.vscode/mcp.json`:

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

Needs Node.js on your computer.

### Devin Desktop

1. Add it to `~/.config/devin/mcp_config.json` (macOS and Linux) or `%APPDATA%\devin\mcp_config.json` (Windows):

`mcp_config.json`:

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

2. Refresh the MCP server list in Cascade.

Devin Desktop is the new name for Windsurf.

### Codex

```bash
codex mcp add sbroenne-excel -- npx -y @sbroenne/mcp-server-excel
```

Or edit `~/.codex/config.toml` directly:

`config.toml`:

```toml
[mcp_servers.sbroenne-excel]
command = "npx"
args = ["-y", "@sbroenne/mcp-server-excel"]
```

Needs Node.js on your computer.

### Gemini CLI

```bash
gemini mcp add sbroenne-excel npx -- -y @sbroenne/mcp-server-excel
```

This adds it to the current project. Add `-s user` to use it everywhere.

### Any client

Most clients that start local servers accept this shape:

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

Zed puts servers under `context_servers` in its settings, with the same `command`, `args` and `env` fields.

Needs Node.js on your computer.

## Recent changes

- 2026-11-10 08:26 UTC: New version 2.6.12 (was 2.6.11), read from npm. Source: automatic check.
- 2026-11-03 14:33 UTC: New version 2.6.11 (was 2.6.10), read from npm. Source: automatic check.
- 2026-11-02 14:26 UTC: New version 2.6.8 (was 2.6.7), read from npm. Source: automatic check.
- 2026-11-01 11:31 UTC: New version 2.6.7 (was 2.6.6), read from npm. Source: automatic check.
- 2026-10-30 14:26 UTC: New version 2.6.3 (was 2.6.1), read from npm. Source: automatic check.

More on the History tab, with descriptions before and after for the newest entries: https://mcp.tc/i/sbroenne-excel#history (Atom feed: https://mcp.tc/i/sbroenne-excel/history.xml). It records what mcp.tc's anonymous checks saw, every 3 hours where the tool list can be read without sign-in; it is not a security review.

## Details

- Server version: 2.6.12
- Last checked: 2026-10-11
- Listed: 2026-10-11
- Updated: 2026-10-11

---
Source: https://mcp.tc/i/sbroenne-excel (mcp.tc is an independent directory, not affiliated with this server's publisher). Corrections: https://mcp.tc/report
