excel-mcp-server

Excel MCP server: let AI (Claude, Cursor, Codex) create and edit Excel files with charts, PivotTables, slicers and formulas. No Excel required.

What is excel-mcp-server?

Excel MCP server: let AI (Claude, Cursor, Codex) create and edit Excel files with charts, PivotTables, slicers and formulas. No Excel required.

Overview of excel-mcp-server

What it is

excel-mcp-server is an open-source Model Context Protocol (MCP) server that allows AI clients such as Claude, Cursor, VS Code Copilot, and Codex to create, read, and edit Excel files. It is built on openpyxl, requires no Microsoft Excel installation, and runs on Windows, macOS, and Linux. The server works with .xlsx, .xlsm, .xltx, and .xltm files.

Key features

  • Charts and PivotTables: Create column, bar, line, area, pie, doughnut, radar, scatter, bubble, waterfall, histogram, Pareto, box and whisker, treemap, sunburst, and funnel charts. Supports combo charts, secondary axes, trendlines, error bars, sparklines, and real PivotTables with slicers and timelines.
  • Formulas and dynamic arrays: A built-in formula engine calculates 479 functions without Excel. Supports dynamic arrays (FILTER, SORT, UNIQUE, SEQUENCE, LET), trace precedents/dependents, step-by-step formula evaluation, and Goal Seek.
  • Data, tables, and rules: Read/write cells, dates, hyperlinks, tables with totals rows and calculated columns. Conditional formatting (scales, data bars, icon sets, top/bottom, duplicates, text, dates), data validation (dropdowns, limits, input messages), sorting, filtering, find/replace, remove duplicates, text to columns, fill series, paste special.
  • Large file handling: Streams workbook reads to keep memory flat on sheets with hundreds of thousands of rows. Edits on large sheets parse only touched rows, making operations like sorting or creating PivotTables fast on 200,000-row sheets.
  • Macros (opt-in): Read VBA code in .xlsm files. Writing VBA is disabled by default; enable with --allow-vba-write. The server never runs macros.
  • Safe by design: Optional folder confinement, formula safety check, read-only mode, localhost-only HTTP by default, and atomic saves.

Use cases

  • AI-assisted creation of Excel workbooks with charts, PivotTables, and formulas.
  • AI-assisted editing of existing Excel files without needing Excel installed.
  • Automated data analysis and reporting through AI assistants that interact with Excel files.

Getting started

You need uv. Run the server with: uvx excel-mcp-server stdio --allow-dir /path/to/workbooks Replace /path/to/workbooks with the folder the server may use. Specific client configurations (Claude Desktop, Claude Code, Cursor, VS Code, OpenAI Codex, Gemini CLI, Devin Desktop) are provided in the repository README.

License and pricing

MIT License. Open source.

Based on the project's public README and repository metadata.

Add this badge to your README

Featured on YunoDB Badge styles & help

Maintain this project? Show that it is featured on YunoDB.

Markdown[![Featured on YunoDB](https://yunodb.com/badge/haris-musaexcel-mcp-server.svg)](https://yunodb.com/tools/haris-musaexcel-mcp-server?utm_source=github&utm_medium=badge)
HTML<a href="https://yunodb.com/tools/haris-musaexcel-mcp-server?utm_source=github&utm_medium=badge"><img src="https://yunodb.com/badge/haris-musaexcel-mcp-server.svg" alt="Featured on YunoDB" height="20"></a>