mcpField
E
Excel Mcp

Excel Mcp

Local
github.com/choco9527Data & Analytics1Updated 75w ago

About Excel Mcp

Excel Mcp is an MCP service for interactive tools and AI assistants to read local Excel files. It reports worksheets, headers, and the first 10 rows of each sheet.

Key features

  1. 01Read local .xlsx files
  2. 02Parse all worksheets
  3. 03Extract headers
  4. 04Show the first 10 rows per sheet

Use cases

  1. 01Inspect workbook contents through an interactive tool
  2. 02Let an AI assistant read sheet structure and sample rows

MCP support

The MCP service receives requests over stdio and exposes the read_excel tool for reading an Excel file at a specified path.

Configuration

Local server config is the same for every client. Copy it into your client’s MCP config file.

mcp.json · Universal config
{
"mcpServers": {
"excel": {
"command": "npx",
"args": [
"-y",
"excel-mcp"
]
}
}
}
Run commandnpx -y excel-mcp

Local servers need a runtime on your machine (e.g. Node.js 18+). Config file locations differ by client; see your client’s docs.

Packages
npmexcel-mcp

Tools

1

Saved tool list · updated 3w ago

ParameterTypeRequiredDescription
filePathstringYesPath to the .xlsx or .csv file
sheetNamestringNoExcel worksheet name; defaults to the first worksheet

Details

From the project README

📊 excel-mcp

excel-mcp 是一个基于 Model Context Protocol (MCP) 的服务器,使用 TypeScript 编写,具备读取 Excel 文件(.xlsx 格式)的功能,并通过 MCP 协议对接交互式工具。


✨ 功能特点

  • 📁 支持读取本地 .xlsx 文件;
  • 📑 解析 Excel 中的所有工作表(Sheet);
  • 🧾 提取每个表的表头信息;
  • 🔍 展示每个表前 10 行数据;
  • 🤖 可通过 MCP 协议进行交互式调用。

🚀 快速开始

1. 安装依赖
npm install
2. 构建项目
npm run build
3. 启动 MCP Server
./build/index.js

MCP Server 会通过标准输入/输出(stdio)监听来自 Model Context 的请求。


🛠 可用工具

read_excel

读取并理解指定路径下的 Excel 文件。

输入参数:
参数名类型描述
filePathstringExcel 文件的完整路径(.xlsx)
返回内容:
  • 所有工作表名称;
  • 每个 Sheet 的表头(第一行);
  • 每个 Sheet 的前 10 行数据(按行格式化展示);
示例请求:
// {
//   "tool": "read_excel",
//   "input": {
//     "filePath": "/absolute/path/to/example.xlsx"
//   }
// }

示例:
{
  "mcpServers": {
    "excel-mcp": {
      "command": "npx",
      "args": [
        "excel-mcp"
      ]
    }
  }
}

Comments

Markdown supported

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.