excel-mcp-server

by haris-musa
Verified

local-only server

The server can only run on the client’s local machine because it depends on local resources.

Integrations

  • The MCP server uses Python and the OpenPyXL library to provide Excel file manipulation capabilities without requiring Microsoft Excel installation

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
  1. 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" } } } }
  1. 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. 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.

-
security - not tested
A
license - permissive license
-
quality - not tested

Provides Excel file manipulation capabilities. This server enables workbook creation, data manipulation, formatting, and advanced Excel features.

  1. Features
    1. Quick Start
      1. Prerequisites
      2. Installation
      3. Running the Server
    2. Using with AI Tools
      1. Cursor IDE
      2. Remote Hosting & Transport Protocols
    3. Environment Variables
      1. Available Tools
        1. License
          ID: bnuy0j3jrt