Excel MCP Server

Excel MCP Server

Manipulate Excel files programmatically via the Model Context Protocol.

2,795
Stars
326
Forks
2,795
Watchers
37
Issues
Excel MCP Server enables AI agents and applications to create, read, and modify Excel workbooks without relying on Microsoft Excel. It provides comprehensive Excel operations such as editing sheets, managing data, generating charts, and working with pivot tables through various transport protocols including stdio and HTTP. The server supports robust data validation, advanced formatting, and seamless integration as both a local tool and remote service. Configuration options for file management and port settings allow for flexible deployment.

Key Features

Create, read, update Excel workbooks and worksheets
Support for formulas, formatting, charts, and tables
Data validation for ranges and formulas
Comprehensive formatting options including styles, colors, and alignment
Table management with custom styling
Dynamic pivot table generation
Multiple transport methods: stdio, SSE (deprecated), streamable HTTP
Works both locally and as a remote server
Configurable file paths and server ports
Toolset for Excel file manipulation accessible to AI agents

Use Cases

Automated Excel report generation without Microsoft Excel
Integrating Excel file manipulation into AI-driven workflows
Remote bulk processing and validation of spreadsheet data
Programmatic creation of visually formatted tables and charts
Updating and managing business data in shared workbooks
Building web services for Excel document management
Batch manipulation of Excel files in data pipelines
Providing a backend for Excel-based APIs
Generating dynamic pivot tables for analytics dashboards
Validating and cleaning data for downstream machine learning tasks

README

PyPI version Total Downloads License: MIT smithery badge Install 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

  • 📊 Excel Operations: Create, read, update workbooks and worksheets
  • 📈 Data Manipulation: Formulas, formatting, charts, pivot tables, and Excel tables
  • 🔍 Data Validation: Built-in validation for ranges, formulas, and data integrity
  • 🎨 Formatting: Font styling, colors, borders, alignment, and conditional formatting
  • 📋 Table Operations: Create and manage Excel tables with custom styling
  • 📊 Chart Creation: Generate various chart types (line, bar, pie, scatter, etc.)
  • 🔄 Pivot Tables: Create dynamic pivot tables for data analysis
  • 🔧 Sheet Management: Copy, rename, delete worksheets with ease
  • 🔌 Triple transport support: stdio, SSE (deprecated), and streamable HTTP
  • 🌐 Remote & Local: Works both locally and as a remote service

Usage

The server supports three transport methods:

1. Stdio Transport (for local use)

bash
uvx excel-mcp-server stdio
json
{
   "mcpServers": {
      "excel": {
         "command": "uvx",
         "args": ["excel-mcp-server", "stdio"]
      }
   }
}

2. SSE Transport (Server-Sent Events - Deprecated)

bash
uvx excel-mcp-server sse

SSE transport connection:

json
{
   "mcpServers": {
      "excel": {
         "url": "http://localhost:8000/sse",
      }
   }
}

3. Streamable HTTP Transport (Recommended for remote connections)

bash
uvx excel-mcp-server streamable-http

Streamable HTTP transport connection:

json
{
   "mcpServers": {
      "excel": {
         "url": "http://localhost:8000/mcp",
      }
   }
}

Environment Variables & File Path Handling

SSE and Streamable HTTP Transports

When running the server with the SSE or Streamable HTTP protocols, you must set the EXCEL_FILES_PATH environment variable on the server side. This variable tells the server where to read and write Excel files.

  • If not set, it defaults to ./excel_files.

You can also set the FASTMCP_PORT environment variable to control the port the server listens on (default is 8017 if not set).

  • Example (Windows PowerShell):
    powershell
    $env:EXCEL_FILES_PATH="E:\MyExcelFiles"
    $env:FASTMCP_PORT="8007"
    uvx excel-mcp-server streamable-http
    
  • Example (Linux/macOS):
    bash
    EXCEL_FILES_PATH=/path/to/excel_files FASTMCP_PORT=8007 uvx excel-mcp-server streamable-http
    

Stdio Transport

When using the stdio protocol, the file path is provided with each tool call, so you do not need to set EXCEL_FILES_PATH on the server. The server will use the path sent by the client for each operation.

Available Tools

The server provides a comprehensive set of Excel manipulation tools. See TOOLS.md for complete documentation of all available tools.

