The Excel MCP Server is a Model Context Protocol server that allows you to manipulate Excel files programmatically without requiring Microsoft Excel to be installed. With this server, you can:
Workbook Operations: Create new workbooks, retrieve metadata about workbooks including sheets and ranges
Worksheet Management: Create, copy, rename, delete, and merge worksheets
Data Manipulation: Read and write data to worksheets, apply formulas, validate formula syntax
Formatting: Apply comprehensive cell formatting (fonts, colors, borders, alignment, number formats, conditional formatting)
Range Operations: Copy, delete, or validate cell ranges
Advanced Features: Create charts (line, bar, pie, scatter), generate pivot tables, create and manage Excel tables with custom styling
Data Validation: Retrieve and manage validation rules applied to cell ranges
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
Related MCP server: Excel MCP Server
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.