Sbroenne.ExcelMcp.McpServer 1.4.33

ExcelMcp - Model Context Protocol Server for Excel

mcp-name: io.github.sbroenne/mcp-server-excel

Control Excel with Natural Language through AI assistants like GitHub Copilot, Claude, and ChatGPT. This MCP server enables AI-powered Excel automation for Power Query, DAX measures, VBA macros, PivotTables, Charts, and more.

➡️ Learn more and see examples

🛡️ 100% Safe - Uses Excel's Native COM API

Unlike third-party libraries that manipulate .xlsx files (risking corruption), ExcelMcp uses Excel's official COM automation API. This guarantees zero risk of file corruption while you work interactively with live Excel files - see your changes happen in real-time.

Optional CLI Tool: For advanced users who prefer command-line scripting, ExcelMcp includes a CLI interface for RPA workflows, CI/CD pipelines, and batch automation. Both interfaces share the same 172 operations.

Requirements: Windows OS + Excel 2016+

🚀 Installation

Quick Setup Options:

1. VS Code Extension - One-click install for GitHub Copilot
2. Manual Install - Works with Claude Desktop, Cursor, Cline, Windsurf, and other MCP clients
3. MCP Registry - Find us at registry.modelcontextprotocol.io

Manual Installation (All MCP Clients):

# Install MCP Server
dotnet tool install --global Sbroenne.ExcelMcp.McpServer

# Configure your AI assistant
# See examples/mcp-configs/ for ready-to-use configs

Supported AI Assistants:

• ✅ GitHub Copilot (VS Code, Visual Studio)
• ✅ Claude Desktop
• ✅ Cursor
• ✅ Cline (VS Code Extension)
• ✅ Windsurf
• ✅ Any MCP-compatible client

📖 Detailed setup instructions: Installation Guide

🎯 Quick config examples: examples/mcp-configs/

🛠️ What You Can Do

12 specialized tools with 172 operations:

• 🔄 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

📚 Complete Feature Reference → - Detailed documentation of all 172 operations

AI-Powered Workflows:

• 💬 Natural language Excel commands through GitHub Copilot, Claude, or ChatGPT
• 🔄 Optimize Power Query M code for performance and readability
• 📊 Build complex DAX measures with AI guidance
• 📋 Automate repetitive data transformations and formatting
• 👀 Show Excel Mode - Say "Show me Excel while you work" to watch changes live

💡 Example Use Cases

"Optimize all my Power Queries in this workbook"
→ AI analyzes M code, optimizes query folding, improves step organization

"Create a PivotTable showing sales by region and product"
→ AI creates PivotTable, adds fields, sets aggregations, applies formatting

"Format revenue columns as currency with bold headers and blue background"
→ AI applies number formatting, font styles, and cell colors

"Build a DAX measure for year-over-year growth"
→ AI writes DAX formula, sets currency format, adds to Data Model

"Export all Power Query M code to Git for version control"
→ CLI batch exports all queries to .pq files for source control workflows

📋 Additional Resources

• GitHub Repository - Source code, issues, discussions
• Installation Guide - Detailed setup for all platforms
• VS Code Extension - One-click installation
• CLI Documentation - Comprehensive commands for RPA and CI/CD automation

License: MIT
Platform: Windows only (requires Excel 2016+)
Support: GitHub Issues