yzfly/mcp-excel-server
Free通过自然语言与 Excel 交互的 MCP 服务器。
FreeFree tier
Outputs: image
About yzfly/mcp-excel-server
The Excel MCP Server is an open-source tool that enables natural language interaction with Excel files through the Model Context Protocol (MCP). It provides comprehensive capabilities for reading, analyzing, visualizing, and writing Excel data. Users can perform tasks like statistical analysis, filtering, pivot tables, data quality assessment, and chart generation (line, bar, scatter, histogram) using simple natural language commands. It supports multiple file formats including XLSX, XLS, CSV, TSV, and JSON, and integrates with MCP-compatible clients like Claude Desktop.
Key Features
Read multiple Excel formats (XLSX, XLS, CSV, TSV, JSON)
Write and update Excel files
Get file information and sheet names
Summary statistics and descriptive analysis
Data quality assessment
Pivot tables
Filtering and querying data
Generate charts and plots (line, bar, scatter, histogram)
Create data previews and export visualizations as images
Natural language interface via MCP
Pros & Cons
Pros
- Open-source and free to use
- Integrates with Claude Desktop and other MCP clients
- Supports multiple data file formats
- Provides both data analysis and visualization capabilities
- Enables natural language queries for Excel data interaction
Cons
- Requires an MCP-compatible client (e.g., Claude Desktop) to use
- Setup requires Python environment and dependency management (uv or pip)
- Limited to file-based Excel/CSV/TSV/JSON data sources
Best For
Analyze sales data files using natural languageCreate bar charts or line charts from CSV or Excel dataFilter rows based on conditions (e.g., employees over 30)Generate pivot tables from department or category dataPerform data cleaning and summary analysis
FAQ
What is the Excel MCP Server?
It is an open-source MCP server that allows users to interact with Excel files using natural language. It can read, analyze, visualize, and write Excel data through the Model Context Protocol.
How do I install the Excel MCP Server?
Create a Python virtual environment (using uv or pip), then install dependencies with 'uv pip install -e .' or 'pip install -e .'. Then configure your MCP client (e.g., Claude Desktop) to use the server.
What file formats are supported?
The server supports XLSX, XLS, CSV, TSV, and JSON formats.
What tools are available?
Tools include read_excel, get_excel_info, get_sheet_names, analyze_excel, filter_excel, pivot_table, data_summary, export_chart, write_excel, and update_excel.