mcp-excel
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||
Instructions
Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.
This server publishes no instructions, or was last inspected before Glama recorded them.
Capabilities
Features and capabilities supported by this server
Protocol revision2025-11-25
| Capability | Details |
|---|---|
| tools | {
"listChanged": true
} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| create_workbookA | 从无到有新建一个 .xlsx 文件。可指定初始工作表名列表。文件已存在时会失败（防误覆盖），不会清空已有文件。 |
| list_sheetsA | 查看一个 Excel 文件里有哪些工作表，各有多少行多少列。动手读/写之前可以先调它确认表名。 |
| add_sheetB | 在已有文件中追加一张空工作表。 |
| delete_sheetA | 删除指定工作表。不能删除最后一张。 |
| rename_sheetB | 修改工作表名称。 |
| read_rangeA | 读取一张工作表的内容，返回二维数组。不传 range 则读整张表；表很大时建议先传 range 读一部分（如前 50 行）了解结构。空单元格为 null，日期为 ISO 字符串。 |
| write_rangeA | 从 startCell 开始写入一个二维数组（先行后列）。一个格子就传 |
| set_formulaA | 在指定单元格写入 Excel 公式，如 |
| format_cellsA | 设置一个区域的字体、填充色、边框、对齐、数字格式，让表格好看。只传想改的项，没传的不动。csv 文件不支持样式。 |
| merge_cellsB | 把一个矩形区域合并成一个单元格，内容保留左上角的值。常用于标题行。 |
| set_dimensionsA | 设置工作表的列宽和/或行高，让表格排版合适。列宽单位是字符数（Excel 默认约 8.43），行高单位是磅（默认约 15）。columns 和 rows 至少传一个。csv 不支持。 |
| sort_rangeA | 对一个区域按某列排序（会修改文件）。区域外的内容不动。有表头时传 hasHeader: true 并用表头名指定列更稳妥。 |
| filter_rangeB | 按条件筛选区域中的行并返回结果，不修改文件。多个条件为'并且'关系。 |
| dedupe_rangeA | 删除区域内 keyColumns 完全相同的重复行，只保留第一次出现的行（会修改文件）。被删的行变为空白行，区域外的内容不会被移动。 |
| insert_imageA | 把一张本地图片（png / jpg / gif）插入工作表，图片左上角锚定在 anchorCell。width/height 为像素，不传给默认 300×200——比例不对时请显式传这两个值。csv 不支持插图。 |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
TDQS
Scored across 15 tools
Most tools target clearly distinct operations: sheet management (list/add/delete/rename), data reading/writing (read_range/write_range), and formatting/structural operations (format/merge/dimensions). One minor ambiguity: sort_range, filter_range, and dedupe_range all operate on ranges and could occasionally be confused, though their purposes are distinct enough.
Tool names follow a consistent verb_noun pattern throughout: list_sheets, add_sheet, delete_sheet, rename_sheet, read_range, write_range, set_formula, create_workbook, format_cells, merge_cells, set_dimensions, sort_range, filter_range, dedupe_range, insert_image. The naming is uniform and predictable.
15 tools is a well-scoped count for an Excel manipulation server. Each tool covers a discrete capability—sheet lifecycle, cell operations, formatting, data transforms, and image insertion—and all earn their place without bloat.
The surface covers core spreadsheet operations comprehensively: workbook creation, sheet CRUD, cell read/write, formulas, formatting, merging, dimensions, sorting, filtering, deduping, and images. Minor gaps include copy/cut/paste operations and number-format-specific quick helpers, but agents can work around these via the format_cells and range tools.