Excel MCP Server
A Model Context Protocol (MCP) server implementation that provides Excel file manipulation capabilities without requiring Microsoft Excel installation. This server enables workbook creation, data manipulation, formatting, and advanced Excel features.
Requirements
- Python 3.10+
- MCP SDK 1.2.0+
- OpenPyXL 3.1.2+
Components
Resources
The server provides Excel workbook manipulation through OpenPyXL:
- Creates and modifies Excel workbooks
- Manages worksheets and ranges
- Handles formatting and styles
- Supports charts and pivot tables
Tools
This server provides a comprehensive set of Excel manipulation tools. For detailed documentation of all available tools, their parameters, and usage examples, please refer to TOOLS.md.
The tools include capabilities for:
- Workbook and worksheet management
- Data reading and writing
- Formatting and styling
- Charts and visualizations
- Pivot tables and data analysis
See TOOLS.md for complete documentation.
Features
- Full Excel Support: Comprehensive Excel functionality
- Data Manipulation: Read, write, and transform data
- Advanced Features: Charts, pivot tables, and formatting
- Error Handling: Comprehensive error handling with clear messages
Usage
Environment Configuration
The server can be configured using the following environment variables:
EXCEL_FILES_PATH: Directory where Excel files will be stored (default:./excel_files)
You can set this in different ways:
Windows CMD:
set EXCEL_FILES_PATH=C:\path\to\excel\files
uv run excel-mcp-server
Windows PowerShell:
$env:EXCEL_FILES_PATH="C:\path\to\excel\files"
uv run excel-mcp-server
Linux/MacOS:
export EXCEL_FILES_PATH=/path/to/excel/files
uv run excel-mcp-server
Or in Claude Desktop config:
{
"mcpServers": {
"excel": {
"command": "uv run excel-mcp-server",
"transport": "sse",
"env": {
"EXCEL_FILES_PATH": "/path/to/excel/files"
}
}
}
}
Starting the Server
Start the server:
uv run excel-mcp-server
The server will start in SSE mode and wait for connections from MCP clients.
Connecting in Cursor IDE
After starting the server, connect to the SSE endpoint in Cursor IDE:
http://localhost:8000/sse
The Excel MCP tools will be available through the agent.
For available tools and their usage, please refer to TOOLS.md.
License
This project is licensed under the MIT License - see the LICENSE file for details.
Metadata
Release files for iflow-mcp_fish0710_excel-mcp-server 0.1.0
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | Provenance | Actions |
|---|---|---|---|---|
| iflow_mcp_fish0710_excel_mcp_server-0.1.0.tar.gz | 41.3 kB | Without provenance | Details for iflow_mcp_fish0710_excel_mcp_server-0.1.0.tar.gz |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Actions Reset |
|---|---|---|---|---|
| iflow_mcp_fish0710_excel_mcp_server-0.1.0-py3-none-any.whl | Python 3 | none | any | Details for iflow_mcp_fish0710_excel_mcp_server-0.1.0-py3-none-any.whl |
Total release size: 67.7 kB
Release files / iflow_mcp_fish0710_excel_mcp_server-0.1.0.tar.gz
| Download URL | iflow_mcp_fish0710_excel_mcp_server-0.1.0.tar.gz |
|---|---|
| Size | 41.3 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
b9c5c4ad98eda5cd47f77232fe3a9f0777c7a9c667607bdf80239b924b537261
|
|
BLAKE2b-256 checksum How to use checksums |
123e224cc6e3edb762d68a2d175423b9235a9930e20acd6d75c70fb7a62650fd
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
uv/0.9.28 {"installer":{"name":"uv","version":"0.9.28","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":{"name":"Debian GNU/Linux","version":"13","id":"trixie","libc":null},"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":null}
|
Release files / iflow_mcp_fish0710_excel_mcp_server-0.1.0-py3-none-any.whl
| Download URL | iflow_mcp_fish0710_excel_mcp_server-0.1.0-py3-none-any.whl |
|---|---|
| Size | 26.4 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
942d8e7359c5c33b9e12d7a3dfbe3d117bb134a9873a477e2dfc78e333837c34
|
|
BLAKE2b-256 checksum How to use checksums |
14315357fa7e72a8cd67e532ce8c6b52cd59e2d05978f2c4bce428f9c1d4cb2f
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
uv/0.9.28 {"installer":{"name":"uv","version":"0.9.28","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":{"name":"Debian GNU/Linux","version":"13","id":"trixie","libc":null},"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":null}
|
Security for iflow-mcp_fish0710_excel-mcp-server 0.1.0
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
No provenance found
None of the files in this release were uploaded with provenance metadata.
A note on package security
PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.
To learn more about protecting yourself from malicious actors, visit our package security documentation.