Excel

v1.8.64Business Applicationsstable

#️⃣ 🏠 🪟 - Full-featured Excel MCP server. 173 operations: Power Query, DAX, VBA, PivotTables, Tables, Charts, ranges, formatting. 100% Excel compatibility - uses Excel app instead of creating .xlsx files. Windows only.

ai-automationclaude-aicom-automationconditional-formattingdata-connections
Share:
162
Stars
0
Downloads
0
Weekly
0/5

What is Excel?

Excel is a Model Context Protocol (MCP) server that allows AI assistants like Claude, Cursor, and VS Code to #️⃣ 🏠 🪟 - full-featured excel mcp server. 173 operations: power query, dax, vba, pivottables, tables, charts, ranges, formatting. 100% excel compatibility - uses excel app instead of creating .xlsx ...

#️⃣ 🏠 🪟 - Full-featured Excel MCP server. 173 operations: Power Query, DAX, VBA, PivotTables, Tables, Charts, ranges, formatting. 100% Excel compatibility - uses Excel app instead of creating .xlsx files. Windows only.

This server falls under the Business Applications category on MCPgee, the world's largest MCP server directory with 33,000+ servers.

Features

  • #️⃣ 🏠 🪟 - Full-featured Excel MCP server. 173 operations: Po

Use Cases

#️⃣ 🏠 🪟 - Full-featured Excel MCP server. 173 operations: Power Query, DAX, VBA,
sbroenne

Maintainer

LicenseMIT License
Languagec#
Versionv1.8.64
UpdatedMay 21, 2026
Statushealthy
Maintenanceactive

Works with

ClaudeOpenAIwindowsmacoslinux

Installation

Manual Installation

npx excel-mcp-server-uses-excel-app-100-compatibility

Configuration

Configuration Details

Config File

claude_desktop_config.json

Performance

Response Metrics

Response Time< 200ms
ThroughputMedium

Resource Usage

Memory UsageLow
CPU UsageLow

How to Set Up and Use Excel

The Excel MCP Server by sbroenne is a full-featured Windows MCP server that controls the Excel desktop application via COM automation to provide 100% Excel compatibility across 230 operations in 16 categories — including Power Query, DAX measures, VBA macros, PivotTables, Excel Tables, Charts, conditional formatting, ranges, named ranges, slicers, and more. Unlike file-based xlsx solutions, it operates on live Excel workbooks giving you real-time formula recalculation, full fidelity with complex Excel features, and the ability to share sessions between the MCP server and its companion CLI tool. It is Windows-only and requires Microsoft Excel 2016 or later.

Prerequisites

  • Windows OS (COM interop is a Windows-only requirement)
  • Microsoft Excel 2016 or later installed as a desktop application
  • .NET 10 runtime (if installing via dotnet tool)
  • An MCP-compatible client such as Claude Desktop, VS Code with Copilot, or Cursor
1

Install the MCP server

Install the Excel MCP server as a .NET global tool. This is the recommended standalone installation method for use with any MCP client.

dotnet tool install --global Sbroenne.ExcelMcp.McpServer
2

Optionally install the companion CLI

Install the Excel CLI tool which shares workbook sessions with the MCP server and uses 64% fewer tokens for simple operations.

dotnet tool install --global Sbroenne.ExcelMcp.CLI
3

Add the MCP server to your client configuration

Add the Excel MCP server to your claude_desktop_config.json using the dotnet tool entry point. The server will launch and connect to Excel via COM when first invoked.

{
  "mcpServers": {
    "excel-mcp": {
      "command": "dotnet",
      "args": ["tool", "run", "Sbroenne.ExcelMcp.McpServer"]
    }
  }
}
4

Open Excel and a workbook

Open Microsoft Excel before making your first MCP call. The server connects to the running Excel instance via COM. You can open an existing workbook or start with a blank one.

5

Enable real-time window visibility (optional)

By default, Excel may run minimized during automation. Ask the agent to show Excel while it works so you can watch changes happen live.

Excel Examples

Client configuration

Claude Desktop configuration for the Excel MCP server using the .NET global tool command.

{
  "mcpServers": {
    "excel-mcp": {
      "command": "dotnet",
      "args": ["tool", "run", "Sbroenne.ExcelMcp.McpServer"]
    }
  }
}

Prompts to try

Example prompts using the Excel MCP server's 230 operations across Power Query, PivotTables, DAX, Charts, and formatting.

