Summary
A spreadsheet deliverable gets produced rather than described.
validate_formula_syntax before apply_formula means a formula is checked before it lands in a cell, and read_data_from_excel returns validation rules alongside the values, so an agent editing somebody else's model can see what that model expects. The file on disk is the artifact — there is no import or export step around it.
What it is
Workbook editing over a file path: worksheets created, copied, renamed and deleted; ranges read, written, merged, copied and deleted; formulas validated and then applied; and charts, native tables and pivot tables created in place.
What you get
- A workbook created, its metadata read — sheets and ranges — and worksheets added, copied, renamed or removed
- Data read from a range with cell metadata including validation rules, and written from a starting cell as rows
- Formula syntax validated first, then applied to a cell and verified on write
- Formatting across a range: bold, font and background colour, alignment, borders and conditional formatting
- Charts created from a data range with a title and axis labels, native Excel tables with a style, and pivot tables with rows, columns, values and an aggregation function
- Structural edits: rows and columns inserted or deleted, cells merged and unmerged, ranges copied between sheets, and a range validated before you act on it
Requirements
Uvx on your PATH and the path to the workbook — every call takes the file path, and the sheet name wherever the sheet matters.
Setup effort
One command — uvx excel-mcp-server stdio