mcp-excel-server

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

• 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

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

2. Install dependencies:

# Using uv
uv pip install -e .

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"
      }
  }
}