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

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 .

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

1. Add this 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 Protocols

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

1. Using with Claude Desktop (requires stdio):

2. Use Supergateway to convert SSE to stdio:

3. Hosting Your MCP Server:

4. Remote MCP Server Guide

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.