Spreadsheet MCP Server (@zephyr-mcp/spreadsheet)
About
A TypeScript-based Model Context Protocol (MCP) server for viewing, filtering, sorting, and updating CSV/XLSX spreadsheet files via LLM or API integration.
Details
- Author
- ZephyrDeng
- GitHub stars
- 11
- Downloads
- 218
- Categories
- Other
Jump to
- View spreadsheet info and preview rows
- Filter rows by column and condition
- Sort rows in ascending or descending order
- Add new sheets to existing XLSX files or create new files
- Supports CSV and XLSX formats
- Returns results as JSON strings containing 2D arrays
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:
- Download and install Highlight from highlightai.com/download
- Navigate to the plugins tab and select "Add Custom Plugin"
-
Configure the plugin with the settings below
Plugin Name
Spreadsheet MCP Server (@zephyr-mcp/spreadsheet)Command (node, npx, python, etc.)Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
Run directly with npx: npx @zephyr-mcp/spreadsheet. Requires Node.js v18+. The server starts in stdio mode and listens for MCP commands.
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"spreadsheet mcp server (@zephyr-mcp/spreadsheet)": {
"spreadsheet-mcp": {
"command": "npx",
"args": [
"@zephyr-mcp/spreadsheet"
]
}
}
}
}McpServers
{
"spreadsheet-mcp": {
"command": "npx",
"args": [
"@zephyr-mcp/spreadsheet"
]
}
}Spreadsheet MCP Server (@zephyr-mcp/spreadsheet)
一个基于 TypeScript 的模型上下文协议 (MCP) 服务器，用于通过 LLM 或 API 集成来查看、筛选、排序和更新 CSV/XLSX 电子表格文件。
功能特性
- 查看电子表格信息并预览行
- 按列和条件筛选行
- 按列排序行 (升序/降序)
- 向现有 XLSX 文件添加新工作表或创建新文件
- 支持 CSV 和 XLSX 文件
- 以包含二维数组的 JSON 字符串形式返回结果 (用于查看/筛选/排序)
- 技术栈：TypeScript, fastmcp, papaparse, xlsx, zod
安装与使用
此包设计为直接使用 npx 运行。典型用法无需安装。
先决条件
- Node.js v18+ (推荐 LTS 版本)
运行 MCP 服务器
在 stdio 模式下启动服务器 (用于与 Cline 等工具集成):
npx @zephyr-mcp/spreadsheet
服务器将启动并通过标准输入/输出监听 MCP 命令。
开发
设置
1. 克隆仓库：
git clone https://github.com/your-username/spreadsheet-mcp.git # 替换为你的仓库 URL
cd spreadsheet-mcp
2. 安装依赖：
npm install
开发模式运行
使用 tsx 进行带热重载的开发：
npm run dev
构建
使用 Vite 将 TypeScript 编译为 JavaScript (输出到 dist/):
npm run build
测试
使用 Vitest 运行测试：
```bash
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
