About mcp-excel-server
mcp-excel-server uses Spring AI MCP to let LLMs read and write local Excel files. It returns data from .xlsx and .xls files as JSON and can write JSON data to workbooks.
Key features
- 01Read .xlsx and .xls files
- 02Return spreadsheet content as JSON
- 03Write JSON data to Excel files
Use cases
- 01Extract local workbook content for LLM processing
- 02Update a local workbook from JSON data
MCP support
This MCP server provides compatible clients with tools for reading and writing local Excel files. The README names Claude, Cursor, and Cherry Studio as supported clients.
Configuration
Local server config is the same for every client. Copy it into your client’s MCP config file.
We haven’t collected a package or remote endpoint for this server. Follow the instructions in the project README.
Tools
Local servers expose tools only once running on your machine, and the maintainer has not provided a tool list.
Details
From the project READMEmcp-excel-server
项目概述
mcp-excel-server 是一个基于 Spring AI MCP 框架开发的项目,其主要功能是借助 MCP 协议,为大语言模型(LLM)提供对本地 Excel 文件进行读取和写入操作的能力。通过本项目,AI 能够像人类一样调用本地工具,突破静态知识库的限制,实现动态交互。
功能特性
-
Excel 文件读取:能够读取本地 Excel 文件(支持 .xlsx 和 .xls 格式),并将内容以 JSON 格式返回。
-
Excel 文件写入:可以把 JSON 数据写入到指定的本地 Excel 文件中。 与 LLM 集成:可与支持 MCP 协议的 LLM 客户端集成,如 Claude、Cursor 和 Cherry Studio 等。
环境要求
Java 17 及以上
安装与配置
第一步:执行下列命令打包:
mvn clean package -Dmaven.test.skip=true
第二步:配置MCP Server
{
"mcpServers": {
"AUM5itYnoMcxPiU2vFa3Z": {
"name": "Excel操作",
"type": "stdio",
"description": "",
"isActive": true,
"command": "java",
"args": [
"-Dspring.ai.mcp.server.stdio=true",
"-Dspring.main.web-application-type=none",
"-Dfile.encoding=UTF-8",
"-jar",
"{your_path}/mcp-excel-server-0.0.1-SNAPSHOT.jar"
]
}
}
}
功能演示
order.xlsx:
生成的结果:

Comments
New to MCP?
From what the protocol is to installing your first server, these answers cover most first questions.
An open protocol that defines how AI applications connect to external tools and data in a uniform way. Clients talk to the model; MCP servers provide tools, resources and prompt templates. They exchange standard messages, so one server can be reused by many clients.