Excel MCP Server

Name: Excel MCP Server
Author: yzfly

@yzfly

关于 Excel MCP 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.

#data #mcp #excel #claude #claude-mcp #mcp-excel-server

基本信息

分类

其他

运行时

python

传输方式

stdio

发布者

yzfly

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "mcp-excel-server": {
      "command": "uv",
      "args": [
        "init",
        "excel-mcp-server"
      ]
    }
  }
}

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is Excel MCP Server?

An MCP server that provides comprehensive Excel file management and data analysis capabilities. It integrates with the Model Context Protocol and is intended for users who need to read, write, analyze, and visualize Excel data programmatically through AI assistants like Claude Desktop.

How to use Excel MCP Server?

Install the server in a Python environment using uv or pip, then integrate it with Claude Desktop by editing the claude_desktop_config.json file to include the uvx mcp-excel-server command. Once configured, you can use the available tools and resources to perform operations on Excel files.

Key features of Excel MCP Server

Read multiple Excel formats (XLSX, XLS, CSV, TSV, JSON)
Write and update Excel files
Generate summary statistics and descriptive analysis
Create pivot tables and filter data
Produce charts (line, bar, scatter, histogram)

Use cases of Excel MCP Server

Analyze a sales_data.xlsx file for patterns
Create a bar chart from product_sales.csv data
Filter employees over age 30 in an employees.xlsx file
Generate a pivot table of department sales

FAQ from Excel MCP Server

What file formats does Excel MCP Server support?

It supports XLSX, XLS, CSV, TSV, and JSON files.

What are the dependencies of Excel MCP Server?

The dependencies are pandas, numpy, matplotlib, and seaborn.

How is Excel MCP Server integrated with Claude Desktop?

You edit the claude_desktop_config.json file to add a server entry with the command uvx and arguments ["mcp-excel-server"], optionally setting the PYTHONPATH environment variable.

What security measures does Excel MCP Server implement?

Files are read only from specified paths, file size is limited, accidental overwriting is prevented, and data transformation operations are strictly controlled.