Skip to main content
Glama

Excel MCP Server

Excel MCP Server

A Model Context Protocol (MCP) server implementation that provides Excel file manipulation capabilities without requiring Microsoft Excel installation. This server enables workbook creation, data manipulation, formatting, and advanced Excel features.

Requirements

  • Python 3.10+
  • MCP SDK 1.2.0+
  • OpenPyXL 3.1.2+

Components

Resources

The server provides Excel workbook manipulation through OpenPyXL:

  • Creates and modifies Excel workbooks
  • Manages worksheets and ranges
  • Handles formatting and styles
  • Supports charts and pivot tables

Tools

This server provides a comprehensive set of Excel manipulation tools. For detailed documentation of all available tools, their parameters, and usage examples, please refer to TOOLS.md.

The tools include capabilities for:

  • Workbook and worksheet management
  • Data reading and writing
  • Formatting and styling
  • Charts and visualizations
  • Pivot tables and data analysis

See TOOLS.md for complete documentation.

Features

  • Full Excel Support: Comprehensive Excel functionality
  • Data Manipulation: Read, write, and transform data
  • Advanced Features: Charts, pivot tables, and formatting
  • Error Handling: Comprehensive error handling with clear messages

Usage

Environment Configuration

The server can be configured using the following environment variables:

  • EXCEL_FILES_PATH: Directory where Excel files will be stored (default: ./excel_files)

You can set this in different ways:

Windows CMD:

set EXCEL_FILES_PATH=C:\path\to\excel\files uv run excel-mcp-server

Windows PowerShell:

$env:EXCEL_FILES_PATH="C:\path\to\excel\files" uv run excel-mcp-server

Linux/MacOS:

export EXCEL_FILES_PATH=/path/to/excel/files uv run excel-mcp-server

Or in Claude Desktop config:

{ "mcpServers": { "excel": { "command": "uv run excel-mcp-server", "transport": "sse", "env": { "EXCEL_FILES_PATH": "/path/to/excel/files" } } } }

Starting the Server

Start the server:

uv run excel-mcp-server

The server will start in SSE mode and wait for connections from MCP clients.

Connecting in Cursor IDE

After starting the server, connect to the SSE endpoint in Cursor IDE:

http://localhost:8000/sse

The Excel MCP tools will be available through the agent.

For available tools and their usage, please refer to TOOLS.md.

License

This project is licensed under the MIT License - see the LICENSE file 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 without requiring Microsoft Excel installation, enabling workbook creation, data manipulation, formatting, and advanced Excel features.

  1. Requirements
    1. Components
      1. Resources
      2. Tools
    2. Features
      1. Usage
        1. Environment Configuration
        2. Starting the Server
        3. Connecting in Cursor IDE
      2. License

        Related MCP Servers

        • A
          security
          A
          license
          A
          quality
          Provides Excel file manipulation capabilities. This server enables workbook creation, data manipulation, formatting, and advanced Excel features.
          Last updated 22 days ago
          20
          1,721
          Python
          MIT License
          • Linux
          • Apple
        • A
          security
          A
          license
          A
          quality
          Provides seamless integration with Smartsheet, enabling automated operations on Smartsheet documents through a standardized interface that bridges AI-powered automation tools with Smartsheet's collaboration platform.
          Last updated a month ago
          12
          9
          Python
          MIT License
          • Linux
          • Apple
        • 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 3 months ago
          8
          715
          34
          TypeScript
          MIT License
          • Linux
          • Apple
        • -
          security
          F
          license
          -
          quality
          Enables users to preprocess, analyze, and visualize CSV data through comprehensive tools for data manipulation, statistical analysis, and graph generation.
          Last updated 3 months ago
          1
          Python

        View all related MCP servers

        MCP directory API

        We provide all the information about MCP servers via our MCP API.

        curl -X GET 'https://glama.ai/api/mcp/v1/servers/fish0710/excel-mcp'

        If you have feedback or need assistance with the MCP directory API, please join our Discord server