# Excel MCP Server

> Excel MCP Server is an open-source MCP server for files and documents. Create, read and edit Excel workbooks with AI, including charts and PivotTables. It runs locally on your machine and is started by your AI client.

- **Kind:** MCP server
- **Pricing:** Open source
- **Platforms:** Windows, macOS, Linux, CLI, self-hosted
- **Repository:** https://github.com/haris-musa/excel-mcp-server
- **MCP Registry name:** io.github.haris-musa/excel-mcp-server
- **Categories:** [files and documents](https://ai-powered.com/categories/files-and-documents), [productivity](https://ai-powered.com/categories/productivity)
- **Listing updated:** 2026-11-18

## About

Built on openpyxl, this server edits .xlsx, .xlsm, .xltx and .xltm files directly, so Microsoft Excel does not need to be installed. Formulas are calculated by a built-in engine with 479 functions, checked against more than 25,000 formulas recorded from real Excel, which means values can be read from files that were never opened in Excel. It supports dynamic arrays such as FILTER, SORT and LET, precedent and dependent tracing, step-by-step formula evaluation and Goal Seek.

Chart support runs from column and pie to waterfall, treemap and funnel, and PivotTables are real ones that Excel can refresh, with slicers and timelines. Large sheets are read in pages, and edits on big files parse only the rows they touch. VBA in .xlsm files can be read; writing macros is off unless you start the server with --allow-vba-write, and the server never runs macros.

It runs over stdio with uvx, or as Streamable HTTP on localhost with an optional bearer token and a Docker option. Safety options include --allow-dir folder confinement, a read-only mode, a formula safety check and atomic saves that never leave half-written files.

## Features

- **Charts and PivotTables:** Many chart types, real PivotTables, slicers, timelines and sparklines.
- **Built-in formula engine:** Calculates 479 Excel functions and dynamic arrays without Excel.
- **Formula debugging:** Trace precedents and dependents, evaluate step by step and run Goal Seek.
- **Large-file handling:** Paged reads and row-limited edits keep memory flat on very large sheets.
- **Opt-in macros:** Reads VBA code; writing it requires --allow-vba-write and nothing is ever run.
- **Safety controls:** Folder confinement, read-only mode, formula checks and atomic saves.

## Good for

- Generate a chart from a data sheet
- Build a PivotTable on a large workbook
- Find why a spreadsheet number is wrong
- Clean data with sort, filter, find and replace or remove duplicates
- Format a report with conditional formatting and data validation

## Install

### Claude Code (Terminal)

```sh
claude mcp add excel-mcp-server -- uvx excel-mcp-server
```

### Claude Desktop (claude_desktop_config.json)

```json
{
  "mcpServers": {
    "excel-mcp-server": {
      "command": "uvx",
      "args": [
        "excel-mcp-server"
      ]
    }
  }
}
```

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

```json
{
  "mcpServers": {
    "excel-mcp-server": {
      "command": "uvx",
      "args": [
        "excel-mcp-server"
      ]
    }
  }
}
```

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

```json
{
  "servers": {
    "excel-mcp-server": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "excel-mcp-server"
      ]
    }
  }
}
```

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

```json
{
  "mcpServers": {
    "excel-mcp-server": {
      "command": "uvx",
      "args": [
        "excel-mcp-server"
      ]
    }
  }
}
```

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

```json
{
  "mcpServers": {
    "excel-mcp-server": {
      "command": "uvx",
      "args": [
        "excel-mcp-server"
      ]
    }
  }
}
```

## FAQ

### Do I need Microsoft Excel?

No. It works on the files directly and runs on Windows, macOS and Linux.

### Can it run macros?

No. It can read VBA, and writing VBA is opt-in, but macros are never run.

### How do I restrict which files it opens?

Use --allow-dir with one or more folders, or set EXCEL_FILES_PATH.

### How is it installed?

Run uvx excel-mcp-server stdio, or use the .mcpb bundle for Claude Desktop.

### Is there a read-only mode?

Yes, --read-only offers only tools that do not change files.

### Is Excel MCP Server free?

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

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

Run this command in your terminal: claude mcp add excel-mcp-server -- uvx excel-mcp-server

### What are the best alternatives to Excel MCP Server?

The closest alternatives to Excel MCP Server are Ha MCP, Concord MCP, note1, SSRS2 and Csv.

## Where this comes from

- Description: written from the project's README.
- Install steps: from the official MCP Registry entry.

## 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.
- [SSRS2](https://ai-powered.com/mcp/ssrs2): SSRS2 is an MCP server for files and documents.
- [Csv](https://ai-powered.com/mcp/csv): Csv is a freemium MCP server for files and documents.
- [Zovo Spreadsheet Compare](https://ai-powered.com/mcp/zovo-spreadsheet-compare): Zovo Spreadsheet Compare is an MCP server for files and documents.
- [Jira](https://ai-powered.com/mcp/jira): Jira is a freemium MCP server for productivity.
- [InviteKit Calendar Files](https://ai-powered.com/mcp/invitekit-calendar-files): InviteKit Calendar Files is an MCP server for files and documents.

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