What is Haris Musa Excel Mcp Server

haris-musa_excel-mcp-server is a Model Context Protocol (MCP) server that allows users to manipulate Excel files without needing Microsoft Excel installed. It enables the creation, reading, and modification of Excel workbooks using an AI agent.

Use cases

Use cases include automating report generation, data analysis tasks, creating dashboards, and integrating Excel functionalities into AI applications for enhanced productivity.

How to use

To use haris-musa_excel-mcp-server, first clone the repository and install the necessary dependencies using Python 3.10 or higher. Start the server on the default port 8000 or a custom port, and configure it with your AI tools to access Excel functionalities.

Key features

Key features include creating and modifying Excel workbooks, reading and writing data, applying formatting and styles, creating charts and visualizations, generating pivot tables, and managing worksheets and ranges.

Where to use

haris-musa_excel-mcp-server can be used in various fields such as data analysis, business reporting, educational purposes, and any application requiring Excel file manipulation without the need for Microsoft Excel.

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

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

2. 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):

   • Use Supergateway to convert SSE to stdio:

2. Hosting Your MCP Server:

   • Remote MCP Server Guide

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.