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
Metadata
Release files for iflow-mcp_mcp-excel-server 1.0.4
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | Provenance | Actions |
|---|---|---|---|---|
| iflow_mcp_mcp_excel_server-1.0.4.tar.gz | 8.0 kB | Without provenance | Details for iflow_mcp_mcp_excel_server-1.0.4.tar.gz |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Actions Reset |
|---|---|---|---|---|
| iflow_mcp_mcp_excel_server-1.0.4-py3-none-any.whl | Python 3 | none | any | Details for iflow_mcp_mcp_excel_server-1.0.4-py3-none-any.whl |
Total release size: 16.2 kB
Release files / iflow_mcp_mcp_excel_server-1.0.4.tar.gz
| Download URL | iflow_mcp_mcp_excel_server-1.0.4.tar.gz |
|---|---|
| Size | 8.0 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
8927224202d12de9ced3d0c999a6a96906beb379dca2da331d67202fb0e03ef9
|
|
BLAKE2b-256 checksum How to use checksums |
7c5b9dbd59fc048f3de4c212d05342cccb07c4d19804eee5217dd7636226aa84
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
uv/0.6.9
|
Release files / iflow_mcp_mcp_excel_server-1.0.4-py3-none-any.whl
| Download URL | iflow_mcp_mcp_excel_server-1.0.4-py3-none-any.whl |
|---|---|
| Size | 8.2 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
3c7e2d616b8f0dfd017c31078844b3fd81a28022fcedf80e816d2dbb10165f77
|
|
BLAKE2b-256 checksum How to use checksums |
78a478502f912e495347d2504d08e44dd6462047d29b8ee7435f8da8873b8bf7
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
uv/0.6.9
|
Security for iflow-mcp_mcp-excel-server 1.0.4
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
No provenance found
None of the files in this release were uploaded with provenance metadata.
A note on package security
PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.
To learn more about protecting yourself from malicious actors, visit our package security documentation.