E

Excel

community
other

Excel manipulation including data reading/writing, worksheet management, formatting, charts, and pivot table.

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.

Related Servers

E

Everything

reference

Reference / test server with prompts, resources, and tools

View Details
M

Memory

reference

Knowledge graph-based persistent memory system

View Details
P

Puppeteer

reference

Browser automation and web scraping

View Details
S

Sentry

reference

Retrieving and analyzing issues from Sentry.io

View Details
S

Sequential Thinking

reference

Dynamic and reflective problem-solving through thought sequences

View Details