Excel Explorer
Click on "Install 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., "@Excel Explorerload sales_data.xlsx and show me the first few rows"
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.
FastMCP 2.0 ────────────────────────────────────────────────────────────────────
███████╗██╗ ██╗ ██████╗███████╗██╗ ███╗ ███╗ ██████╗██████╗
██╔════╝╚██╗██╔╝██╔════╝██╔════╝██║ ████╗ ████║██╔════╝██╔══██╗
█████╗ ╚███╔╝ ██║ █████╗ ██║ ██╔████╔██║██║ ██████╔╝
██╔══╝ ██╔██╗ ██║ ██╔══╝ ██║ ██║╚██╔╝██║██║ ██╔═══╝
███████╗██╔╝ ██╗╚██████╗███████╗███████╗ ██║ ╚═╝ ██║╚██████╗██║
╚══════╝╚═╝ ╚═╝ ╚═════╝╚══════╝╚══════╝ ╚═╝ ╚═╝ ╚═════╝╚═╝
📊 Server name: Excel Explorer
📦 Transport: Streamable-HTTP / Direct
🔗 Server URL: http://127.0.0.1:8000/mcp
📚 Docs: https://gofastmcp.com
🚀 Deploy: https://fastmcp.cloud
⚡ FastMCP version: 2.10.6
🔧 MCP version: 1.12.3
────────────────────────────────────────────────────────────────────────────────📊 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.
Related MCP server: MCP Excel Server
Install Dependencies
# Set up environment (optional)
source activate-pipx.sh
# Install dependencies
uv syncRequirements:
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
python main.pyor
fastmcp run main.py:mcp --transport http --host 127.0.0.1 --port 8000 --path /mcpThe server will start and listen for MCP connections. You'll see output confirming the server is running.
Testing
# Run all tests
python -m pytest tests/ -v
# Run specific test files
python -m pytest tests/test_file_operations.py -v
python -m pytest tests/test_data_discovery.py -v
# With coverage
python -m pytest tests/ --cov=src --cov-report=htmlIntegrate with Claude
1. Claude Desktop Integration
Add to your Claude Desktop config file (claude_desktop_config.json):
{
"mcpServers": {
"excel-explorer": {
"command": "python",
"args": ["/path/to/excel-mcp/main.py"],
"env": {}
}
}
}or
{
"excelExplorer": {
"command": "npx",
"args": [
"-y",
"mcp-remote",
"http://127.0.0.1:8000/mcp"
],
"env": {
"MCP_TRANSPORT_STRATEGY": "http-only"
}
}
}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
You: "Load the file data/dataset.xlsx and tell me about its structure"
Claude will use:
1. load_excel("data/dataset.xlsx")
2. get_schema("data/dataset.xlsx")
3. get_dimensions("data/dataset.xlsx")
4. describe_dataset("data/dataset.xlsx")
Then provide insights about your data!Ready to explore your Excel data with AI! 🚀📊
This server cannot be installed
Maintenance
Resources
Unclaimed servers have limited discoverability.
Looking for Admin?
If you are the server author, to access and configure the admin panel.
Related MCP Servers
- AlicenseBqualityDmaintenanceAn MCP server that provides comprehensive Excel file operations, data analysis, and visualization capabilities for working with various spreadsheet formats like XLSX, CSV, and JSON.Last updated895MIT
- Flicense-qualityDmaintenanceAn MCP server that enables AI agents to automate Excel file operations including workbook creation, worksheet management, and data manipulation. It provides a standardized interface for reading, writing, merging, and filtering cell ranges within Excel documents.Last updated4
- AlicenseBqualityCmaintenanceMCP server for semantic spreadsheet operations that lets LLMs create and edit Excel workbooks by describing spreadsheet intent.Last updated42MIT
- AlicenseAqualityBmaintenanceMCP server for reading and inspecting local Excel files (.xlsx, .xlsm, .xls, .xlsb, .ods) with tools for inspecting metadata, reading ranges, and profiling structure.Last updated319MIT
Related MCP Connectors
MCP server providing access to the Scorecard API to evaluate and optimize LLM systems.
MCP server for AI dialogue using various LLM models via AceDataCloud
OCR, transcription, file extraction, and image generation for AI agents via MCP.
Appeared in Searches
Latest Blog Posts
- Who's Calling? MCP Hosts Are an Identity Blind Spot (And the Spec Knows It)By Om-Shree-0709 on .mcpAgent IdentityOAuth 2.1
- Your AI Chatbot Just Exposed Your CEO's Salary to an InternBy Om-Shree-0709 on .Agent IdentityMCP SecurityOAuth Delegation
- Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)By Om-Shree-0709 on .Agentic AiPrompt InjectionWebAssembly
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/ASH1998/excel-mcp'
If you have feedback or need assistance with the MCP directory API, please join our Discord server