The MCP server uses Python and the OpenPyXL library to provide Excel file manipulation capabilities without requiring Microsoft Excel installation
Excel MCP Server
A Model Context Protocol (MCP) server that lets you manipulate Excel files without needing Microsoft Excel installed. Create, read, and modify Excel workbooks with your AI agent.
Features
- 📊 Create and modify Excel workbooks
- 📝 Read and write data
- 🎨 Apply formatting and styles
- 📈 Create charts and visualizations
- 📊 Generate pivot tables
- 🔄 Manage worksheets and ranges
- 🔌 Dual transport support: stdio and SSE
Quick Start
Prerequisites
- Python 3.10 or higher
Installation
- Clone the repository:
- Install using uv:
Running the Server
The server supports two transport modes: stdio and SSE.
Using stdio transport (default)
Stdio transport is ideal for direct integration with tools like Cursor Desktop or local development, which can manipulate local files:
Using SSE transport
SSE transport is perfect for web-based applications and remote connections, which manipulate remote files:
You can specify host and port for the SSE server:
Using with AI Tools
Cursor IDE
- Add this configuration to Cursor, choosing the appropriate transport method for your needs:
Stdio transport connection (for local integration):
SSE transport connection (for web-based applications):
- The Excel tools will be available through your AI assistant.
Remote Hosting & Transport Protocols
This server supports both stdio and SSE transport protocols for maximum flexibility:
- Using with Claude Desktop:
- Use Stdio transport
- Hosting Your MCP Server (SSE):
Environment Variables (for SSE transport)
FASTMCP_PORT
: Server port for SSE transport (default: 8000)EXCEL_FILES_PATH
: Directory for Excel files (default:./excel_files
)
Available Tools
The server provides a comprehensive set of Excel manipulation tools. See TOOLS.md for complete documentation of all available tools.
License
MIT License - see LICENSE 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. This server enables workbook creation, data manipulation, formatting, and advanced Excel features.
- Features
- Quick Start
- Using with AI Tools
- Environment Variables (for SSE transport)
- Available Tools
- License
Related Resources
Related MCP Servers
- AsecurityAlicenseAqualityProvides efficient handling of large Excel files through automatic chunking and pagination, using MCP to enable seamless file reading and management features such as sheet selection and error handling.Last updated -114JavaScriptMIT 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 -821211TypeScriptMIT License
- -securityAlicense-qualityProvides Excel file manipulation capabilities without requiring Microsoft Excel installation, enabling workbook creation, data manipulation, formatting, and advanced Excel features.Last updated -PythonMIT License
- AsecurityFlicenseAqualityAn MCP server that provides comprehensive Excel file operations, data analysis, and visualization capabilities for working with various spreadsheet formats like XLSX, CSV, and JSON.Last updated -836Python