MCP Excel Reader
The MCP Excel Reader server allows you to read and process Excel files efficiently with the following capabilities:
Read Excel Files: Extract data from
.xlsxand.xlsformatsAutomatic Chunking: Handle large datasets by splitting them into manageable chunks
Sheet Selection: Specify a sheet by name or default to the first sheet
Row Pagination: Control reading with
startRowandmaxRowsparametersStructured Data: Returns organized data with metadata about sheets, rows, and columns
Error Handling: Validates files and gracefully handles formatting issues
MCP Integration: Works seamlessly with MCP-compatible AI tools like Claude
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@MCP Excel Reader read the sales data from /reports/q3-2024.xlsx"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
MCP Excel Reader
A Model Context Protocol (MCP) server for reading Excel files with automatic chunking and pagination support. Built with SheetJS and TypeScript, this tool helps you handle large Excel files efficiently by automatically breaking them into manageable chunks.
Features
📊 Read Excel files (.xlsx, .xls) with automatic size limits
🔄 Automatic chunking for large datasets
📑 Sheet selection and row pagination
📅 Proper date handling
⚡ Optimized for large files
🛡️ Error handling and validation
Related MCP server: Excel MCP Server
Installation
Installing via Smithery
To install Excel Reader for Claude Desktop automatically via Smithery:
npx -y @smithery/cli install @ArchimedesCrypto/excel-reader-mcp-chunked --client claudeAs an MCP Server
Install globally:
npm install -g @archimdescrypto/excel-readerAdd to your MCP settings file (usually at
~/.config/claude/settings.jsonor equivalent):
{
"mcpServers": {
"excel-reader": {
"command": "excel-reader",
"env": {}
}
}
}For Development
Clone the repository:
git clone https://github.com/ArchimdesCrypto/mcp-excel-reader.git
cd mcp-excel-readerInstall dependencies:
npm installBuild the project:
npm run buildUsage
Usage
The Excel Reader provides a single tool read_excel with the following parameters:
interface ReadExcelArgs {
filePath: string; // Path to Excel file
sheetName?: string; // Optional sheet name (defaults to first sheet)
startRow?: number; // Optional starting row for pagination
maxRows?: number; // Optional maximum rows to read
}
// Response format
interface ExcelResponse {
fileName: string;
totalSheets: number;
currentSheet: {
name: string;
totalRows: number;
totalColumns: number;
chunk: {
rowStart: number;
rowEnd: number;
columns: string[];
data: Record<string, any>[];
};
hasMore: boolean;
nextChunk?: {
rowStart: number;
columns: string[];
};
};
}Basic Usage
When used with Claude or another MCP-compatible AI:
Read the Excel file at path/to/file.xlsxThe AI will use the tool to read the file, automatically handling chunking for large files.
Features
Automatic Chunking
Automatically splits large files into manageable chunks
Default chunk size of 100KB
Provides metadata for pagination
Sheet Selection
Read specific sheets by name
Defaults to first sheet if not specified
Row Pagination
Control which rows to read with startRow and maxRows
Get next chunk information for continuous reading
Error Handling
Validates file existence and format
Provides clear error messages
Handles malformed Excel files gracefully
Extending with SheetJS Features
The Excel Reader is built on SheetJS and can be extended with its powerful features:
Available Extensions
Formula Handling
// Enable formula parsing const wb = XLSX.read(data, { cellFormula: true, cellNF: true });Cell Formatting
// Access cell styles and formatting const styles = Object.keys(worksheet) .filter(key => key[0] !== '!') .map(key => ({ cell: key, style: worksheet[key].s }));Data Validation
// Access data validation rules const validation = worksheet['!dataValidation'];Sheet Features
Merged Cells:
worksheet['!merges']Hidden Rows/Columns:
worksheet['!rows'],worksheet['!cols']Sheet Protection:
worksheet['!protect']
For more features and detailed documentation, visit the SheetJS Documentation.
Contributing
Fork the repository
Create your feature branch (
git checkout -b feature/amazing-feature)Commit your changes (
git commit -m 'Add some amazing feature')Push to the branch (
git push origin feature/amazing-feature)Open a Pull Request
License
This project is licensed under the MIT License - see the LICENSE file for details.
Acknowledgments
Built with SheetJS
Part of the Model Context Protocol ecosystem
Available Tools
1 toolread_excelB
Read an Excel file and return its contents as structured data
Inputs: filePath (required), sheetName, startRow, maxRows.
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
TDQS
Scored across 1 tool
With only one tool, there is no possibility of ambiguity or overlap between tools. The single tool 'read_excel' has a clear and distinct purpose that cannot be confused with any other tool in the set.
The single tool name 'read_excel' follows a clear verb_noun pattern. Since there is only one tool, consistency is inherently perfect with no deviations or mixed conventions to evaluate.
A single tool is generally too few for a server named 'MCP Excel Reader', as it suggests a limited scope that may not support typical Excel-related workflows like writing, updating, or querying data. This feels thin for the apparent domain.
The tool surface is severely incomplete for an Excel reader domain. While reading is covered, there are significant gaps such as writing, editing, formatting, or analyzing Excel files, which will likely cause agent failures in broader tasks.
Maintenance
Related MCP Connectors
The Excel engine for AI agents: read, check and edit Excel models over MCP.
Read-only MCP over your Excel or Airtable plus the PDFs beside it, joined as one relational dataset.
Hosted MCP: CSV/XLSX to JSON rows and text-PDF pages; private uploads or URLs, no API key.
GrapeCity Software MCP for GcExcel docs, examples, and product assistance.
Related MCP Servers
- AlicenseNot gradedqualityDmaintenanceEnables reading and searching Excel files through MCP-compatible clients. Provides tools to retrieve workbook metadata, read sheet contents, and search across all sheets using absolute file paths.1MIT
- AlicenseNot gradedqualityDmaintenanceEnables reading and writing Excel files (text, formulas, and images on Windows) via MCP tools with pagination support.3MIT
- AlicenseAqualityCmaintenanceMCP server for reading and inspecting local Excel files (.xlsx, .xlsm, .xls, .xlsb, .ods) with tools for inspecting metadata, reading ranges, and profiling structure.36 npmMIT
- FlicenseNot gradedqualityDmaintenanceFast, multi-sheet Excel retrieval and writing via MCP, supporting efficient data access with patch-based navigation and formula support.-