Leverages Python and OpenPyXL to enable Excel workbook manipulation, including worksheet management, data reading/writing, formatting, and analysis features like charts and pivot tables.
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:
Windows PowerShell:
Linux/MacOS:
Or in Claude Desktop config:
Starting the Server
Start the 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:
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.
This server cannot be installed
hybrid server
The server is able to function both locally and remotely, depending on the configuration or use case.
Provides Excel file manipulation capabilities without requiring Microsoft Excel installation, enabling workbook creation, data manipulation, formatting, and advanced Excel features.
Related Resources
Related MCP Servers
- AsecurityAlicenseAqualityProvides Excel file manipulation capabilities. This server enables workbook creation, data manipulation, formatting, and advanced Excel features.Last updated -252,456PythonMIT License
- AsecurityAlicenseAqualityProvides seamless integration with Smartsheet, enabling automated operations on Smartsheet documents through a standardized interface that bridges AI-powered automation tools with Smartsheet's collaboration platform.Last updated -11MIT License
- AsecurityAlicenseAqualityEnables seamless reading, writing, and analyzing of Excel files through Model Context Protocol, with features for worksheet management, structure analysis, and automated caching.Last updated -89941MIT License
- -securityAlicense-qualityA robust solution that enables AI agents to create, read, modify, and convert Excel files through the Model Context Protocol without requiring Microsoft Office installation.Last updated -6MIT License