Excel MCP Server

Automate Excel with AI via GitHub Copilot, Claude, and other MCP clients — including Power Query, DAX, VBA, PowerPivot, and Tables.

🤔 What is This?

Automate Excel with AI - A Model Context Protocol (MCP) server for comprehensive Excel automation through conversational AI.

VS Code / GitHub Copilot

Install Extension

Claude Desktop

One-Click Install

Cursor, Windsurf, etc.

Installation Guide

MCP Server for Excel enables AI assistants (GitHub Copilot, Claude, ChatGPT) to automate Excel through natural language commands, including Power Query & M, PowerPivot & DAX, VBA macros, PivotTables, Charts, formatting & much more – no Excel programming knowledge required.

It works with any MCP-compatible AI assistant like GitHub Copilot, Claude Desktop, Cursor, Windsurf, etc.

🛡️ 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 - Watch Excel update in real-time as AI works. Say “Show me Excel while you work” and see every change live - create a query, watch it populate, refine and repeat. Excel becomes your AI-powered workspace for rapid development and testing.

▶️ Watch the intro video (1 min)

Key Features

Power Query & M Code

Create, edit, and optimize M code. Import from files, databases, APIs. Refresh queries and manage load destinations.

Power Pivot & DAX

Build Data Models, create DAX measures, manage table relationships. Full Power Pivot automation.

PivotTables & Charts

Create PivotTables from ranges, tables, or Data Model. Build charts and PivotCharts with full formatting control.

Tables & Ranges

Read/write data, formulas, formatting. Filter, sort, validate. Manage Excel Tables with structured references.

VBA Macros

View, import, update, and execute VBA code. Export modules for version control.

Worksheets & Connections

Manage sheets, named ranges, data connections. Copy/move sheets between workbooks.

🧪 LLM-Tested Quality

Tool behavior validated with real AI agents using agent-benchmark. We test that LLMs correctly understand and use our tools.

See all 22 tools and 206 operations →

What Can You Do With It?

Ask your AI assistant to automate Excel tasks using natural language:

� Create & Populate Data

You: "Create a new Excel file with a table for tracking sales - include Date, Product, Quantity, Unit Price, and Total with sample data and formulas."

AI creates the workbook, adds headers, enters sample data, and builds formulas automatically.

📊 PivotTables & Charts

You: "Create a PivotTable showing total sales by Product, then add a bar chart to visualize the results."

AI creates the PivotTable with proper field configuration and adds a linked chart.

🔄 Power Query & Data Model

You: "Use Power Query to import products.csv, load it to the Data Model, and create measures for Total Revenue and Average Rating."

AI imports the data, adds it to Power Pivot, and creates DAX measures ready for analysis.

🎛️ Interactive Filtering

You: "Create a slicer for the Region field so I can filter the PivotTable interactively."

AI adds a slicer connected to your PivotTable for point-and-click filtering.

🎨 Formatting & Tables

You: "Format the Price column as currency, highlight values over $500 in green, and convert this to an Excel Table."

AI applies number formats, conditional formatting, and structured table styling.

CLI Tool (Optional)

For scripting, RPA workflows, and CI/CD pipelines — automate Excel without AI:

dotnet tool install -g Sbroenne.ExcelMcp.CLI

# Refresh Power Query
excel-cli pq refresh sales.xlsx --query SalesData

# Export VBA for version control  
excel-cli vba export macro-workbook.xlsm --module Module1 --output src/vba/

# Read range values
excel-cli range get-values report.xlsx --sheet Sheet1 --range A1:D10

The CLI provides 172 operations across 13 command groups, sharing the same Core engine as the MCP Server.

Documentation

📖 Complete Feature Reference — All 22 tools and 206 operations

📥 Installation Guide — Setup for VS Code, Claude Desktop, other MCP clients, and CLI

🤖 Agent Skills — Cross-platform AI guidance for Copilot, Claude Code, Cursor, Windsurf

📋 Changelog — Release notes and version history

Agent Skills

Agent Skills provide domain-specific guidance to AI coding assistants, helping them use Excel MCP Server more effectively.

Platform	Installation
GitHub Copilot	Automatic via VS Code extension
Claude Desktop	Included in MCPB bundle
Claude Code	`npx add-skill sbroenne/mcp-server-excel -a claude-code`
Cursor	`npx add-skill sbroenne/mcp-server-excel -a cursor`
Windsurf	`npx add-skill sbroenne/mcp-server-excel -a windsurf`
All Platforms	`npx add-skill sbroenne/mcp-server-excel`

Skills can also be downloaded from GitHub Releases.

More Information

GitHub Repository — Source code, issues, and contributions
Contributing Guide — How to contribute

Other projects by the author:

Windows MCP Server — AI-powered Windows automation via GitHub Copilot, Claude, and other MCP clients — including mouse, keyboard, windows, and screenshots
OBS Studio MCP Server — AI-powered OBS Studio automation for recording, streaming, and window capture
HeyGen MCP Server — MCP server for HeyGen AI video generation
RVToolsMerge — Merge and anonymize VMware RVTools exports.
Azure Retail Prices Exporter — Daily automated Azure pricing data exports with FX rates
AWS CUR Anonymize — Anonymize AWS Cost & Usage Reports for secure sharing

This site is open source. Improve this page.