excel-mcp-server MCP工具 是 AI Skill Hub 本期精选MCP工具之一。已获得 3.8k 颗 GitHub Star,综合评分 8.2 分,整体质量较高。我们强烈推荐将其纳入你的 AI 工具库,帮助提升工作效率。
基于Model Context Protocol的Excel文件操作工具,提供AI驱动的电子表格自动化能力。支持读写、数据处理、公式计算等功能。适合需要集成AI与Excel工作流的开发者和自动化专家。
excel-mcp-server MCP工具 是一款遵循 MCP(Model Context Protocol)标准协议的 AI 工具扩展。通过 MCP 协议,它可以让 Claude、Cursor 等主流 AI 客户端直接访问和操作外部工具、数据源和服务,实现 AI 能力的无缝扩展。无论是文件操作、数据库查询还是 API 调用,都可以通过自然语言在 AI 对话中直接触发,极大提升生产效率。
基于Model Context Protocol的Excel文件操作工具,提供AI驱动的电子表格自动化能力。支持读写、数据处理、公式计算等功能。适合需要集成AI与Excel工作流的开发者和自动化专家。
excel-mcp-server MCP工具 是一款遵循 MCP(Model Context Protocol)标准协议的 AI 工具扩展。通过 MCP 协议,它可以让 Claude、Cursor 等主流 AI 客户端直接访问和操作外部工具、数据源和服务,实现 AI 能力的无缝扩展。无论是文件操作、数据库查询还是 API 调用,都可以通过自然语言在 AI 对话中直接触发,极大提升生产效率。
# 方式一:通过 Claude Code CLI 一键安装
claude skill install https://github.com/haris-musa/excel-mcp-server
# 方式二:手动配置 claude_desktop_config.json
{
"mcpServers": {
"excel-mcp-server-mcp--": {
"command": "npx",
"args": ["-y", "excel-mcp-server"]
}
}
}
# 配置文件位置
# macOS: ~/Library/Application Support/Claude/claude_desktop_config.json
# Windows: %APPDATA%/Claude/claude_desktop_config.json
# 安装后在 Claude 对话中直接使用 # 示例: 用户: 请帮我用 excel-mcp-server MCP工具 执行以下任务... Claude: [自动调用 excel-mcp-server MCP工具 MCP 工具处理请求] # 查看可用工具列表 # 在 Claude 中输入:"列出所有可用的 MCP 工具"
// claude_desktop_config.json 配置示例
{
"mcpServers": {
"excel-mcp-server_mcp__": {
"command": "npx",
"args": ["-y", "excel-mcp-server"],
"env": {
// "API_KEY": "your-api-key-here"
}
}
}
}
// 保存后重启 Claude Desktop 生效
<p align="center"> <picture> <source media="(prefers-color-scheme: dark)" srcset="https://raw.githubusercontent.com/haris-musa/excel-mcp-server/main/assets/logo-dark.png"> <img src="https://raw.githubusercontent.com/haris-musa/excel-mcp-server/main/assets/logo.png" alt="Excel MCP Server" width="420"> </picture> </p>
<p align="center"> <a href="https://pypi.org/project/excel-mcp-server/"><img src="https://img.shields.io/pypi/v/excel-mcp-server.svg" alt="PyPI version"></a> <a href="https://pypi.org/project/excel-mcp-server/"><img src="https://img.shields.io/pypi/pyversions/excel-mcp-server.svg" alt="Python versions"></a> <a href="https://pepy.tech/project/excel-mcp-server"><img src="https://static.pepy.tech/badge/excel-mcp-server" alt="Downloads"></a> <a href="https://github.com/haris-musa/excel-mcp-server/actions/workflows/ci.yml"><img src="https://github.com/haris-musa/excel-mcp-server/actions/workflows/ci.yml/badge.svg" alt="CI"></a> <a href="LICENSE"><img src="https://img.shields.io/badge/License-MIT-yellow.svg" alt="License: MIT"></a> </p>
<p align="center"> <a href="https://trendshift.io/repositories/13975" target="_blank" rel="noopener noreferrer"><img src="https://trendshift.io/api/badge/repositories/13975" alt="haris-musa%2Fexcel-mcp-server | Trendshift" width="250" height="55"/></a> </p>
Charts and PivotTables - Create Excel charts with AI: column, bar, line, area, pie, doughnut, radar, scatter and bubble, with combos, secondary axes, trendlines and error bars - The Excel 2016 chart types: waterfall, histogram, Pareto, box and whisker, treemap, sunburst and funnel - Real PivotTables that Excel refreshes (grouping, calculated fields, "show values as", layouts, filters), plus slicers and timelines for PivotTables and tables - Sparklines (line, column, win/loss)
Formulas and dynamic arrays - Formulas are calculated without Excel by a built-in engine (about 260 functions, checked against more than 2,500 formulas recorded from real Excel), so read_range returns values for files that were never opened in Excel - Dynamic arrays (FILTER, SORT, UNIQUE, SEQUENCE, LET) are stored as Excel stores them and spill into the cells next to them
Data, tables and rules - Read and write cells, dates and hyperlinks; tables with totals rows and calculated columns - Conditional formatting (scales, data bars, icon sets, top/bottom, duplicates, text, dates), data validation (dropdowns, limits, input messages) - Sort, filter (with criteria), find and replace, remove duplicates, text to columns, fill series, paste special - Fonts, fills, borders, number formats, merged cells, frozen panes, grouping, print setup, sheet protection, images, notes and defined names. Inserting or deleting rows and columns updates every reference, as in Excel
Large files - Reads stream the workbook and return pages, so memory stays flat on sheets with hundreds of thousands of rows; every call is bounded by size and cell limits
Macros (opt-in) - Read the VBA code in .xlsm files. Writing VBA is off unless you start the server with --allow-vba-write; the server never runs macros
Safe by design - Optional folder confinement, a formula safety check, read-only mode, localhost-only HTTP by default, and atomic saves that never leave a half-written file
Works with .xlsx, .xlsm (macros are preserved), .xltx and .xltm files. Existing threaded comments, shapes, form controls and other content the tools cannot edit are kept as they are.
docker build -t excel-mcp-server .
docker run -p 8017:8017 -v "$PWD/workbooks:/data" -e EXCEL_MCP_AUTH_TOKEN=change-me excel-mcp-server
You need uv. Every client runs the server with uvx excel-mcp-server stdio; replace /path/to/workbooks with the folder the server may use. excelmcpserver.com has the same steps with copy buttons and one-click install links for Cursor and VS Code.
Claude Desktop (Chat): download excel-mcp-server.mcpb from the latest release and open it. Claude asks which folder the server may use.
Claude Code (the CLI, and the Code tab in Claude Desktop):
claude mcp add excel --scope user -- uvx excel-mcp-server stdio --allow-dir /path/to/workbooks
Cursor (~/.cursor/mcp.json), and most clients that use an mcpServers config:
{
"mcpServers": {
"excel": {
"command": "uvx",
"args": ["excel-mcp-server", "stdio", "--allow-dir", "/path/to/workbooks"]
}
}
}
VS Code with GitHub Copilot (.vscode/mcp.json, note the servers key):
{
"servers": {
"excel": {
"type": "stdio",
"command": "uvx",
"args": ["excel-mcp-server", "stdio", "--allow-dir", "${workspaceFolder}"]
}
}
}
<details> <summary>OpenAI Codex, Gemini CLI, Devin Desktop, and Claude Desktop without the bundle</summary>
OpenAI Codex (CLI, IDE extension and app):
codex mcp add excel -- uvx excel-mcp-server stdio --allow-dir /path/to/workbooks
Gemini CLI:
gemini mcp add -s user excel uvx excel-mcp-server stdio --allow-dir /path/to/workbooks
Devin Desktop:
devin mcp add -s user excel -- uvx excel-mcp-server stdio --allow-dir /path/to/workbooks
Claude Desktop, manual setup: open Settings, Developer, Edit Config, add the mcpServers JSON above to claude_desktop_config.json, and restart Claude.
</details>
Desktop apps often cannot find uvx, because they do not see your shell's PATH (common on macOS). Use its full path instead, which which uvx prints.
| Flag | Environment variable | Default | Meaning |
|---|---|---|---|
--allow-dir DIR | EXCEL_FILES_PATH | none (stdio), ./excel_files (HTTP) | Folders workbooks must be in |
--read-only | EXCEL_MCP_READ_ONLY=1 | off | Only offer tools that do not change files |
--allow-vba-write | EXCEL_MCP_ALLOW_VBA_WRITE=1 | off | Add tools that write VBA macros (see warning below); ignored with --read-only |
--max-file-mb N | 100 | Largest workbook the server opens. Also sets the unpacked-size limit (10 times this) that every opened or uploaded workbook must stay under; parts compressed over 500:1 are refused | |
--log-level LEVEL | WARNING | Logging on stderr | |
--host HOST | EXCEL_MCP_HOST | 127.0.0.1 | HTTP listen address |
--port PORT | EXCEL_MCP_PORT | 8017 | HTTP port |
EXCEL_MCP_AUTH_TOKEN | none | Bearer token required on HTTP requests | |
--allow-unauthenticated | off | Allow a non-local --host without a token |
高质量MCP实现,填补AI-Excel集成空白。代码活跃,star数证实实用价值。适配度好,生产就绪度高。
AI Skill Hub 为第三方内容聚合平台,本页面信息基于公开数据整理,不对工具功能和质量作任何法律背书。
建议在沙箱或测试环境中充分验证后,再部署至生产环境,并做好必要的安全评估。
✅ MIT 协议 — 最宽松的开源协议之一,可自由商用、修改、分发,仅需保留版权声明。
经综合评估,excel-mcp-server MCP工具 在MCP工具赛道中表现稳健,质量优秀。如果你已有明确的使用需求,可以直接上手体验;如果还在评估阶段,建议对比同类工具后再做决策。
| 原始名称 | excel-mcp-server |
| 原始描述 | 开源MCP工具:A Model Context Protocol server for Excel file manipulation。⭐3.8k · Python |
| Topics | Excel自动化MCP服务数据处理AI集成Python |
| GitHub | https://github.com/haris-musa/excel-mcp-server |
| License | MIT |
| 语言 | Python |
收录时间:2026-05-14 · 更新时间:2026-05-16 · License:MIT · AI Skill Hub 不对第三方内容的准确性作法律背书。
选择 Agent 类型,复制安装指令后粘贴到对应客户端