mcp-excel-server
The Excel MCP Server is a powerful tool that enables natural language interaction with Excel files through the Model Context Protocol (MCP). It provides a comprehensive set of capabilities for reading, analyzing, visualizing, and writing Excel data.
Safety scan
A static text scan, not a guarantee. Select the badge to see what was scanned and every finding.
Badge for your README
Markdown
[](/listings/yzfly--mcp-excel-server)HTML
<a href="/listings/yzfly--mcp-excel-server"><img src="/api/listings/yzfly--mcp-excel-server/badge.svg" alt="findsafeskills safety rating" /></a>Install
Install instructions from the README
As written by the repo's author. findsafeskills has not verified these steps.
1. Create a new Python environment (recommended):
# Using uv (recommended) uv init excel-mcp-server cd excel-mcp-server uv venv source .venv/bin/activate # On Windows: .venv\Scripts\activate # Or using pip python -m venv .venv source .venv/bin/activate # On Windows: .venv\Scripts\activate
2. Install dependencies:
# Using uv uv pip install -e .
What was scanned
The files the safety scan read, as written by the repository's author and shown as plain text. Lines with a finding are marked.
README.md · README · 122 lines
View this file on GitHub (read at the repository's current version: the scan did not record which commit it read)
- # 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
- 1. Create a new Python environment (recommended):
- ```bash
- # Using uv (recommended)
- uv init excel-mcp-server
- cd excel-mcp-server
- uv venv
- source .venv/bin/activate # On Windows: .venv\Scripts\activate
- # Or using pip
- python -m venv .venv
- source .venv/bin/activate # On Windows: .venv\Scripts\activate
- ```
- 2. Install dependencies:
- ```bash
- # Using uv
- uv pip install -e .
- ```
- ## Integration with Claude Desktop
- 1. Install [Claude Desktop](https://claude.ai/download)
- 2. Open Settings and go to the Developer tab
- 3. Edit `claude_desktop_config.json`:
- ```json
- {
- "mcpServers": {
- "command": "uvx",
- "args": [
- "mcp-excel-server"
- ],
- "env": {
- "PYTHONPATH": "/path/to/your/python"
- }
- }
- }
- ```
- ## 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
- - Supports line charts, bar charts, scatter plots, histograms
- ### 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
Ratings and comments
Sign in to rate this skill.
Sign inFree to use. If it’s helped, pass it on.