📊 Excel MCP Server
What is this project?
Excel MCP Server is a Model Context Protocol (MCP) server that allows Large Language Models (like Claude) to read, explore, and analyze Excel files. It provides tools for:
- 📂 File Operations: Load Excel files, list sheets, get metadata
- 🔍 Data Discovery: Analyze schemas, sample data, get column statistics
- 📊 Analysis: Comprehensive dataset summaries and data quality reports
Built with FastMCP and pandas, it transforms your Excel files into interactive datasets that AI can understand and query.
Install Dependencies
Requirements:
- Python >=3.13
- fastmcp >=2.10.6
- pandas >=2.3.1
- openpyxl >=3.1.5
- xlrd >=2.0.2
- pytest >=8.4.1
Start the MCP Server
or
The server will start and listen for MCP connections. You'll see output confirming the server is running.
Testing
Integrate with Claude
1. Claude Desktop Integration
Add to your Claude Desktop config file (claude_desktop_config.json
):
or
2. Available Tools
Once connected, Claude can use these tools:
File Operations:
load_excel(file_path, sheet_name)
- Load Excel filelist_sheets(file_path)
- List all sheetsget_file_info(file_path)
- File metadataclear_cache()
- Clear memory
Data Discovery:
get_schema(file_path, sheet_name)
- Column types and statsget_sample_data(file_path, rows=5, sample_type="head")
- Sample dataget_column_info(file_path, column_name)
- Column analysisget_dimensions(file_path)
- Dataset size and memorydescribe_dataset(file_path, include_all=False)
- Statistical summary
3. Example Usage with Claude
Ready to explore your Excel data with AI! 🚀📊
This server cannot be installed
hybrid server
The server is able to function both locally and remotely, depending on the configuration or use case.
An MCP server that allows LLMs to read, analyze, and interact with Excel files through file operations, data discovery, and comprehensive analysis tools.
Related MCP Servers
- AsecurityAlicenseAqualityProvides efficient handling of large Excel files through automatic chunking and pagination, using MCP to enable seamless file reading and management features such as sheet selection and error handling.Last updated -126JavaScriptMIT License
- AsecurityAlicenseAqualityA 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 -35PythonApache 2.0
- -securityFlicense-qualityA Filesystem MCP server that allows an LLM to read and list files from a specified directory on your local machine through the Model Context Protocol.Last updated -2Python
- AsecurityFlicenseAqualityProvides a Model Context Protocol (MCP) server that enables LLMs to directly access and interact with Google Spreadsheet data.Last updated -21TypeScript