About Excel Server
Excel Server is an MCP server published by yzfly in the Developer Tools category: mcp-excel-server is a project based on the Spring AI MCP framework. Its main function is to provide large language model (LLM) with the ability to read and write local Excel files with the help of MCP protocol. It has been installed 0 times through Conduid.
The repository has 83 stars and 18 forks, with the last commit a year ago. Six months or more without a commit doesn't mean the server is broken, but check the open issues (0) before depending on it in production.
Install
npx mcp-excel-serverThis server has no ConduID identity, so agent calls to it are not receipted. Pin the version you install and review the source before granting it credentials.
Ask AI
Ask AI about Excel Server
Powered by Claude · Grounded in docs
Security checks
- ·README presentNot checked yet.
- ·License declaredNot checked yet.
- ·Tests presentNot checked yet.
- ·Dependencies pinnedNot checked yet.
- ·No dynamic code executionNot checked yet.
- !Scoped permissionsDoesn't declare a permission scope. Assume it can do anything its process can.
README
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
- 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
- Install dependencies:
# Using uv
uv pip install -e .
Integration with Claude Desktop
- Install Claude Desktop
- Open Settings and go to the Developer tab
- 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 filesget_excel_info: Get file detailsget_sheet_names: List worksheet names
Data Analysis
analyze_excel: Perform statistical analysisfilter_excel: Filter data by conditionspivot_table: Create pivot tablesdata_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 filesupdate_excel: Update existing Excel files
Available Resources
excel://{file_path}: Get file contentexcel://{file_path}/info: Get file structure informationexcel://{file_path}/preview: Generate data preview image
Prompt Templates
analyze_excel_data: Guided template for Excel data analysiscreate_chart: Help create data visualizationsdata_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
README mirrored from the source repository 21 days ago. The original is authoritative.