Excel Reader Server

A Model Context Protocol (MCP) server that provides tools for reading Excel (xlsx) files.

Features

Read content from all sheets in an Excel file
Read content from a specific sheet by name
Read content from a specific sheet by index
Returns data in JSON format
Handles empty cells and data type conversions

Installation

Requires Python 3.10 or higher.

# Using pip
pip install excel-reader-server

# Using uv (recommended)
uv pip install excel-reader-server

Dependencies

mcp >= 1.2.1
openpyxl >= 3.1.5

Usage

The server provides three main tools:

1. read_excel

Reads content from all sheets in an Excel file.

{
  "file_path": "path/to/your/excel/file.xlsx"
}

2. read_excel_by_sheet_name

Reads content from a specific sheet by name. If no sheet name is provided, reads the first sheet.

{
  "file_path": "path/to/your/excel/file.xlsx",
  "sheet_name": "Sheet1"  # optional
}

3. read_excel_by_sheet_index

Reads content from a specific sheet by index. If no index is provided, reads the first sheet (index 0).

{
  "file_path": "path/to/your/excel/file.xlsx",
  "sheet_index": 0  # optional
}

Response Format

The server returns data in the following JSON format:

{
  "Sheet1": [
    ["Header1", "Header2", "Header3"],
    ["Value1", "Value2", "Value3"],
    ["Value4", "Value5", "Value6"]
  ]
}

Each sheet is represented as a key in the top-level object
Sheet data is an array of arrays, where each inner array represents a row
All values are converted to strings
Empty cells are represented as empty strings

Error Handling

The server provides clear error messages for common issues:

File not found
Invalid sheet name
Index out of range
General Excel file reading errors

License

This project is released under the Apache 2 License. See the LICENSE file for details.

Contributing

Contributions are welcome! Please feel free to submit a Pull Request.

Install Server

HTTP connection URL

security – no known vulnerabilities

license - permissive license

quality - confirmed to work

How are these scores calculated?

hybrid server

The server is able to function both locally and remotely, depending on the configuration or use case.

Tools

A Model Context Protocol (MCP) server that provides tools for reading Excel (xlsx) files, enabling extraction of data from entire workbooks or specific sheets with results returned in structured JSON format.

Related Resources

Reddit Discussion about this server

Related MCP Servers

Excel MCP Server
negokaz
A
security
A
license
A
quality
A Model Context Protocol server that enables AI assistants to read from and write to Microsoft Excel files, supporting formats like xlsx, xlsm, xltx, and xltm.
Last updated 7 days ago
5
3,173
387
Go
MIT License
OpenPyXL MCP Server
jonemo
-
security
A
license
-
quality
A thin wrapper around the OpenPyXl Python library that exposes Excel file operations as a Model Context Protocol (MCP) server, allowing Claude and other MCP clients to fetch and analyze data from Excel files.
Last updated 3 months ago
12
Python
MIT License
Spreadsheet MCP Server
HosakaKeigo
A
security
F
license
A
quality
Provides a Model Context Protocol (MCP) server that enables LLMs to directly access and interact with Google Spreadsheet data.
Last updated 4 months ago
2
1
TypeScript
Excel MCP Server
yzfly
A
security
F
license
A
quality
An MCP server that provides comprehensive Excel file operations, data analysis, and visualization capabilities for working with various spreadsheet formats like XLSX, CSV, and JSON.
Last updated 3 months ago
8
60
Python

View all related MCP servers

Excel Reader Server