Excel (by haris-musa)
FreeExcel 操作，包括读写、工作表管理、格式化、图表和数据透视表 (提供更高级的功能)。
FreeFree tier
About Excel (by haris-musa)
excel-mcp-server is a Model Context Protocol (MCP) server that enables AI agents to create, read, and modify Excel files without requiring Microsoft Excel to be installed. It supports full workbook and worksheet management, data manipulation with formulas, conditional formatting, charts (line, bar, pie, scatter, etc.), pivot tables, and Excel tables. The server includes built-in data validation, sheet management (copy, rename, delete), and table operations with custom styling. It offers three transport protocols: stdio for local use, SSE (deprecated), and streamable HTTP for remote connections, making it suitable for both local and cloud-based AI workflows.
Key Features
Create, read, and update workbooks and worksheets
Formulas, formatting, charts, pivot tables, and Excel tables
Data validation with range, formula, and integrity checks
Font styling, colors, borders, alignment, and conditional formatting
Create and manage Excel tables with custom styling
Generate various chart types (line, bar, pie, scatter, etc.)
Create dynamic pivot tables for data analysis
Copy, rename, and delete worksheets
Supports stdio, SSE (deprecated), and streamable HTTP transports
Works both locally and as a remote service
Pros & Cons
Pros
- No need to install Microsoft Excel
- Open source and free under MIT license
- Comprehensive feature set including charts and pivot tables
- Flexible transport options for local and remote use
- Built-in data validation and integrity checks
Cons
- SSE transport is deprecated and not recommended for new projects
- Requires Python 3.x and uvx for execution
- Remote use requires setting environment variables (EXCEL_FILES_PATH, FASTMCP_PORT)
- Currently only supports .xlsx file format (implied by features)
Best For
Automating Excel report generation with AI agentsData analysis and manipulation via natural languageIntegrating Excel operations into MCP-compatible applicationsRemote Excel file management through streamable HTTPCreating and updating spreadsheets in CI/CD pipelines
FAQ
What is excel-mcp-server?
A Model Context Protocol (MCP) server that allows AI agents to create, read, and modify Excel files without needing Microsoft Excel installed.
Do I need Microsoft Excel installed?
No, the server works independently and does not require Microsoft Excel or any other spreadsheet application.
What transport protocols are supported?
The server supports stdio, SSE (deprecated), and streamable HTTP transports. Streamable HTTP is recommended for remote connections.
How do I use it remotely?
Set the EXCEL_FILES_PATH environment variable on the server side to specify the directory for reading and writing Excel files, then start the server with streamable HTTP transport.
Is this tool free?
Yes, it is open source and released under the MIT license.