Excel MCP Automation

Skill by ara.so — MCP Skills collection.

What This Does

ExcelMcp is a Model Context Protocol (MCP) server and CLI that enables AI assistants to automate Microsoft Excel through natural language. It uses Excel's native COM API (100% safe, zero file corruption risk) to control the actual Excel application on Windows.

Key Capabilities:

• 🔄 Power Query (M code, atomic workflows, load destinations)
• 📊 Data Model/DAX (measures, relationships, model structure)
• 🎨 Excel Tables (lifecycle, filtering, sorting, structured references)
• 📈 PivotTables (creation, fields, aggregations, calculated members)
• 📉 Charts (all types, series, formatting, data labels, trendlines)
• 📝 VBA (modules, execution, version control)
• 📋 Ranges (values, formulas, formatting, validation, protection)
• 🔌 Connections (OLEDB/ODBC management)
• 🎚️ Slicers (interactive filtering)
• 📸 Screenshots (capture ranges/sheets as PNG)