mcp-server-excel
starsforks
How to install mcp-server-excel?
sbroenne/mcp-server-excel
$git clone https://github.com/sbroenne/mcp-server-excelAutomate Excel with AI — A Model Context Protocol (MCP) server for comprehensive Excel automation through conversational AI.
README.md
| 1 | # ExcelMcp - MCP Server for Microsoft Excel |
| 2 | |
| 3 | [](https://marketplace.visualstudio.com/items?itemName=sbroenne.excel-mcp) |
| 4 | [](https://github.com/sbroenne/mcp-server-excel/releases) |
| 5 | |
| 6 | [](https://github.com/sbroenne/mcp-server-excel/actions/workflows/ci.yml) |
| 7 | [](https://github.com/sbroenne/mcp-server-excel/releases/latest) |
| 8 | |
| 9 | [](https://opensource.org/licenses/MIT) |
| 10 | [](https://dotnet.microsoft.com/download/dotnet/10.0) |
| 11 | [](https://github.com/sbroenne/mcp-server-excel) |
| 12 | [](https://copilot.github.com/) |
| 13 | |
| 14 | **Automate Excel with AI** — A Model Context Protocol (MCP) server for comprehensive Excel automation through conversational AI. |
| 15 | |
| 16 | **MCP Server for Excel** enables AI assistants (GitHub Copilot, Claude, ChatGPT) to automate Excel through natural language commands. Automate Power Query, DAX measures, VBA macros, PivotTables, Charts, formatting, and data transformations (26 tools with 232 operations). |
| 17 | |
| 18 | **⚡ Powered by the real Excel engine** — ExcelMcp drives the actual Excel application through its official COM API, so it does what file-parser tools can't: run live operations (refresh Power Query, recalculate, refresh PivotTables and the Data Model, evaluate DAX, run VBA and Python `=PY()`) and edit your existing workbooks with every formula, PivotTable, chart, macro and format left intact. |
| 19 | |
| 20 | **💡 Interactive Development** - See results instantly in Excel. Create a query, run it, inspect the output, refine and repeat. Excel becomes your AI-powered workspace for rapid development and testing. |
| 21 | |
| 22 | **🧪 LLM-Tested Quality** - Tool behavior validated with real LLM workflows using [pytest-skill-engineering](https://github.com/sbroenne/pytest-skill-engineering). We test that LLMs correctly understand and use our tools. |
| 23 | |
| 24 | **Technical Requirements:** |
| 25 | - ⚠️ **Windows Only** - COM interop is Windows-specific |
| 26 | - ⚠️ **Excel Required** - Microsoft Excel 2016 or later must be installed |
| 27 | - ⚠️ **Desktop Environment** - Controls actual Excel process (not for server-side processing) |
| 28 | |
| 29 | > [!TIP] |
| 30 | > **Also building PowerPoint decks?** Check out [PowerPoint MCP Server](https://powerpointmcpserver.dev/) — |
| 31 | > the sister project, built the same way. |
| 32 | |
| 33 | ## 🎯 What You Can Do |
| 34 | |
| 35 | **26 specialized tools with 232 operations:** |
| 36 | |
| 37 | - 🔄 **Power Query** (1 tool, 12 ops) - Atomic workflows, M code management, load destinations |
| 38 | - 📊 **Data Model/DAX** (2 tools, 19 ops) - Measures, relationships, model structure |
| 39 | - 🎨 **Excel Tables** (2 tools, 27 ops) - Lifecycle, filtering, sorting, structured references |
| 40 | - 📈 **PivotTables** (3 tools, 30 ops) - Creation, fields, aggregations, calculated members/fields |
| 41 | - 📉 **Charts** (2 tools, 29 ops) - Create, configure, series, formatting, data labels, trendlines |
| 42 | - 📝 **VBA** (1 tool, 6 ops) - Modules, execution, version control |
| 43 | - 📋 **Ranges** (4 tools, 46 ops) - Values, formulas, formatting, validation, protection |
| 44 | - 📄 **Worksheets** (2 tools, 16 ops) - Lifecycle, colors, visibility, cross-workbook moves |
| 45 | - 🔌 **Connections** (1 tool, 9 ops) - OLEDB/ODBC management and refresh |
| 46 | - 🏷️ **Named Ranges** (1 tool, 6 ops) - Parameters and configuration |
| 47 | - 📁 **Files** (1 tool, 6 ops) - Session management, workbook creation, IRM/AIP-protected file support |
| 48 | - 🧮 **Calculation Mode** (1 tool, 3 ops) - Get/set calculation mode and trigger recalculation |
| 49 | - 🎚️ **Slicers** (1 tool, 8 ops) - Inte |
People who liked this also viewed
6 picksType
- Scrapling🕷️ An adaptive Web Scraping framework that handles everything from a single request to a full-scale crawl!MCP ServersJul 2026
- excel-mcp-serverA Model Context Protocol server for Excel file manipulationMCP ServersApr 2026
- Excel-MCP-Server-MasterExcel MCP Server - Manipulate Excel files without Microsoft Excel. Model Context Protocol for XLSX, XLSM with Claude AI integrationMCP ServersJun 2025
- agent-deviceCLI to control iOS and Android devices for AI agentsMCP ServersJul 2026
- n8n-mcpA MCP for Claude Desktop / Claude Code / Windsurf / Cursor to build n8n workflows for you MCP ServersJul 2026
- ha-mcpThe Unofficial and Awesome Home Assistant MCP ServerMCP ServersJul 2026
