Openpyxl

A thin wrapper around the OpenPyXl Python library that exposes some of its features as Model Context Protocol (MCP) server. This allows Claude and other MCP clients to fetch data from Excel files.

python

18

GitHub Stars

python

Language

6 months ago

First Indexed

2 months ago

Catalog Refreshed

Documentation & install

Readme and setup notes from the catalogue, plus a client-ready config you can copy for your MCP host.

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "jonemo-openpyxl-mcp-server": {
      "command": "/Users/<YOUR-USERNAME>/Downloads/openpyxl_mcp_server",
      "args": []
    }
  }
}

You can access and query data from Excel files using the OpenPyxl MCP Server. This server wraps the OpenPyxl library and exposes select features through the Model Context Protocol, letting clients like Claude fetch data from spreadsheets in a structured way.

How to use

Install and run the MCP server locally, then configure your MCP client to connect to it. You can inspect Excel files, read sheet data, and extract values through the MCP interface. Use a dedicated MCP server entry for each client configuration if needed, and restart the client after adding or updating the server.

How to install

Prerequisites you need before installing: Python installed on your system, and basic command line access.

Install from sources or use prebuilt executables as described below.

{
  "mcpServers": {
    "inspect_excel_xlsx_file": {
      "command": "/Users/<YOUR-USERNAME>/Downloads/openpyxl_mcp_server",
      "args": []
    }
  }
}

Configuration and server entries

This MCP server can be run as a local process (stdio) or via a Python-based source configuration. Use the appropriate entry for your environment. The following examples show how to configure a client to launch the server from a local executable or from source.

{
  "mcpServers": {
    "inspect_excel_xlsx_file": {
      "command": "C:\\Users\\<YOUR-USERNAME>\\Downloads\\openpyxl_mcp_server.exe",
      "args": []
    }
  }
}

{
  "mcpServers": {
    "excel_xlsx_src": {
      "command": "/Users/jonas/repos/openpyxl_mcp_server/venv/bin/python",
      "args": ["/Users/jonas/repos/openpyxl_mcp_server/openpyxl_mcp_server.py"]
    }
  }
}

Notes on installation flow

If you are using the prebuilt executables, download the appropriate file for your platform and make sure it is executable on macOS. On Windows, you may need to approve the executable in security prompts.

Troubleshooting

Restart the MCP client after adding or updating server configurations. Ensure the command paths and usernames are correct for your system. If the server does not start, verify that the executable has execute permissions on macOS and that the Python path is valid when using the source approach.