Excel MCP
Enables AI assistants to perform comprehensive Microsoft Excel operations including data analysis, cell editing, advanced formatting, and VBA execution on Windows systems. It provides a structured workflow for managing workbooks and worksheets throug
What is Excel MCP?
Excel MCP is a Model Context Protocol (MCP) server that allows AI assistants like Claude, Cursor, and VS Code to enables ai assistants to perform comprehensive microsoft excel operations including data analysis, cell editing, advanced formatting, and vba execution on windows systems. it provides a structured wor...
Enables AI assistants to perform comprehensive Microsoft Excel operations including data analysis, cell editing, advanced formatting, and VBA execution on Windows systems. It provides a structured workflow for managing workbooks and worksheets throug
This server falls under the Business Applications category on MCPgee, the world's largest MCP server directory with 33,000+ servers.
Features
- Enables AI assistants to perform comprehensive Microsoft Exc
Use Cases
Maintainer
Works with
Installation
Manual Installation
npx excel-mcp-serverConfiguration
Configuration Details
claude_desktop_config.json
Performance
Response Metrics
Resource Usage
How to Set Up and Use Excel MCP
Excel MCP Server is a Python MCP server (available on PyPI as `excel-mcp-server`) that lets AI assistants create, read, and manipulate Microsoft Excel workbooks without requiring Excel to be installed. It supports formulas, cell formatting (fonts, colors, borders, alignment), conditional formatting, chart creation (line, bar, pie, scatter, and more), pivot tables, Excel tables with custom styling, sheet management (copy, rename, delete), and data validation — all through natural language commands from any MCP-compatible client. It supports stdio for local use, streamable HTTP for remote deployment, and works on any OS that can run Python.
Prerequisites
- Python 3.10+ and uv (or pip) installed
- An MCP-compatible client such as Claude Desktop or Cursor
- No Microsoft Excel installation required — the server uses openpyxl under the hood
- For remote/HTTP deployment: set EXCEL_FILES_PATH to the directory where workbook files are stored
Verify Python and uv are installed
The recommended installation method uses uv (the fast Python package manager). Verify both are available. If uv is not installed, get it from https://docs.astral.sh/uv/.
python --version
uv --versionTest the server locally
Run the server once via uvx to confirm it downloads and starts correctly. The stdio transport is used for local MCP clients.
uvx excel-mcp-server stdioAdd to Claude Desktop
Open claude_desktop_config.json and add the excel-mcp-server entry. The `uvx` command automatically installs the package on first run.
{
"mcpServers": {
"excel": {
"command": "uvx",
"args": ["excel-mcp-server", "stdio"]
}
}
}Restart Claude Desktop
Fully quit and relaunch Claude Desktop. The Excel tools will appear in the tools panel once the server handshake completes.
Configure the files directory (optional for remote use)
For streamable HTTP transport or when you want to control where Excel files are read from and saved to, set the EXCEL_FILES_PATH environment variable.
{
"mcpServers": {
"excel": {
"command": "uvx",
"args": ["excel-mcp-server", "stdio"],
"env": {
"EXCEL_FILES_PATH": "/Users/you/Documents/excel_files"
}
}
}
}Excel MCP Examples
Client configuration
Standard Claude Desktop configuration for excel-mcp-server using stdio transport.
{
"mcpServers": {
"excel": {
"command": "uvx",
"args": ["excel-mcp-server", "stdio"]
}
}
}Prompts to try
Sample prompts for creating and manipulating Excel files through the MCP server.
- "Create a new Excel workbook called sales_report.xlsx with headers: Date, Product, Units, Revenue"
- "Add a SUM formula in cell E2 to total the values in B2:B10"
- "Create a bar chart in the current worksheet using the data in columns A and B"
- "Apply conditional formatting to highlight cells in column D that are greater than 1000 in green"
- "Create a pivot table summarizing sales by product category and month"
- "Format the header row with bold text, blue background, and white font color"Troubleshooting Excel MCP
uvx command not found
Install uv from https://docs.astral.sh/uv/getting-started/installation/ (`curl -LsSf https://astral.sh/uv/install.sh | sh` on macOS/Linux). After installation, open a new terminal so PATH is updated.
Excel file is not found or operations fail silently
By default the server looks for files in the current working directory or EXCEL_FILES_PATH. Set EXCEL_FILES_PATH in the env section of your MCP config to the exact absolute path of the directory containing your .xlsx files.
Charts or pivot tables are created but not visible when opening the file in Excel
Ensure the workbook is saved after each operation. Ask the AI to explicitly save or close the workbook. Some features like VBA macros require Microsoft Excel on Windows — for cross-platform workbooks stick to standard openpyxl-supported features.
Frequently Asked Questions about Excel MCP
What is Excel MCP?
Excel MCP is a Model Context Protocol (MCP) server that enables ai assistants to perform comprehensive microsoft excel operations including data analysis, cell editing, advanced formatting, and vba execution on windows systems. it provides a structured workflow for managing workbooks and worksheets throug It connects AI assistants to external tools and data sources through a standardized interface.
How do I install Excel MCP?
Follow the installation instructions on the Excel MCP GitHub repository. Clone the repo, install dependencies, and add the server config to your AI client.
Which AI clients work with Excel MCP?
Excel MCP works with all major MCP-compatible AI clients including Claude Desktop, Claude Code, Cursor, VS Code (GitHub Copilot), Windsurf, and Cline.
Is Excel MCP free to use?
Yes, Excel MCP is open source and available under the MIT License license. You can use it freely in both personal and commercial projects.
Excel MCP Alternatives — Similar Business Applications Servers
Looking for alternatives to Excel MCP? Here are other popular business applications servers you can use with Claude, Cursor, and VS Code.
n8n
★ 189.1kA 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.4kAI 低代码平台，「低代码 + 零代码」双模式驱动：低代码一键生成前后端代码，零代码 5 分钟搭建系统，AI Skills 一句话画流程、设计表单、生成整套系统。内置 AI聊天、知识库、流程编排、MCP插件等，兼容主流大模型。引领「AI 生成 → 在线配置 → 代码生成 → 手工合并->AI修改」开发模式，消除 Java 项目 80% 的重复工作，提效而不失灵活。
CowAgent
★ 44.7kCowAgent (chatgpt-on-wechat) 是基于大模型的超级AI助理，能主动思考和任务规划、访问操作系统和外部资源、创造和执行Skills、通过长期记忆和知识库不断成长，比OpenClaw更轻量和便捷。同时支持微信、飞书、钉钉、企微、QQ、公众号、网页等接入，可选择DeepSeek/OpenAI/Claude/Gemini/ MiniMax/Qwen/GLM/LinkAI，能处理文本、语音、图片和文件，可快速搭建个人AI助理和企业数字员工。
Minds Platform
★ 39.2kPlatform 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.8kAI 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.
Set Up Excel MCP in Your Editor
Choose your AI client for step-by-step setup instructions.
Quick Config Preview
Add this to your claude_desktop_config.json or .cursor/mcp.json
Ready to use Excel MCP?
Browse our complete directory of 33,000+ MCP servers, read setup guides for your editor, and start building with the Model Context Protocol.