Excel MCP Server
Excel MCP Server - Manipulate Excel files without Microsoft Excel. Model Context Protocol for XLSX, XLSM with Claude AI integration
What is Excel MCP Server?
Excel MCP Server is a Model Context Protocol (MCP) server that allows AI assistants like Claude, Cursor, and VS Code to excel mcp server - manipulate excel files without microsoft excel. model context protocol for xlsx, xlsm with claude ai integration
Excel MCP Server - Manipulate Excel files without Microsoft Excel. Model Context Protocol for XLSX, XLSM with Claude AI integration
This server falls under the Data Science & ML category on MCPgee, the world's largest MCP server directory with 33,000+ servers.
Features
- Excel MCP Server - Manipulate Excel files without Microsoft
Use Cases
Maintainer
Works with
Installation
Manual Installation
npx excel-mcp-server-masterConfiguration
Configuration Details
claude_desktop_config.json
Performance
Response Metrics
Resource Usage
How to Set Up and Use Excel MCP Server
Excel MCP Server Master is a Python-based MCP server that enables full manipulation of Excel XLSX and XLSM files without requiring Microsoft Excel to be installed. It exposes tools for creating and editing workbooks, reading and writing data, applying formatting and formulas, generating charts and pivot tables, and importing/exporting CSV and JSON — all accessible to Claude and other MCP-compatible AI assistants. This makes it ideal for automating spreadsheet workflows, generating reports, and processing data entirely through natural language.
Prerequisites
- Node.js 14.0+ (for npx invocation)
- Python 3.8+ installed and available in your PATH (Python dependencies install automatically on first run)
- An MCP-compatible client such as Claude Desktop
- Windows, macOS, or Linux operating system
Verify Python and Node.js are installed
The server requires both Node.js (to run via npx) and Python 3.8+ (for the underlying Excel processing library). Check both are available.
node --version
python3 --versionTest the server runs standalone
Run the server once via npx to confirm it starts correctly and Python dependencies are installed automatically.
npx @guillehr2/excel-mcp-server@latestAdd the server to your MCP client config
Edit your claude_desktop_config.json to register the Excel MCP server. No environment variables are required for basic usage.
{
"mcpServers": {
"excel-master": {
"command": "npx",
"args": ["-y", "@guillehr2/excel-mcp-server@latest"]
}
}
}Restart your MCP client
Fully restart Claude Desktop after editing the config file so the new server is loaded.
Test with a simple Excel task
Ask Claude to create or read an Excel file to verify the server is connected and working correctly.
Excel MCP Server Examples
Client configuration
Add this to your claude_desktop_config.json to enable Excel file manipulation through Claude.
{
"mcpServers": {
"excel-master": {
"command": "npx",
"args": ["-y", "@guillehr2/excel-mcp-server@latest"]
}
}
}Prompts to try
Example prompts to use once the server is connected in Claude Desktop.
- "Create an Excel file called sales_report.xlsx with a table of Q4 sales data by region"
- "Read the data from my file budget.xlsx and summarize the totals"
- "Add a line chart to revenue.xlsx showing monthly trends"
- "Create a pivot table in data.xlsx grouping by category and summing sales"
- "Format the header row in report.xlsx with a blue background and bold white text"Troubleshooting Excel MCP Server
Python dependencies fail to install on first run
Make sure Python 3.8+ is installed and 'python3' is in your PATH. On Windows, ensure Python was added to the system PATH during installation. Run 'python3 -m pip install openpyxl' manually if auto-install fails.
Server not found or npx command fails
Ensure Node.js 14+ is installed. Try running 'npx @guillehr2/excel-mcp-server@latest' in a terminal to see the raw error. You can also install globally with 'npm install -g @guillehr2/excel-mcp-server' as an alternative.
Cannot open or write XLSM files
XLSM files (macro-enabled workbooks) are supported for reading and data editing, but macros are not executed. If you need to preserve macro content, work with a copy of the file and verify the output format.
Frequently Asked Questions about Excel MCP Server
What is Excel MCP Server?
Excel MCP Server is a Model Context Protocol (MCP) server that excel mcp server - manipulate excel files without microsoft excel. model context protocol for xlsx, xlsm with claude ai integration It connects AI assistants to external tools and data sources through a standardized interface.
How do I install Excel MCP Server?
Follow the installation instructions on the Excel MCP Server GitHub repository. Clone the repo, install dependencies, and add the server config to your AI client.
Which AI clients work with Excel MCP Server?
Excel MCP Server works with all major MCP-compatible AI clients including Claude Desktop, Claude Code, Cursor, VS Code (GitHub Copilot), Windsurf, and Cline.
Is Excel MCP Server free to use?
Yes, Excel MCP Server is open source and available under the MIT license. You can use it freely in both personal and commercial projects.
Excel MCP Server Alternatives — Similar Data Science & ML Servers
Looking for alternatives to Excel MCP Server? Here are other popular data science & ml servers you can use with Claude, Cursor, and VS Code.
Ultrarag
★ 5.6kA Low-Code MCP Framework for Building Complex and Innovative RAG Pipelines
RocketRide
★ 3.1k📇 🏠 - MCP server that exposes RocketRide AI pipelines as t
Aix Db
★ 2.1kAix-DB 基于 LangChain/LangGraph 框架，结合 MCP Skills 多智能体协作架构，实现自然语言到数据洞察的端到端转换。
NeMo Data Designer
★ 1.9k🎨 NeMo Data Designer: Generate high-quality synthetic data from scratch or from seed data.
PaperBanana
★ 1.7kOpen source implementation and extension of Google Research’s PaperBanana for automated academic figures, diagrams, and research visuals, expanded to new domains like slide generation.
MiniMax
★ 1.5kBridges MiniMax AI capabilities to the Model Context Protocol, enabling AI agents to perform image understanding, text-to-image generation, and speech synthesis. It provides a standardized interface for accessing MiniMax's core tools via JSON-RPC.
Browse More Data Science & ML MCP Servers
Explore all data science & ml servers available in the MCPgee directory. Each server includes setup guides for Claude, Cursor, and VS Code.
Set Up Excel MCP Server in Your Editor
Choose your AI client for step-by-step setup instructions.
Quick Config Preview
Add this to your claude_desktop_config.json or .cursor/mcp.json
Ready to use Excel MCP Server?
Browse our complete directory of 33,000+ MCP servers, read setup guides for your editor, and start building with the Model Context Protocol.