Excel MCP Server

Last reviewed: 2026-04-28

MCP Server 3.6k Stars Excel / XLSX Open Source

Best for: Full XLSX manipulation via AI — reading, writing, formatting, formulas, and chart generation through any MCP-compatible client including Claude

Not ideal for: Real-time Google Sheets collaboration or Office 365 cloud integration — this works with local .xlsx files

Why It's #1

3.6k

GitHub stars

Core Features

📖

Read Any XLSX

Read cell values, ranges, formulas, formatting, and sheet structure from any .xlsx file. Works with complex multi-sheet workbooks, named ranges, and merged cells.

✏️

Write & Format Data

Write values, apply number formats, set fonts and colors, merge cells, add borders, and adjust column widths — everything a human would do in the Excel UI, but via AI instruction.

🔢

Formula Support

Insert, read, and modify Excel formulas. Supports all standard functions — SUM, VLOOKUP, INDEX/MATCH, IF, SUMIFS, and more. Formulas remain live in the output file.

📊

Chart Generation

Create bar, line, pie, scatter, and combo charts embedded directly in the workbook. Specify data ranges, titles, axis labels, and color schemes via natural language.

🔌

Universal MCP Compatibility

Works with any MCP-compatible AI client — Claude, and any other tool that supports the Model Context Protocol. Not locked to a single AI provider.

Signals

GitHub Stars

3.6k ⭐

Category Rank

#1 Excel MCP

Protocol

MCP (standard)

Maintenance

Actively maintained

Output Format

.xlsx (native)

License

Open Source

Quality Assessment

Feature Completeness

4.5

Reliability

4.4

Ease of Use

3.9

Chart Quality

4.0

Hands-on tested: created workbook, wrote data, applied formulas, formatted cells, and embedded a bar chart — all 6 core operations succeeded. Feature set is comprehensive (20+ MCP tools). Ease of use penalized: requires Python 3.10+ (system Python 3.9 fails silently), binary installs to a non-PATH location, managed environments need --break-system-packages. Charts work but are openpyxl-level (basic Excel charts, no advanced styling).

Install & Use

# Install via pip
pip install excel-mcp-server

# Start the MCP server:
excel-mcp-server

# Add to Claude Desktop (claude_desktop_config.json):
{
  "mcpServers": {
    "excel": {
      "command": "excel-mcp-server"
    }
  }
}

# Use naturally in Claude:
# "Read the sales data from Q1_report.xlsx and summarize it"
# "Add a SUM formula to column F for rows 2-100 in my spreadsheet"
# "Create a bar chart from the revenue data in Sheet2"
# "Format all cells in row 1 as bold with navy background"
# "Add a VLOOKUP in D2 that matches against the reference table"
        