openpyxl_mcp_server

What is this?

This is a wrapper around the OpenPyXL Python library, exposing its features as a Model Context Protocol (MCP) server. This allows Claude and other MCP clients to fetch data from Excel files.

Installation

General Steps

1. Download the executable from the releases page.
2. Configure your MCP Client, such as Claude Desktop.

Alternatively, install directly from the source code.

Configuring Claude Desktop

1. Install Claude Desktop.
2. Download the MCP server executable.
3. Open Claude Desktop "Settings..." menu and navigate to the "Developer" section.
4. Click "Edit Config" to create/edit the claude_desktop_config.json file.
5. Add the configuration for MacOS or Windows, adjusting the path to the executable.
6. Restart the Claude app completely.

Configuring other MCP clients

Instructions for configuring MCP servers in other tools that support them:

• Cursor
• Windsurf
• Zed
• RooCode
• Cline
• LibreChat

From Source (for development)

Clone the repository, create a virtual environment, and install the requirements. Then, update the claude_desktop_config.json file with the path to the Python interpreter and the openpyxl_mcp_server.py script.

Example prompts

Provides example prompts for using the server with Claude, including extracting data from datasets, analyzing financial records, and filling out forms.

Contributing and Development

Building standalone executables

Install dependencies and use PyInstaller to build standalone executables. On macOS, you may need to sign the executable.

MCP Server Directories

openpyxl-mcp-server is currently listed in these MCP server directories:

• https://mcp.so/server/openpyxl-mcp-server/jonemo
• https://mcpserver.cloud/server/openpyxl-mcp-server
• https://www.mcpserverfinder.com/servers/jonemo/openpyxl-mcp-server