Description

This Excel MCP server by haris-musa enables AI assistants to manipulate Excel files without requiring Microsoft Excel installation, using the openpyxl library for comprehensive workbook operations. The implementation provides 25+ tools covering workbook creation, data reading/writing with validation metadata, rich formatting with conditional rules, formula application with syntax validation, chart generation, pivot table creation, and native Excel table support. Key differentiators include intelligent data validation detection that exposes dropdown lists and constraint rules to AI assistants, dual transport support (stdio/SSE) with configurable file path handling, and robust error handling with custom exception types, making it valuable for automating Excel-based workflows, data analysis tasks, and report generation where users need programmatic Excel manipulation through natural language interactions.

Installation 

npx -y excel-mcp-server
npm install excel-mcp-server
git clone https://github.com/haris-musa/excel-mcp-server

Claude Desktop Configuration

Add this configuration to your Claude Desktop config file to enable this MCP server:

Config file location: ~/Library/Application Support/Claude/claude_desktop_config.json

Config file location: %APPDATA%\Claude\claude_desktop_config.json

Config file location: ~/.config/Claude/claude_desktop_config.json

claude_desktop_config.json 
{
  "mcpServers": {
    "excel-file-manipulation": {
      "command": "npx",
      "args": [
        "-y",
        "excel-mcp-server"
      ]
    }
  }
}