Haris Musa Excel MCP Server

🚀 Excel MCP Server

A Model Context Protocol (MCP) server that allows you to operate Excel files without installing Microsoft Excel. Create, read, and modify Excel workbooks using your AI agent.

✨ 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

Using 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 tool 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. Using with Claude Desktop (requires stdio):

   • Use Supergateway to convert SSE to stdio.

2. Host your MCP server:

   • Remote MCP Server Guide

🔧 Technical Details

Environment Variables

• FASTMCP_PORT: Server port (default: 8000)
• EXCEL_FILES_PATH: Excel file directory (default: ./excel_files)

Available Tools

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

📄 License

This project is under the MIT License. For more details, see LICENSE.