excel-mcp-server

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

hybrid server

The server is able to function both locally and remotely, depending on the configuration or use case.

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

          Related MCP Servers

          • A
            security
            A
            license
            A
            quality
            Provides efficient handling of large Excel files through automatic chunking and pagination, using MCP to enable seamless file reading and management features such as sheet selection and error handling.
            Last updated -
            1
            14
            JavaScript
            MIT License
          • A
            security
            A
            license
            A
            quality
            Enables seamless reading, writing, and analyzing of Excel files through Model Context Protocol, with features for worksheet management, structure analysis, and automated caching.
            Last updated -
            8
            212
            11
            TypeScript
            MIT License
            • Linux
            • Apple
          • -
            security
            A
            license
            -
            quality
            Provides Excel file manipulation capabilities without requiring Microsoft Excel installation, enabling workbook creation, data manipulation, formatting, and advanced Excel features.
            Last updated -
            Python
            MIT License
            • Linux
            • Apple
          • -
            security
            A
            license
            -
            quality
            A thin wrapper around the OpenPyXl Python library that exposes Excel file operations as a Model Context Protocol (MCP) server, allowing Claude and other MCP clients to fetch and analyze data from Excel files.
            Last updated -
            9
            Python
            MIT License
            • Apple

          View all related MCP servers

          ID: bnuy0j3jrt