mcp-excel-reader-server
5
The Excel Reader Server is a Model Context Protocol (MCP) server designed to facilitate the reading of Excel files. It allows users to extract data from Excel sheets and provides the results in JSON format while handling empty cells and data type conversions. It supports reading from all sheets, specific sheets by name, or by index.
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.
Dependencies
- mcp >= 1.2.1
- openpyxl >= 3.1.5
Response Format
- 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
- 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.