- "Create a new Excel file called SalesTracker.xlsx with a table for Date, Product, Quantity, Unit Price"
- "Put this data in A1:C4: Name, Age, City / Alice, 30, Seattle / Bob, 25, Portland"
- "Create a PivotTable showing total sales by Product, then add a bar chart"
- "Use Power Query to import products.csv and create a Revenue DAX measure"
- "Format the Price column as currency and highlight values over $500 in green"
- "Show me Excel while you work on building this dashboard"

Troubleshooting Excel

Server fails to start with a COM registration error

Ensure Microsoft Excel is installed (not just the online version) and has been run at least once to complete its COM registration. Run Excel manually, accept any first-run dialogs, then restart the MCP client.

dotnet tool run fails with 'tool not found'

Run 'dotnet tool list -g' to verify Sbroenne.ExcelMcp.McpServer is listed. If not, reinstall with 'dotnet tool install --global Sbroenne.ExcelMcp.McpServer'. Also ensure the .NET tools path (~/.dotnet/tools on Windows: %USERPROFILE%\.dotnet\tools) is in your PATH.

Excel operations succeed but the workbook appears unchanged

Ask the agent to 'show Excel while you work' to make the window visible and force a screen refresh. Alternatively, switch to the Excel window manually and press F9 to force recalculation and screen update.

Frequently Asked Questions about Excel

What is Excel?

Excel is a Model Context Protocol (MCP) server that #️⃣ 🏠 🪟 - full-featured excel mcp server. 173 operations: power query, dax, vba, pivottables, tables, charts, ranges, formatting. 100% excel compatibility - uses excel app instead of creating .xlsx files. windows only. It connects AI assistants to external tools and data sources through a standardized interface.

How do I install Excel?

Follow the installation instructions on the Excel GitHub repository. Clone the repo, install dependencies, and add the server config to your AI client.

Which AI clients work with Excel?

Excel works with all major MCP-compatible AI clients including Claude Desktop, Claude Code, Cursor, VS Code (GitHub Copilot), Windsurf, and Cline.

Is Excel free to use?

Yes, Excel is open source and available under the MIT License license. You can use it freely in both personal and commercial projects.

Excel Alternatives — Similar Business Applications Servers

Looking for alternatives to Excel? Here are other popular business applications servers you can use with Claude, Cursor, and VS Code.

n8n

189.1k

A comprehensive MCP server that provides full control over n8n automation workflows through natural language. It offers 43 tools for managing workflows, executions, credentials, and data tables, with safety features like write-mode protection and dou

LobeHub

77.5k

🤯 LobeHub is your Chief Agent Operator, organizing your agents into 7×24 operations by hiring, scheduling, and reporting on your entire AI team.

Jeecgboot

46.4k

AI 低代码平台,「低代码 + 零代码」双模式驱动:低代码一键生成前后端代码,零代码 5 分钟搭建系统,AI Skills 一句话画流程、设计表单、生成整套系统。内置 AI聊天、知识库、流程编排、MCP插件等,兼容主流大模型。引领「AI 生成 → 在线配置 → 代码生成 → 手工合并->AI修改」开发模式,消除 Java 项目 80% 的重复工作,提效而不失灵活。

CowAgent

44.7k

CowAgent (chatgpt-on-wechat) 是基于大模型的超级AI助理,能主动思考和任务规划、访问操作系统和外部资源、创造和执行Skills、通过长期记忆和知识库不断成长,比OpenClaw更轻量和便捷。同时支持微信、飞书、钉钉、企微、QQ、公众号、网页等接入,可选择DeepSeek/OpenAI/Claude/Gemini/ MiniMax/Qwen/GLM/LinkAI,能处理文本、语音、图片和文件,可快速搭建个人AI助理和企业数字员工。

Minds Platform

39.2k

Platform dedicated to building an open foundation for applied Artificial Intelligence, designed for people seeking production-ready AI systems they can truly control, extend and deploy anywhere.

Astrbot

32.8k

AI Agent Assistant & development framework that integrates lots of IM platforms, LLMs, plugins and AI feature, and can be your openclaw alternative. ✨

Browse More Business Applications MCP Servers

Explore all business applications servers available in the MCPgee directory. Each server includes setup guides for Claude, Cursor, and VS Code.

Quick Config Preview

{ "mcpServers": { "excel-mcp-server-uses-excel-app-100-compatibility": { "command": "npx", "args": ["-y", "excel-mcp-server-uses-excel-app-100-compatibility"] } } }

Add this to your claude_desktop_config.json or .cursor/mcp.json

Read the full setup guide →

Ready to use Excel?

Browse our complete directory of 33,000+ MCP servers, read setup guides for your editor, and start building with the Model Context Protocol.

33,000+ ServersFree & Open SourceStep-by-Step Guides