MCP Excel Server

🚀 Excel MCP Server

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

🚀 Quick Start

This Excel MCP Server provides a wide range of features for Excel file management and data analysis. You can start using it by following the installation steps below.

✨ Features

• Excel File Operations
  • Support for reading various Excel formats (XLSX, XLS, CSV, TSV, JSON).
  • Writing and updating Excel files.
  • Retrieving file information and worksheet names.
• Data Analysis
  • Aggregate statistics and descriptive analysis.
  • Data quality assessment.
  • Creation of pivot tables.
  • Data filtering and querying.
• Visualization
  • Generation of charts and graphs based on Excel data.
  • Creation of data previews.
  • Export of visualization results as images.

📦 Installation

1. Create a new Python environment (recommended):

# Use uv (recommended)
uv init excel-mcp-server
cd excel-mcp-server
uv venv
source .venv/bin/activate  # On Windows: .venv\Scripts\activate

# Or use pip
python -m venv .venv
source .venv/bin/activate  # On Windows: .venv\Scripts\activate

2. Install dependencies:

# Use uv
uv pip install -r requirements.txt

# Or use pip
pip install -r requirements.txt

📚 Documentation

Integration with Claude Desktop

1. Install Claude Desktop.
2. Open the 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 an Excel file.
• get_excel_info: Get detailed file information.
• get_sheet_names: List worksheet names.

Data Analysis

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

Data Visualization

• export_chart: Generate charts.
  • Supported chart types include line charts, bar charts, scatter plots, and histograms.

File Operations

• write_excel: Write a new Excel file.
• update_excel: Update an existing Excel file.

Available Resources

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

Prompt Templates

• analyze_excel_data: A guided template for Excel data analysis.
• create_chart: Assist in creating data visualizations.
• data_cleaning: Aid in data cleaning.

💻 Usage Examples

Basic Usage

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

⚠️ Important Note

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

📄 License

This project is licensed under the MIT License.

📦 Dependencies

• pandas
• numpy
• matplotlib
• seaborn