Excel MCP Server
An MCP server that provides comprehensive Excel file management and data analysis capabilities.
Features
- Excel File Operations
- Data Analysis
- Visualization
Installation
- Create a new Python environment (recommended):
- Install dependencies:
Integration with Claude Desktop
- Install Claude Desktop
- Open Settings and go to the Developer tab
- Edit
claude_desktop_config.json:
Available Tools
File Reading
read_excel: Read Excel files
get_excel_info: Get file details
get_sheet_names: List worksheet names
Data Analysis
analyze_excel: Perform statistical analysis
filter_excel: Filter data by conditions
pivot_table: Create pivot tables
data_summary: Generate comprehensive data summary
Data Visualization
export_chart: Generate charts
File Operations
write_excel: Write new Excel files
update_excel: Update existing Excel files
Available Resources
excel://{file_path}: Get file content
excel://{file_path}/info: Get file structure information
excel://{file_path}/preview: Generate data preview image
Prompt Templates
analyze_excel_data: Guided template for Excel data analysis
create_chart: Help create data visualizations
data_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
Excel MCP Server
An MCP server that provides comprehensive Excel file management and data analysis capabilities.
Features
- Excel File Operations
- Data Analysis
- Visualization
Installation
- Create a new Python environment (recommended):
- Install dependencies:
Integration with Claude Desktop
- Install Claude Desktop
- Open Settings and go to the Developer tab
- Edit
claude_desktop_config.json:
Available Tools
File Reading
read_excel: Read Excel files
get_excel_info: Get file details
get_sheet_names: List worksheet names
Data Analysis
analyze_excel: Perform statistical analysis
filter_excel: Filter data by conditions
pivot_table: Create pivot tables
data_summary: Generate comprehensive data summary
Data Visualization
export_chart: Generate charts
File Operations
write_excel: Write new Excel files
update_excel: Update existing Excel files
Available Resources
excel://{file_path}: Get file content
excel://{file_path}/info: Get file structure information
excel://{file_path}/preview: Generate data preview image
Prompt Templates
analyze_excel_data: Guided template for Excel data analysis
create_chart: Help create data visualizations
data_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