MCP Excel Server provides a robust interface for Excel file operations and data analysis through the Model Context Protocol. Developed by yzfly, it enables AI assistants to read, write, and analyze Excel files in various formats (XLSX, CSV, TSV, JSON), offering tools for statistical analysis, data filtering, pivot table creation, and visualization through charts and plots. The server leverages pandas, numpy, matplotlib, and seaborn to perform operations like summary statistics, data quality assessment, and visualization export, making it particularly valuable for data analysis workflows where users need to extract insights from spreadsheets without manual manipulation.
Read Excel files in various formats.
Get details about the Excel file such as its structure and metadata.
List the names of the worksheets in the Excel file.
Perform statistical analysis on the data contained in the Excel file.
Filter the data in the Excel file based on specified conditions.
Create a pivot table based on the data in the Excel file.
Generate a comprehensive summary of the data in the Excel file.
Generate various types of charts (line, bar, scatter, histogram) from Excel data.
Write new Excel files.
Update existing Excel files with new data.
No reviews yet. Be the first to review!
Sign in to join the conversation
