Repository files navigation

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.

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

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

This server provides a comprehensive set of Excel manipulation tools. For detailed documentation of all available tools, their parameters, and usage examples, please refer toTOOLS.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

SeeTOOLS.md for complete documentation.

• 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

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:

setEXCEL_FILES_PATH=C:\path\to\excel\filesuv 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/filesuv 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"      }    }  }}

Start the server:

uv run excel-mcp-server

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

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 toTOOLS.md.

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