Skip to main content
Glama

XLSX Reader MCP

by guangxiangdebizi
GitHub
TypeScript
OverviewInspectNewSchemaRelated ServersReviewsScore
Need Help?View Source CodeReport Issue

📊 XLSX Reader MCP

A powerful Model Context Protocol (MCP) server for reading and analyzing Excel documents with advanced features.

✨ Features

  • 📖 Read Excel Files: Support for .xlsx, .xls, and .xlsm formats
  • 🎯 Flexible Data Access: Read entire sheets, specific ranges, or targeted cells
  • 📊 Multiple Output Formats: JSON, CSV, and formatted table outputs
  • 🔍 Advanced Analysis: Detailed file structure, data type analysis, and statistics
  • 📋 Sheet Management: Work with multiple sheets and get comprehensive overviews
  • 🎨 Beautiful Formatting: Clean, readable output with proper table formatting
  • ⚡ High Performance: Efficient processing of large Excel files
  • 🚫 Smart Filtering: Automatically skip empty rows for cleaner output
  • 📏 Configurable Limits: Control maximum rows and preview size for optimal performance

🚀 Quick Start

Installation

# Clone the repository git clone https://github.com/guangxiangdebizi/xlsx-reader-mcp.git cd xlsx-reader-mcp # Install dependencies npm install # Build the project npm run build

Usage with Claude Desktop

Add to your Claude Desktop configuration:

{ "mcpServers": { "xlsx-reader": { "command": "node", "args": ["path/to/xlsx-reader-mcp/build/index.js"] } } }
# Start the SSE server npm run sse

Then add to Claude Desktop configuration:

{ "mcpServers": { "xlsx-reader": { "type": "sse", "url": "http://localhost:3100/sse", "timeout": 600 } } }

🛠️ Available Tools

1. read_xlsx - Excel File Reader

Read and extract data from Excel files with flexible formatting options and search capabilities.

Parameters:

  • filePath (required): Path to the Excel file
  • sheetName (optional): Specific sheet to read
  • range (optional): Cell range (e.g., "A1")
  • format (optional): Output format - "json", "csv", or "table" (default)
  • includeHeaders (optional): Include headers in output (default: true)
  • maxRows (optional): Maximum rows to return (default: 100, max: 1000)
  • searchColumn (optional): Column to search in (column name, index, or Excel letter)
  • searchValue (optional): Value to search for
  • searchType (optional): Search type - "exact", "contains", "startsWith", "endsWith" (default: "exact")

Note: Empty rows are automatically filtered out to provide cleaner output.

Example Usage:

Read the Excel file "data.xlsx" and show the first sheet as a table

2. analyze_xlsx - Excel File Analyzer

Perform comprehensive analysis of Excel files including structure, data types, and statistics.

Parameters:

  • filePath (required): Path to the Excel file
  • includePreview (optional): Include data preview (default: true)
  • previewRows (optional): Number of preview rows (default: 5, max: 20)
  • analyzeDataTypes (optional): Analyze column data types (default: true)

Example Usage:

Analyze the structure and content of "report.xlsx"

📖 Examples

Basic File Reading

Read the Excel file "sales_data.xlsx"

Reading Specific Sheet and Range

Read cells A1:E10 from the "Summary" sheet in "quarterly_report.xlsx" and format as JSON

Reading with Row Limits

Read "large_dataset.xlsx" but limit to first 50 rows

Searching Data

Search for "ADSL" in column A of "data.xlsx" with exact match
Find all rows containing "John" in the "Name" column of "employees.xlsx"
Search for values starting with "ABC" in column 3 of "products.xlsx"

Comprehensive File Analysis

Analyze "customer_database.xlsx" and show detailed information about all sheets

🏗️ Project Structure

src/ ├── index.ts # MCP server entry point └── tools/ ├── xlsx-reader.ts # Excel file reading tool └── xlsx-analyzer.ts # Excel file analysis tool

🔧 Development

Scripts

  • npm run build - Build the TypeScript project
  • npm run dev - Watch mode for development
  • npm start - Start the MCP server
  • npm run sse - Start SSE server on port 3100

Dependencies

📄 License

This project is licensed under the Apache License 2.0 - see the LICENSE file for details.

👨‍💻 Author

Xingyu Chen

🤝 Contributing

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

🙏 Acknowledgments

Made with ❤️ for the MCP community

Install Server
A
security – no known vulnerabilities
F
license - not found
A
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 server that enables reading and analyzing Excel documents with features like flexible data access, multiple output formats, and advanced analysis capabilities.

  1. ✨ Features
    1. 🚀 Quick Start
      1. Installation
      2. Usage with Claude Desktop
    2. 🛠️ Available Tools
      1. 1. read_xlsx - Excel File Reader
      2. 2. analyze_xlsx - Excel File Analyzer
    3. 📖 Examples
      1. Basic File Reading
      2. Reading Specific Sheet and Range
      3. Reading with Row Limits
      4. Searching Data
      5. Comprehensive File Analysis
    4. 🏗️ Project Structure
      1. 🔧 Development
        1. Scripts
        2. Dependencies
      2. 📄 License
        1. 👨‍💻 Author
          1. 🤝 Contributing
            1. 🙏 Acknowledgments

              Related MCP Servers

              • Excel Reader Server

                softgridinc-pte-ltd
                A
                security
                A
                license
                A
                quality
                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.
                Last updated -
                3
                5
                Python
                Apache 2.0
                • Linux
                • Apple

              • 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 -
                5
                6,317
                407
                Go
                MIT License
                • Linux
                • Apple

              • Excel MCP Server

                zhiwei5576
                A
                security
                A
                license
                A
                quality
                Enables seamless reading, writing, and analyzing of Excel files through Model Context Protocol, with features for worksheet management, structure analysis, and automated caching.
                Last updated -
                8
                556
                35
                TypeScript
                MIT License
                • Linux
                • Apple

              • chatExcel

                Lillard01
                -
                security
                A
                license
                -
                quality
                A Model Context Protocol server for intelligent Excel processing and data analysis, offering tools for reading, validating, executing code, and generating interactive visualizations with Excel files.
                Last updated -
                17
                Python
                MIT License
                • Apple
                • Linux

              View all related MCP servers

              New MCP Servers

              MCP directory API

              We provide all the information about MCP servers via our MCP API.

              curl -X GET 'https://glama.ai/api/mcp/v1/servers/guangxiangdebizi/xlsx-mcp'

              If you have feedback or need assistance with the MCP directory API, please join our Discord server