MCP 服务器

XLSX Reader MCP

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.

Tools

read_xlsx

Read and extract data from Excel (xlsx) files. Supports reading specific sheets, cell ranges, and converting data to various formats.

analyze_xlsx

Analyze Excel files to get detailed information about structure, data types, statistics, and sheet contents.

README

📊 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

Method 1: Stdio Mode (Recommended for Development)

Add to your Claude Desktop configuration:

{
  "mcpServers": {
    "xlsx-reader": {
      "command": "node",
      "args": ["path/to/xlsx-reader-mcp/build/index.js"]
    }
  }
}

Method 2: SSE Mode (Recommended for Production)

# 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:C10")
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