The Excel MCP Server provides comprehensive Excel file management, data analysis, and visualization capabilities.
- File Operations: Read, write, and update Excel files in various formats (XLSX, XLS, CSV, TSV, JSON), retrieve file information, and list sheet names.
- Data Analysis: Perform statistical analysis, generate pivot tables, filter data using query strings, and create comprehensive data summaries.
- Visualization: Generate charts (line, bar, scatter, histogram) from Excel data and export them as images.
- Integration: Integrate with Claude Desktop for enhanced functionality.
- Security: Includes measures to limit file size, control data transformations, and prevent accidental overwrites.
Utilizes NumPy for data analysis operations, enabling statistical calculations and numerical operations on Excel data.
Leverages pandas for Excel file operations, data manipulation, filtering, and pivot table creation across multiple file formats.
Built on Python, allowing execution of Python-based data analysis and Excel management operations.
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):
- 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 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
You must be authenticated.
hybrid server
The server is able to function both locally and remotely, depending on the configuration or use case.
An MCP server that provides comprehensive Excel file operations, data analysis, and visualization capabilities for working with various spreadsheet formats like XLSX, CSV, and JSON.
Related MCP Servers
- -securityAlicense-qualityProvides Excel file manipulation capabilities. This server enables workbook creation, data manipulation, formatting, and advanced Excel features.Last updated -845PythonMIT License
- AsecurityAlicenseAqualityA Model Context Protocol (MCP) server that provides tools for reading Excel (xlsx) files, enabling extraction of data from entire workbooks or specific sheets with results returned in structured JSON format.Last updated -35PythonApache 2.0
- -securityAlicense-qualityA thin wrapper around the OpenPyXl Python library that exposes Excel file operations as a Model Context Protocol (MCP) server, allowing Claude and other MCP clients to fetch and analyze data from Excel files.Last updated -9PythonMIT License
- -securityAlicense-qualityThis MCP server integrates with Google Drive to allow listing, reading, and searching files, as well as the ability to read and write to Google Sheets.Last updated -91JavaScriptMIT License