Introducing MCP Server for Excel - AI Coding for Excel
Control Microsoft Excel with AI through GitHub Copilot - just ask in natural language!
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 - no Excel programming knowledge required.
🛡️ 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.
Features
The Excel MCP Server provides 12 specialized tools with 172 operations for comprehensive Excel automation:
🔄 Power Query (9 ops) - Atomic workflows, M code management, load destinations
📊 Data Model/DAX (14 ops) - Measures, relationships, model structure
🎨 Excel Tables (24 ops) - Lifecycle, filtering, sorting, structured references
📈 PivotTables (25 ops) - Creation, fields, aggregations, data extraction
📉 Charts (14 ops) - Create, configure, manage series and formatting
📝 VBA (6 ops) - Modules, execution, version control
📋 Ranges (42 ops) - Values, formulas, formatting, validation, protection
📄 Worksheets (16 ops) - Lifecycle, colors, visibility, cross-workbook moves
🔌 Connections (9 ops) - OLEDB/ODBC management and refresh
🏷️ Named Ranges (6 ops) - Parameters and configuration
📁 Files (5 ops) - Session management and workbook creation
🎨 Conditional Formatting (2 ops) - Rules and clearing