Excel MCP Server

This is an implementation of a Model Context Protocol (MCP) server that provides Excel file manipulation capabilities without requiring Microsoft Excel installation. It 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, including workbook creation/modification, worksheet/range management, formatting/styling, and support for charts/pivot tables.

Tools

A comprehensive set of Excel manipulation tools is available, documented in TOOLS.md. These tools cover workbook/worksheet management, data reading/writing, formatting/styling, charts/visualizations, and pivot tables/data analysis.

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

The server can be configured using the EXCEL_FILES_PATH environment variable to specify the directory for storing Excel files (default: ./excel_files). Start the server using uv run excel-mcp-server and connect to the SSE endpoint (http://localhost:8000/sse) in Cursor IDE.

License

This project is licensed under the MIT License - see the LICENSE file for details.