ExcelMcp - MCP Server for Microsoft Excel
Automate Excel with AI — A Model Context Protocol (MCP) server for comprehensive Excel automation through conversational AI.
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 (25 tools with 230 operations).
🛡️ 100% Safe - Uses Excel's Native COM API - Zero risk of file corruption. Unlike third-party libraries that manipulate .xlsx files directly, this project uses Excel's official API ensuring complete safety and compatibility.
💡 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.
🧪 LLM-Tested Quality - Tool behavior validated with real LLM workflows using pytest-skill-engineering. We test that LLMs correctly understand and use our tools.
Technical Requirements:
- ⚠️ Windows Only - COM interop is Windows-specific
- ⚠️ Excel Required - Microsoft Excel 2016 or later must be installed
- ⚠️ Desktop Environment - Controls actual Excel process (not for server-side processing)
🎯 What You Can Do
25 specialized tools with 230 operations:
- 🔄 Power Query (1 tool, 12 ops) - Atomic workflows, M code management, load destinations
- 📊 Data Model/DAX (2 tools, 19 ops) - Measures with auto-formatted DAX, relationships, model structure
- 🎨 Excel Tables (2 tools, 27 ops) - Lifecycle, filtering, sorting, structured references
- 📈 PivotTables (3 tools, 30 ops) - Creation, fields, aggregations, calculated members/fields
- 📉 Charts (2 tools, 29 ops) - Create, configure, series, formatting, data labels, trendlines
- 📝 VBA (1 tool, 6 ops) - Modules, execution, version control
- 📋 Ranges (4 tools, 46 ops) - Values, formulas, formatting, validation, protection
- 📄 Worksheets (2 tools, 16 ops) - Lifecycle, colors, visibility, cross-workbook moves
- 🔌 Connections (1 tool, 9 ops) - OLEDB/ODBC management and refresh
- 🏷️ Named Ranges (1 tool, 6 ops) - Parameters and configuration
- 📁 Files (1 tool, 6 ops) - Session management, workbook creation, IRM/AIP-protected file support
- 🧮 Calculation Mode (1 tool, 3 ops) - Get/set calculation mode and trigger recalculation
- 🎚️ Slicers (1 tool, 8 ops) - Interactive filtering for PivotTables and Tables
- 🎨 Conditional Formatting (1 tool, 2 ops) - Rules and clearing
- 📸 Screenshot (1 tool, 2 ops) - Capture ranges/sheets as PNG for LLM visual verification
- 🪧 Window Management (1 tool, 9 ops) - Show/hide Excel, arrange, position, status bar feedback
📚 Complete Feature Reference → - Detailed documentation of all 230 operations
💬 Example Prompts
Create & Populate Data:
- "Create a new Excel file called SalesTracker.xlsx with a table for Date, Product, Quantity, Unit Price, and Total with sample data"
- "Put this data in A1:C4 - Name, Age, City / Alice, 30, Seattle / Bob, 25, Portland"
- "Add a formula column that calculates Quantity times Unit Price"