Skip to content
Back to search

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.

Checked today
Badge for your README
findsafeskills safety rating

Markdown

[![findsafeskills safety rating](/api/listings/yzfly--mcp-excel-server/badge.svg)](/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

i

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)

  1. # Excel MCP Server
  2. An MCP server that provides comprehensive Excel file management and data analysis capabilities.
  3. ## Features
  4. - **Excel File Operations**
  5. - Read multiple Excel formats (XLSX, XLS, CSV, TSV, JSON)
  6. - Write and update Excel files
  7. - Get file information and sheet names
  8. - **Data Analysis**
  9. - Summary statistics and descriptive analysis
  10. - Data quality assessment
  11. - Pivot tables
  12. - Filtering and querying data
  13. - **Visualization**
  14. - Generate charts and plots from Excel data
  15. - Create data previews
  16. - Export visualizations as images
  17. ## Installation
  18. 1. Create a new Python environment (recommended):
  19. ```bash
  20. # Using uv (recommended)
  21. uv init excel-mcp-server
  22. cd excel-mcp-server
  23. uv venv
  24. source .venv/bin/activate # On Windows: .venv\Scripts\activate
  25. # Or using pip
  26. python -m venv .venv
  27. source .venv/bin/activate # On Windows: .venv\Scripts\activate
  28. ```
  29. 2. Install dependencies:
  30. ```bash
  31. # Using uv
  32. uv pip install -e .
  33. ```
  34. ## Integration with Claude Desktop
  35. 1. Install [Claude Desktop](https://claude.ai/download)
  36. 2. Open Settings and go to the Developer tab
  37. 3. Edit `claude_desktop_config.json`:
  38. ```json
  39. {
  40. "mcpServers": {
  41. "command": "uvx",
  42. "args": [
  43. "mcp-excel-server"
  44. ],
  45. "env": {
  46. "PYTHONPATH": "/path/to/your/python"
  47. }
  48. }
  49. }
  50. ```
  51. ## Available Tools
  52. ### File Reading
  53. - `read_excel`: Read Excel files
  54. - `get_excel_info`: Get file details
  55. - `get_sheet_names`: List worksheet names
  56. ### Data Analysis
  57. - `analyze_excel`: Perform statistical analysis
  58. - `filter_excel`: Filter data by conditions
  59. - `pivot_table`: Create pivot tables
  60. - `data_summary`: Generate comprehensive data summary
  61. ### Data Visualization
  62. - `export_chart`: Generate charts
  63. - Supports line charts, bar charts, scatter plots, histograms
  64. ### File Operations
  65. - `write_excel`: Write new Excel files
  66. - `update_excel`: Update existing Excel files
  67. ## Available Resources
  68. - `excel://{file_path}`: Get file content
  69. - `excel://{file_path}/info`: Get file structure information
  70. - `excel://{file_path}/preview`: Generate data preview image
  71. ## Prompt Templates
  72. - `analyze_excel_data`: Guided template for Excel data analysis
  73. - `create_chart`: Help create data visualizations
  74. - `data_cleaning`: Assist with data cleaning
  75. ## Usage Examples
  76. - "Analyze my sales_data.xlsx file"
  77. - "Create a bar chart for product_sales.csv"
  78. - "Filter employees over 30 in employees.xlsx"
  79. - "Generate a pivot table of department sales"
  80. ## Security Considerations
  81. - Read files only from specified paths
  82. - Limit file size
  83. - Prevent accidental file overwriting
  84. - Strictly control data transformation operations
  85. ## Dependencies
  86. - pandas
  87. - numpy
  88. - matplotlib
  89. - seaborn
  90. ## License
  91. MIT License

Ratings and comments

Sign in to rate this skill.

Sign in

Free to use. If it’s helped, pass it on.