About Excel MCP Server
Excel MCP Server lets AI agents create, read, and modify Excel workbooks without Microsoft Excel installed. It also handles formatting, charts, pivot tables, worksheets, and ranges.
Key features
- 01Create and edit workbooks
- 02Read and write data
- 03Format cells and styles
- 04Create charts and visualizations
- 05Generate pivot tables
- 06Manage worksheets and ranges
Use cases
- 01Edit workbook files through an AI agent
- 02Apply styles to spreadsheet data
- 03Create charts from workbook data
- 04Generate pivot tables for analysis
MCP support
It exposes Excel workbook operations as tools for MCP clients, including reading, writing, formatting, charting, and worksheet management. The server uses Server-Sent Events (SSE) transport.
Configuration
Local server config is the same for every client. Copy it into your client’s MCP config file.
We haven’t collected a package or remote endpoint for this server. Follow the instructions in the project README.
Tools
Local servers expose tools only once running on your machine, and the maintainer has not provided a tool list.
Details
From the project READMEExcel 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 TOOLS.md for complete documentation of all available tools.
License
MIT License - see LICENSE for details.
Comments
New to MCP?
From what the protocol is to installing your first server, these answers cover most first questions.
An open protocol that defines how AI applications connect to external tools and data in a uniform way. Clients talk to the model; MCP servers provide tools, resources and prompt templates. They exchange standard messages, so one server can be reused by many clients.