Skip to main content
Glama

Excel Explorer

by ASH1998
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.

Install Dependencies

# Set up environment (optional) source activate-pipx.sh # Install dependencies uv sync

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

python main.py

or

fastmcp run main.py:mcp --transport http --host 127.0.0.1 --port 8000 --path /mcp

The 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=html

Integrate 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 file
  • list_sheets(file_path) - List all sheets
  • get_file_info(file_path) - File metadata
  • clear_cache() - Clear memory

Data Discovery:

  • get_schema(file_path, sheet_name) - Column types and stats
  • get_sample_data(file_path, rows=5, sample_type="head") - Sample data
  • get_column_info(file_path, column_name) - Column analysis
  • get_dimensions(file_path) - Dataset size and memory
  • describe_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! 🚀📊

-
security - not tested
F
license - not found
-
quality - not tested

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.

  1. What is this project?
    1. Install Dependencies
      1. Start the MCP Server
        1. Testing
          1. Integrate with Claude
            1. 1. Claude Desktop Integration
            2. 2. Available Tools
            3. 3. Example Usage with Claude

          Related MCP Servers

          • A
            security
            A
            license
            A
            quality
            Provides 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 -
            1
            26
            JavaScript
            MIT License
          • A
            security
            A
            license
            A
            quality
            A 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 -
            3
            5
            Python
            Apache 2.0
            • Linux
            • Apple
          • -
            security
            F
            license
            -
            quality
            A 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 -
            2
            Python
          • A
            security
            F
            license
            A
            quality
            Provides a Model Context Protocol (MCP) server that enables LLMs to directly access and interact with Google Spreadsheet data.
            Last updated -
            2
            1
            TypeScript
            • Apple

          View all related MCP servers

          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