Excel MCP Server K5w

🚀 Excel MCP Server

An Excel Model Context Protocol (MCP) server that allows you to manipulate Excel files without installing Microsoft Excel. Create, read, and modify Excel workbooks for use with your AI agents.

✨ Features

• 📊 Create and modify Excel workbooks
• 📝 Read and write data
• 🎨 Apply formats and styles
• 📈 Create charts and visualizations
• 📊 Generate pivot tables
• 🔄 Manage worksheets and ranges

🚀 Quick Start

Prerequisites

• Python 3.10 or higher

Installation

1. Clone the repository:

git clone https://github.com/haris-musa/excel-mcp-server.git
cd excel-mcp-server

2. Install using uv:

uv pip install -e .

Run the Server

Start the server (default port 8000):

uv run excel-mcp-server

Customize the 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

💻 Usage Examples

Use with AI Tools

Cursor IDE

1. Add the following configuration to Cursor:

{
  "mcpServers": {
    "excel": {
      "url": "http://localhost:8000/sse",
      "env": {
        "EXCEL_FILES_PATH": "/path/to/excel/files"
      }
    }
  }
}

2. The Excel tools will be available through your AI assistant.

Remote Hosting & Transport Protocol

This server uses the Server-Sent Events (SSE) transport protocol. For different use cases:

1. Use with Claude Desktop (requires stdio):

   • Use Supergateway to convert SSE to stdio.

2. Host your MCP server:

   • Refer to Remote MCP Server Guide.

🔧 Technical Details

Environment Variables

📚 Documentation

The server provides comprehensive Excel operation tools. For the full documentation of all available tools, see TOOLS.md.

📄 License

This project is under the MIT License - see LICENSE for details.