Star History

Star History Chart

License

MIT License - see LICENSE for details.

Star History

Star History Chart

Repository Owner

haris-musa
haris-musa

User

Repository Details

Language Python
Default Branch main
Size 164 KB
Contributors 9
License MIT License
MCP Verified Nov 12, 2025

Programming Languages

Python
100%

Tags

Topics

ai automation excel llm mcp mcp-server sse stdio streamable-http toolcalling

Join Our Newsletter

Stay updated with the latest AI tools, news, and offers by subscribing to our weekly newsletter.

We respect your privacy. Unsubscribe at any time.

Related MCPs

Discover similar Model Context Protocol servers

  • Mac Apps Launcher MCP Server

    Mac Apps Launcher MCP Server

    Launch and manage macOS applications via an MCP server.

    Mac Apps Launcher MCP Server enables the listing, launching, and management of macOS applications through the Model Context Protocol. Designed to integrate with systems supporting MCP, it provides standardized methods to enumerate app folders, launch apps by name, and open files with specified applications. Configuration details are provided for integration with Claude Config JSON.

    • 16
    • MCP
    • JoshuaRileyDev/mac-apps-launcher
  • Insforge MCP Server

    Insforge MCP Server

    A Model Context Protocol server for seamless integration with Insforge and compatible AI clients.

    Insforge MCP Server implements the Model Context Protocol (MCP), enabling smooth integration with various AI tools and clients. It allows users to configure and manage connections to the Insforge platform, providing automated and manual installation methods. The server supports multiple AI clients such as Claude Code, Cursor, Windsurf, Cline, Roo Code, and Trae via standardized context management. Documentation and configuration guidelines are available for further customization and usage.

    • 3
    • MCP
    • InsForge/insforge-mcp
  • IDA Pro MCP

    IDA Pro MCP

    Enabling Model Context Protocol server integration with IDA Pro for collaborative reverse engineering.

    IDA Pro MCP provides a Model Context Protocol (MCP) server that connects the IDA Pro reverse engineering platform to clients supporting the MCP standard. It exposes a wide array of program analysis and manipulation functionalities such as querying metadata, accessing functions, globals, imports, and strings, decompiling code, disassembling, renaming variables, and more, in a standardized way. This enables seamless integration of AI-powered or remote tools with IDA Pro to enhance the reverse engineering workflow.

    • 4,214
    • MCP
    • mrexodia/ida-pro-mcp
  • Jupyter MCP Server

    Jupyter MCP Server

    Real-time, context-aware MCP server for managing and interacting with Jupyter Notebooks.

    Jupyter MCP Server is an implementation of the Model Context Protocol (MCP) designed to enable AI-driven, real-time management and interaction with Jupyter Notebooks. It offers context-aware capabilities, smart execution features, and multimodal output handling, seamlessly integrating with JupyterLab and supporting multiple notebooks simultaneously. The server is compatible with any MCP client and can work with local or hosted Jupyter deployments.

    • 765
    • MCP
    • datalayer/jupyter-mcp-server
  • MCP Language Server

    MCP Language Server

    Bridge codebase navigation tools to AI models using MCP-enabled language servers.

    MCP Language Server implements the Model Context Protocol, allowing MCP-enabled clients, such as LLMs, to interact with language servers for codebase navigation. It exposes standard language server features—like go to definition, references, rename, and diagnostics—over MCP for seamless integration with AI tooling. The server supports multiple languages by serving as a proxy to underlying language servers, including gopls, rust-analyzer, and pyright.

    • 1,256
    • MCP
    • isaacphi/mcp-language-server
  • Ebook-MCP

    Ebook-MCP

    A Model Context Protocol server for conversational e-book interaction and AI integration.

    Ebook-MCP acts as a Model Context Protocol (MCP) server enabling seamless interaction between large language model (LLM) applications and electronic books such as EPUB and PDF. It standardizes APIs for AI-powered reading, searching, and managing digital libraries. Through natural language interfaces, it provides smart library management, content navigation, and interactive learning within digital books. Ebook-MCP integrates with modern AI-powered IDEs and supports multi-format digital book processing.

    • 132
    • MCP
    • onebirdrocks/ebook-mcp
  • Didn't find tool you were looking for?

    Be as detailed as possible for better results