Excel Mcp

by choco9527

467 downloads
Not rated
GitHub

About

> `excel-mcp` is a command-line service based on the [Model Context Protocol (MCP)](https://modelcontextprotocol.io/). It supports reading local Excel (`.xlsx`) and CSV (`.csv`) files, and integrates with interactive tools or AI assistants via the MCP protocol.

Details

Author
choco9527
Downloads
467
Categories
Other

- Reads local .xlsx files
- Parses all worksheets in a workbook
- Extracts header row (first row) of each sheet
- Displays the first 10 rows of data per sheet
- Interactive calls through the MCP protocol

Setting up with Highlight

This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:

  1. Download and install Highlight from highlightai.com/download
  2. Navigate to the plugins tab and select "Add Custom Plugin"
  3. Configure the plugin with the settings below
    Plugin Name Excel Mcp
    Command (node, npx, python, etc.)

    Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.

  4. Enable "Start Automatically" if you want the plugin to start when Highlight launches

From the repository

Install dependencies with npm install, build the project with npm run build, then start the server by running ./build/index.js. The server listens for requests over stdio. Alternatively, configure it in your MCP client using the npx command shown in the README.

read_excel

读取并理解一个 Excel 或 CSV 文件(包含表名/文件名、表头和前 10 行数据)

Claude Desktop / Cursor

Paste into your MCP client config file to install this server.

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

McpServers

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

📊 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 文件。

输入参数:

| 参数名 | 类型 | 描述 |
| ---------- | ------ | -------------------- |
|
filePath` | string | Excel 文件的完整路径(.xlsx) |

返回内容:

所有工作表名称;
每个 Sheet 的表头(第一行);

  • 每个 Sheet 的前 10 行数据(按行格式化展示);


示例请求:

// {
//   "tool": "read_excel",
//   "input": {
//     "filePath": "/absolute/path/to/example.xlsx"
//   }
// }

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

No reviews yet — be the first

Sign in to leave a review

Use Google, GitHub, or an email account so ratings stay tied to real people.

Email sign in

No reviews posted yet.