Excel MCP Server
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": false
} |
| prompts | {
"listChanged": false
} |
| resources | {
"subscribe": false,
"listChanged": false
} |
| experimental | {} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| apply_formulaC | Apply Excel formula to cell. Excel formula will write to cell with verification. |
| validate_formula_syntaxB | Validate Excel formula syntax without applying it. |
| format_rangeC | Apply formatting to a range of cells. |
| read_data_from_excelA | |
| write_data_to_excelB | |
| create_workbookC | Create new Excel workbook. |
| create_worksheetC | Create new worksheet in workbook. |
| create_chartC | Create chart in worksheet. |
| create_pivot_tableC | Create pivot table in worksheet. |
| create_tableB | Creates a native Excel table from a specified range of data. |
| copy_worksheetC | Copy worksheet within workbook. |
| delete_worksheetC | Delete worksheet from workbook. |
| rename_worksheetC | Rename worksheet in workbook. |
| get_workbook_metadataC | Get metadata about workbook including sheets, ranges, etc. |
| merge_cellsC | Merge a range of cells. |
| unmerge_cellsC | Unmerge a range of cells. |
| get_merged_cellsB | Get merged cells in a worksheet. |
| copy_rangeC | Copy a range of cells to another location. |
| delete_rangeB | Delete a range of cells and shift remaining cells. |
| validate_excel_rangeC | Validate if a range exists and is properly formatted. |
| get_data_validation_infoA | |
| insert_rowsB | Insert one or more rows starting at the specified row. |
| insert_columnsB | Insert one or more columns starting at the specified column. |
| delete_sheet_rowsC | Delete one or more rows starting at the specified row. |
| delete_sheet_columnsB | Delete one or more columns starting at the specified column. |
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 25 tools
Most tools target distinct Excel operations, but slight overlap exists between 'apply_formula' and 'write_data_to_excel' as both write to cells, though descriptions clarify their specific purposes.
All tool names follow a consistent verb_noun pattern in snake_case, e.g., create_workbook, delete_worksheet, merge_cells, with no deviations.
25 tools is at the upper end of the 'reasonable' range for an Excel server, covering many core operations without being excessive.
The tool set covers essential Excel operations like workbook/worksheet management, data reading/writing, formatting, formulas, charts, pivot tables, and tables, though advanced features like sorting or filtering are missing.