Skip to main content
Glama
Sign In
enesjakozh

Excel Reader Server

by softgridinc-pte-ltd
GitHub
Python
Apache 2.0
2
  • Linux
  • Apple
OverviewInspectNewSchemaRelated ServersReviewsScore
Need Help?View Source CodeReport Issue

Integrations

  • 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.

# 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.

You must be authenticated.

A
security – no known vulnerabilities
A
license - permissive license
A
quality - confirmed to work

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.

  1. Features
    1. Installation
      1. Dependencies
        1. Usage
          1. 1. read_excel
          2. 2. read_excel_by_sheet_name
          3. 3. read_excel_by_sheet_index
        2. Response Format
          1. Error Handling
            1. License
              1. Contributing

                Related Resources

                Related MCP Servers

                • mcp-lancedb

                  adiom-data
                  -
                  security
                  A
                  license
                  -
                  quality
                  A Model Context Protocol (MCP) server that enables LLMs to interact directly the documents that they have on-disk through agentic RAG and hybrid search in LanceDB. Ask LLMs questions about the dataset as a whole or about specific documents.
                  Last updated -
                  12
                  31
                  TypeScript
                  MIT License
                  • Apple

                • Excel MCP Server

                  negokaz
                  -
                  security
                  A
                  license
                  -
                  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 -
                  2,278
                  168
                  Go
                  MIT License
                  • Linux
                  • Apple

                • MCP Server

                  GobinFan
                  -
                  security
                  F
                  license
                  -
                  quality
                  Implements the Model Context Protocol (MCP) to provide AI models with a standardized interface for connecting to external data sources and tools like file systems, databases, or APIs.
                  Last updated -
                  90
                  Python
                  • Apple
                  • Linux

                • MCP Local File Reader

                  sworddut
                  -
                  security
                  A
                  license
                  -
                  quality
                  A Model Context Protocol (MCP) server that allows AI models to safely access and interact with local file systems, enabling reading file contents, listing directories, and retrieving file metadata.
                  Last updated -
                  47
                  1
                  JavaScript
                  MIT License
                  • Linux

                View all related MCP servers

                Appeared in Searches

                New MCP Servers

                ID: kniyyx0gej