Skip to main content
Glama
deenesjakoruzh

Excel MCP Server

by yzfly
GitHub
Python
60
OverviewInspectNewSchemaRelated ServersReviewsScore
Need Help?View Source CodeReport Issue

Excel MCP Server

An MCP server that provides comprehensive Excel file management and data analysis capabilities.

Features

  • Excel File Operations
    • Read multiple Excel formats (XLSX, XLS, CSV, TSV, JSON)
    • Write and update Excel files
    • Get file information and sheet names
  • Data Analysis
    • Summary statistics and descriptive analysis
    • Data quality assessment
    • Pivot tables
    • Filtering and querying data
  • Visualization
    • Generate charts and plots from Excel data
    • Create data previews
    • Export visualizations as images

Installation

  1. Create a new Python environment (recommended):
# Using uv (recommended) uv init excel-mcp-server cd excel-mcp-server uv venv source .venv/bin/activate # On Windows: .venv\Scripts\activate # Or using pip python -m venv .venv source .venv/bin/activate # On Windows: .venv\Scripts\activate
  1. Install dependencies:
# Using uv uv pip install -e .

Integration with Claude Desktop

  1. Install Claude Desktop
  2. Open Settings and go to the Developer tab
  3. Edit claude_desktop_config.json:
{ "mcpServers": { "command": "uvx", "args": [ "mcp-excel-server" ], "env": { "PYTHONPATH": "/path/to/your/python" } } }

Available Tools

File Reading

  • read_excel: Read Excel files
  • get_excel_info: Get file details
  • get_sheet_names: List worksheet names

Data Analysis

  • analyze_excel: Perform statistical analysis
  • filter_excel: Filter data by conditions
  • pivot_table: Create pivot tables
  • data_summary: Generate comprehensive data summary

Data Visualization

  • export_chart: Generate charts
    • Supports line charts, bar charts, scatter plots, histograms

File Operations

  • write_excel: Write new Excel files
  • update_excel: Update existing Excel files

Available Resources

  • excel://{file_path}: Get file content
  • excel://{file_path}/info: Get file structure information
  • excel://{file_path}/preview: Generate data preview image

Prompt Templates

  • analyze_excel_data: Guided template for Excel data analysis
  • create_chart: Help create data visualizations
  • data_cleaning: Assist with data cleaning

Usage Examples

  • "Analyze my sales_data.xlsx file"
  • "Create a bar chart for product_sales.csv"
  • "Filter employees over 30 in employees.xlsx"
  • "Generate a pivot table of department sales"

Security Considerations

  • Read files only from specified paths
  • Limit file size
  • Prevent accidental file overwriting
  • Strictly control data transformation operations

Dependencies

  • pandas
  • numpy
  • matplotlib
  • seaborn

License

MIT License

Install Server
A
security – no known vulnerabilities
F
license - not found
A
quality - confirmed to work

How are these scores calculated?

hybrid server

The server is able to function both locally and remotely, depending on the configuration or use case.

Tools

An MCP server that provides comprehensive Excel file operations, data analysis, and visualization capabilities for working with various spreadsheet formats like XLSX, CSV, and JSON.

  1. Features
    1. Installation
      1. Integration with Claude Desktop
        1. Available Tools
          1. File Reading
          2. Data Analysis
          3. Data Visualization
          4. File Operations
        2. Available Resources
          1. Prompt Templates
            1. Usage Examples
              1. Security Considerations
                1. Dependencies
                  1. License

                    Related MCP Servers

                    • MCP Excel Reader

                      ArchimedesCrypto
                      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
                      25
                      JavaScript
                      MIT License

                    • Excel Reader Server

                      softgridinc-pte-ltd
                      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

                    • Spreadsheet MCP Server

                      HosakaKeigo
                      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

                    • Excel to PDF Converter

                      kmexnx
                      A
                      security
                      A
                      license
                      A
                      quality
                      An MCP server that converts Excel and Apple Numbers files to PDF format, enabling AI assistants like Claude to perform file conversion directly through conversation.
                      Last updated -
                      2
                      253
                      1
                      TypeScript
                      MIT License

                    View all related MCP servers

                    Appeared in Searches

                    New 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/yzfly/mcp-excel-server'

                    If you have feedback or need assistance with the MCP directory API, please join our Discord server