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! 🚀📊
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections. Dates show when Glama detected each change.
No tool schema history has been recorded yet.
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 Connectors
MCP server for querying and analyzing data from ad platforms, analytics tools, and spreadsheets
MCP server for building and testing AI agents with multi-model experimentation and insights.
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
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.894MIT
- FlicenseNot gradedqualityDmaintenanceAn 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.4-
- AlicenseBqualityCmaintenanceMCP server for semantic spreadsheet operations that lets LLMs create and edit Excel workbooks by describing spreadsheet intent.42MIT
- AlicenseAqualityBmaintenanceMCP server for reading and inspecting local Excel files (.xlsx, .xlsm, .xls, .xlsb, .ods) with tools for inspecting metadata, reading ranges, and profiling structure.313MIT
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