Excel Data Manager
Summary
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.
Available Actions(10)
read_excel
Read Excel files of various formats.
get_excel_info
Get details about the Excel file.
get_sheet_names
List the names of the worksheets in the Excel file.
analyze_excel
Perform statistical analysis on the data in an Excel file.
filter_excel
Filter data in an Excel file based on specified conditions.
pivot_table
Create a pivot table from the data in an Excel file.
data_summary
Generate a comprehensive summary of the data in an Excel file.
export_chart
Generate charts from Excel data, including line charts, bar charts, scatter plots, and histograms.
write_excel
Write new data to an Excel file.
update_excel
Update existing data in an Excel file.
社区评论
暂无评论. 成为第一个评论的人！
登录以参与讨论
