MCP Server Excel: AI-Powered Excel Automation via COM API
This repository profile is provided by osrepos.com, an open source repository discovery platform.
Summary
MCP Server Excel is a powerful tool enabling AI assistants like GitHub Copilot and Claude to automate Microsoft Excel through natural language. It leverages the actual Excel COM API, offering 26 specialized tools and 234 operations for comprehensive automation, from Power Query to VBA macros. This project is ideal for data analysts, developers, and business users seeking to streamline complex Excel workflows with AI.
Repository Information
Topics
Click on any tag to explore related repositories
Use at your own risk
OSRepos shares public repositories for knowledge and discovery only. Any installation, execution, configuration, or use of code from these repositories is the user's own responsibility. Always review the repository, source code, dependencies, licenses, and security implications before running or installing anything. OSRepos is not responsible for issues, damages, or losses resulting from third-party repositories.
Introduction
MCP Server Excel is an innovative project that brings AI-powered automation to Microsoft Excel. It acts as a Model Context Protocol (MCP) server, allowing conversational AI assistants such as GitHub Copilot, Claude, and ChatGPT to control and automate Excel using natural language commands. Unlike file-parser tools, MCP Server Excel drives the actual Excel application through its official COM API, ensuring live operations, data model interactions, and preservation of existing workbook structures. With 26 specialized tools and 234 operations, it covers a vast array of Excel functionalities, including Power Query, DAX, PivotTables, Charts, VBA, and advanced formatting.
Installation
Getting started with MCP Server Excel is straightforward. It offers multiple installation options to suit different workflows:
- VS Code Extension: The recommended one-click installation for VS Code users, available on the VS Code Marketplace.
- Claude Desktop: Download the
.mcpbfile from the latest GitHub release. - Any MCP Client: Download
mcp-excel.exefrom the latest GitHub release and add it to your system's PATH. - GitHub Copilot Plugins: Install via the Copilot plugin marketplace for
excel-mcp(conversational AI) orexcel-cli(scripting/coding agents).
Important: MCP Server Excel requires Windows and Microsoft Excel 2016 or later. It operates the desktop Excel application, so it's not suitable for server-side processing. Ensure all Excel files are closed before use, as the server requires exclusive access.
Examples
MCP Server Excel empowers users to automate complex Excel tasks with simple natural language prompts. Here are a few examples of what you can achieve:
Create a new Excel file called SalesTracker.xlsx with a table for Date, Product, Quantity, Unit Price, and Total with sample data.
Use Power Query to import products.csv, load it to the Data Model, and create a measure for Total Revenue.
Format the Price column as currency and highlight values over $500 in green.
Run the UpdatePrices macro.
Show me Excel while you work.
Why Use
MCP Server Excel is an invaluable tool for anyone looking to enhance their Excel productivity with AI.
Perfect for:
- Data analysts automating repetitive Excel workflows.
- Developers building Excel-based data solutions.
- Business users managing complex Excel workbooks.
- Teams maintaining Power Query, VBA, or DAX code in Git.
Its key benefits include driving the real Excel engine via COM API, enabling interactive development with instant results, and offering LLM-tested quality for reliable AI interactions. The project also provides both MCP Server and CLI interfaces, catering to conversational AI and coding agents, respectively, with persistent CLI sessions and in-process MCP calls for optimal performance.
Links
For more information and to get started, explore the official resources:
- GitHub Repository: sbroenne/mcp-server-excel
- VS Code Marketplace: Excel MCP Extension
- Latest Releases: Download Executables
- Related Project: PowerPoint MCP Server
Source repository
Open the original repository on GitHub.