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 | {} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| get_excel_infoB | Get Excel running status, open workbooks, and their sheets. |
| read_cellsA | Read cell formulas/values from a range. By default returns formulas where they exist. Use "workbook" for an open Excel workbook, or "path" for a .xlsx file on disk (no Excel needed, preserves images/charts). Set valuesOnly=true to get calculated values instead of formulas. Set formats=true to include formatting details. |
| write_cellsA | Write values to a cell or range. Use "workbook" for live Excel, or "path" for a .xlsx file on disk (no Excel needed, preserves images/charts). Accepts a single value, a flat array, or a 2D array. |
| format_cellsA | Apply formatting to cells. Use "workbook" for live Excel, or "path" for a .xlsx file on disk (no Excel needed, preserves images/charts). Options: bold, italic, underline, fontSize, fontName, fontColor, backgroundColor, textAlign (left/center/right), verticalAlign (top/middle/bottom), numberFormat, wrapText, borders ({top/bottom/left/right/inside/outside: {style, color}}). |
| execute_vbaA | Execute VBA code in an open workbook (live Excel only, cannot use with closed files). Code is wrapped in a Sub automatically if needed. MsgBox calls are stripped. Temp modules are cleaned up after execution. |
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 5 tools
Each tool has a clearly distinct purpose with no overlap: execute_vba runs code, format_cells applies styling, get_excel_info retrieves metadata, read_cells extracts data, and write_cells inserts data. The descriptions explicitly differentiate between live Excel and file-based operations where applicable, eliminating ambiguity.
All tool names follow a consistent verb_noun pattern (execute_vba, format_cells, get_excel_info, read_cells, write_cells) with clear, descriptive verbs. There are no deviations in style or convention, making the set predictable and easy to understand.
With 5 tools, this server is well-scoped for basic Excel operations, covering execution, formatting, information retrieval, reading, and writing. Each tool earns its place without redundancy, and the count is appropriate for the domain, avoiding both excessive complexity and oversimplification.
The toolset provides solid coverage for core Excel workflows, including CRUD-like operations (read/write), formatting, and automation (VBA). Minor gaps exist, such as no explicit tools for managing sheets (e.g., create/delete sheets) or advanced features like charts, but agents can likely work around these with the available tools.