The Excel Reader Server is a MCP server that provides tools for reading and extracting data from Excel (xlsx) files in JSON format.
Capabilities include:
- Reading content from all sheets in an Excel file
- Extracting data from a specific sheet by name (defaults to first sheet if unspecified)
- Extracting data from a specific sheet by index (defaults to index 0 if unspecified)
- Returning data structured as arrays of arrays (representing rows and cells)
- Converting all values to strings and representing empty cells as empty strings
- Providing clear error handling for common issues like file not found, invalid sheet names, or index out of range
Provides tools for reading and parsing Excel (.xlsx) files using Python, enabling extraction of data from entire workbooks or specific sheets by name or 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
Usage
The server provides three main tools:
1. read_excel
Reads content from all sheets in an Excel file.
2. read_excel_by_sheet_name
Reads content from a specific sheet by name. If no sheet name is provided, reads the first sheet.
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).
Response Format
The server returns data in the following JSON 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
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.
hybrid server
The server is able to function both locally and remotely, depending on the configuration or use case.
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
Related MCP Servers
- AsecurityAlicenseAqualityA 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 ago53,173387GoMIT License
- -securityAlicense-qualityA 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 ago12PythonMIT License
- AsecurityFlicenseAqualityProvides a Model Context Protocol (MCP) server that enables LLMs to directly access and interact with Google Spreadsheet data.Last updated 4 months ago21TypeScript
- AsecurityFlicenseAqualityAn 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 ago860Python