📊 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

Related MCP server: Excel MCP Server

🚀 Quick Start

Installation

Usage with Claude Desktop

Method 1: Stdio Mode (Recommended for Development)

Add to your Claude Desktop configuration:

Method 2: SSE Mode (Recommended for Production)

Then add to Claude Desktop configuration:

🛠️ 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:

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:

📖 Examples

Basic File Reading

Reading Specific Sheet and Range

Reading with Row Limits

Searching Data

Comprehensive File Analysis

🏗️ Project Structure

🔧 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

• @modelcontextprotocol/sdk: MCP SDK for server implementation

• xlsx: Excel file processing library

📄 License

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

👨‍💻 Author

Xingyu Chen

• 📧 Email: guangxiangdebizi@gmail.com

• 🐙 GitHub: @guangxiangdebizi

• 💼 LinkedIn: Xingyu Chen

• 📦 NPM: @xingyuchen

🤝 Contributing

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

🙏 Acknowledgments

• Thanks to the Model Context Protocol team for the excellent SDK

• Built with SheetJS for robust Excel file processing

Made with ❤️ for the MCP community