Airsc is free for everyone. If it helps you, support it with $2–$20.

Support
VISign in
MCP serverSafeData & analyticsSome setup

mcp-server-excel

sbroenne · sbroenne/mcp-server-excel

An MCP server allowing AI agents to automate real Microsoft Excel via natural language, supporting Power Query, DAX, VBA, PivotTables, and 300+ operations.

Automate real Microsoft Excel with AI via MCP Server or CLI — Power Query, DAX, VBA, PivotTables, charts, and 326 operations.

802 stars90License: MITUpdated 12 days ago0 opens

Preview

▍

What you can do with it

  • Have an AI agent generate complex Excel reports and charts from raw data.
  • Automate data processing tasks in Excel, including Power Query refreshes and VBA script execution, with AI.
  • Enable AI to interact with and update PivotTables or recalculate DAX formulas in existing Excel workbooks.

Safety check

Safe

No risky patterns found in the files we scanned.

Automated scan of the repo files. Always review code you run.

From the README

ExcelMcp - MCP Server for Microsoft Excel

Website · Installation · Features · Troubleshooting · 2-minute demo

Automate real Microsoft Excel with AI. Excel MCP Server lets GitHub Copilot, Claude, ChatGPT, and other agents control Excel through natural-language requests—using either MCP or a token-efficient CLI.

Unlike file-parser tools, ExcelMcp drives the actual Excel application through its official COM API. It can refresh Power Query, recalculate formulas, evaluate DAX, run VBA and Python =PY(), and preserve PivotTables, charts, macros, the Data Model, and workbook formatting.

60 MCP tools across 31 feature areas, with 388 operations, cover end-to-end Excel automation.

[!IMPORTANT] Requires Windows, Microsoft Excel 2016 or later, and an interactive desktop. It is not intended for Linux, macOS, or server-side batch processing.

🚀 Get Started

Use caseRecommended path
VS CodeInstall the extension
Claude Desktop or another MCP clientInstall the MCP Server
Coding agents and scriptsInstall the CLI
Not sure which to choose?Read the installation overview

Close open Excel workbooks before starting; ExcelMcp requires exclusive access while automating them.

What You Can Automate

  • Data & analytics: Power Query, DAX, Power Pivot, Excel Tables, PivotTables, and data connections.
  • Cells & workbooks: ranges, formulas, formatting, worksheets, files, calculation, and named ranges.
  • Charts & visuals: charts, slicers, conditional formatting, screenshots, drawings, and sparklines.
  • Automation & advanced: VBA, Python in Excel, Goal Seek, scenarios, data tables, windows, and XML Maps.

Explore the capabilities behind all 388 operations. Current command details come from CLI help or the MCP tool descriptions.

See It in Action

Ask in plain language:

  • "Import products.csv with Power Query and load it to the Data Model."
  • "Create a PivotTable showing revenue by region, then add a column chart."
  • "Use Goal Seek to find the price that produces $100,000 profit."
  • "Show me Excel while you work."

Because Excel performs the work, you can inspect results live and continue editing the workbook normally.

See more examples and use cases.

MCP Server or CLI?

Both entry points expose the same Core commands and behavior.

InterfaceBest forWhy
MCP ServerConversational assistants and exploratory workRich schemas, tool discovery, and persistent sessions
CLI (excelcli)Coding agents, automation, and scriptsOne compact tool surface and substantially lower token usage

The MCP Server calls the ExcelMcp service in-process. The CLI uses a background daemon so workbook sessions persist across commands.

AI assistant or script
        │
   MCP Server / CLI
        │
 ExcelMcp Core commands
        │
 Real Excel COM API

Read the architecture or browse the MCP Server and CLI guides.

⭐ GitHub Star History

📋 Additional Information

Documentation · Changelog · Contributing · Security · Privacy

License: MIT License - see LICENSE file

Related Projects

Other projects by the author:

View source on GitHub