The Excel MCP Server is a powerful tool that enables natural language interaction with Excel files through the Model Context Protocol (MCP). It provides a comprehensive set of capabilities for reading, analyzing, visualizing, and writing Excel data.
An MCP server that provides comprehensive Excel file management and data analysis capabilities.
Excel File Operations
Data Analysis
Visualization
# 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
# Using uv
uv pip install -e .
claude_desktop_config.json
:{
"mcpServers": {
"command": "uvx",
"args": [
"mcp-excel-server"
],
"env": {
"PYTHONPATH": "/path/to/your/python"
}
}
}
read_excel
: Read Excel filesget_excel_info
: Get file detailsget_sheet_names
: List worksheet namesanalyze_excel
: Perform statistical analysisfilter_excel
: Filter data by conditionspivot_table
: Create pivot tablesdata_summary
: Generate comprehensive data summaryexport_chart
: Generate charts
write_excel
: Write new Excel filesupdate_excel
: Update existing Excel filesexcel://{file_path}
: Get file contentexcel://{file_path}/info
: Get file structure informationexcel://{file_path}/preview
: Generate data preview imageanalyze_excel_data
: Guided template for Excel data analysiscreate_chart
: Help create data visualizationsdata_cleaning
: Assist with data cleaningMIT License
{ "mcpServers": { "mcp-excel-server": { "command": "uvx", "args": [ "mcp-excel-server" ] } } }
Related projects feature coming soon
Will recommend related projects based on sub-categories