haris-musa_excel-mcp-server
Excel MCP Server is a protocol server designed for manipulating Excel files without the need for Microsoft Excel. It supports various operations such as data reading, writing, formatting, and visualization, enhancing AI tool integration.
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
Quick Start
Prerequisites
- Python 3.10 or higher
Installation
- Clone the repository:
git clone https://github.com/haris-musa/excel-mcp-server.git
cd excel-mcp-server
- Install using uv:
uv pip install -e .
Running the Server
Start the server (default port 8000):
uv run excel-mcp-server
Custom port (e.g., 8080):
# Bash/Linux/macOS
export FASTMCP_PORT=8080 && uv run excel-mcp-server
# Windows PowerShell
$env:FASTMCP_PORT = "8080"; uv run excel-mcp-server
Using with AI Tools
Cursor IDE
- Add this configuration to Cursor:
{
"mcpServers": {
"excel": {
"url": "http://localhost:8000/sse",
"env": {
"EXCEL_FILES_PATH": "/path/to/excel/files"
}
}
}
}
- The Excel tools will be available through your AI assistant.
Remote Hosting & Transport Protocols
This server uses Server-Sent Events (SSE) transport protocol. For different use cases:
-
Using with Claude Desktop (requires stdio):
- Use Supergateway to convert SSE to stdio:
-
Hosting Your MCP Server:
Environment Variables
FASTMCP_PORT
: Server port (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 for complete documentation of all available tools.
License
MIT License - see for details.