xlsx-tools-mcp server
io.github.ruriazz/xlsx-tools-mcp·v0.3.2·4 starsMCP server for accurate, structure-preserving read/write access to Excel (.xlsx) files
4 stars52 downloads/wk
Reviews
Write oneNobody has reviewed xlsx-tools-mcp yet.
If you have run it, two minutes of your experience saves the next person an afternoon.
xlsx-tools-mcp tools (29, 10 write)
write = sends, deletes, buys or postsRead from the package source without running it. The installed server may list more.
aggregate_sheetGroup and aggregate sheet data with pandas (e.g. sum sales by region).
append_rowsAppend rows after the last used row of a sheet, then recalculate the workbook.
autofit_columnsAutomatically adjust column widths based on maximum text length.
clear_rangeClear cell values and/or styles within a specified range without deleting rows or columns.
copy_sheetDuplicate a sheet including its contents, formulas, and styles.
create_chartwrite actionCreate a native Excel chart (bar, line, pie, scatter).
create_sheetwrite actionAdd a new empty sheet to an existing workbook.
create_tablewrite actionCreate a formal Excel Table (ListObject) on the specified range.
create_workbookwrite actionCreate a new .xlsx workbook.
delete_columnswrite actionDelete columns, shifting the columns to their right leftward.
delete_rowswrite actionDelete rows, shifting the rows below them upward.
delete_sheetwrite actionDelete a sheet from a workbook. Fails if it is the only sheet left.
get_cellGet full detail for a single cell: value, formula, number format, font, fill, merge, comment.
get_workbook_infoGet workbook-level metadata: sheets, exact dimensions, active sheet, defined names.
insert_columnswrite actionInsert blank columns, shifting existing columns right.
insert_rowswrite actionInsert blank rows, shifting existing rows down.
list_configured_filesList files preloaded at server startup (via the XLSX_MCP_FILES env var).
list_sheetsList every sheet in a workbook with its approximate row/column counts.
merge_cellsMerge a rectangular range of cells into one.
profile_sheetProfile sheet data: metadata, inferred types, null counts, min/max, sample values.
query_sheetQuery sheet data using pandas expressions without returning the entire sheet into the LLM context.
read_sheetRead cell values from a sheet.
recalculate_workbookForce a LibreOffice headless recalculation pass and report any formula errors found.
rename_sheetRename an existing sheet.
restore_backupRestore a backup file over a target workbook atomically.
search_workbookSearch cell values across one or all sheets for a substring match.
set_cell_styleApply formatting to a range of cells.
unmerge_cellsUndo a merge on a range of cells.
write_cellswrite actionWrite values and/or formulas into specific cells, then recalculate the workbook.
Public scan report
scanner v0.1.10 · 2026-11-01 · same rubric, same numbers if you re-run it
- Code scan13 source files scanned25/25
- –Live reliabilityno gateway calls yet and no remote to proben/a
- –Tool poisoningtools not inspected (local package is not executed); not countedn/a
- Auth qualitylocal package, no credentials required12/15
- Maintenancelast push 15 days ago15/15
- Maintainer identityregistry namespace matches repository owner; GitHub account older than a year8/10
How xlsx-tools-mcp compares
Against every graded MCP server, from our own scans and uptime checks. Updated after each scan run.
- Safety score
- 92/100
- higher than 90% of 48,273 servers
- Tools
- 29
- the typical server has 7
- Tools that change things
- 34%
- typical: 0%. Fewer write tools means less an agent can break
- GitHub stars
- 4
- more than 82% of 28,534 servers
- Downloads a week
- 52
- more than 45% of 11,915 servers with a package
What its tools let an agent do: 16 read · 7 create · 3 change · 3 delete
Release history: 4 versions in the registry since 2026-08-23, latest 2026-10-17, typically one every 7 days.
Install xlsx-tools-mcp in Claude Code, Cursor or VS Code
claude mcp add xlsx-tools-mcp -- uvx xlsx-tools-mcp
What the publisher says
From the xlsx-tools-mcp repository's README, as published. We do not edit it. Read it on GitHub
xlsx-tools-mcp
An MCP server for reading and writing Excel (.xlsx) files with high accuracy, while preserving the file's existing structure, styles, and formulas.
<!-- mcp-name: io.github.ruriazz/xlsx-tools-mcp -->
Overview
xlsx-tools-mcp exposes 20 Model Context Protocol (MCP) tools that give an LLM agent accurate, structure-preserving read and write access to Excel .xlsx files. It runs as a standard stdio MCP server: you install it and register it with an MCP client (Claude Code, OpenCode, etc.), and the client's agent can list sheets, read cell ranges, search values, aggregate data, write cells/formulas, manage sheets/rows/columns, apply styles, and force formula recalculation.
It is built around the principle that editing an existing workbook should not destroy what it doesn't touch.
Features
- Structure-preserving writes via openpyxl — writes load the existing workbook and save it back, preserving styles, merged cells, comments, and any aspect the edit doesn't touch.
- Never-stale formula results via LibreOffice recalculation — openpyxl writes formula strings but never evaluates them. After every value/formula write the server runs a headless LibreOffice pass to recompute real results, then returns errors_found — any Excel error values (#REF!, #DIV/0!, #N/A, …) produced by the recalculation.
- Fast reads via python-calamine — a Rust-backed parser for accurate, fast type inference, with an automatic openpyxl fallback when you need formulas/styles/comments or when calamine can't parse the file.
- pandas-based grouping/aggregation — aggregate_sheet groups and aggregates on top of the normal read path, so merged cells and styling in the source range are preserved before flattening.
- Per-file locking — concurrent tool calls (or other processes) touching the same workbook are serialized via a sibling .lock file (filelock), so writes never interleave and corrupt the file.
- XML-bomb protection — the defusedxml package is an automatic dependency; openpyxl detects it and uses its hardened XML parser, so hostile xlsx XML can't expand into resource exhaustion.
- Preload files at startup — set XLSXMCPFILES to preload one or more workbooks; tools can then be called with path omitted or with a short alias instead of a full filesystem path.
Download Stats
Live via pypistats.org, non-mirror downloads. These count download events, not unique users or installs — one user can trigger many downloads (CI, reinstalls, Docker rebuilds, mirrors).
Architecture
Shortened. The full README is on GitHub.
Nothing above is checked by us. What we check is on the safety report.
xlsx-tools-mcp: common questions
- Is xlsx-tools-mcp server safe?
- Yes, by our scan: it is graded A (92/100). Read the xlsx-tools-mcp safety report
- How do I install xlsx-tools-mcp?
- It runs on your machine. Copy the Claude Code, Cursor, VS Code or Claude Desktop config from the install section.
- Does xlsx-tools-mcp need an API key?
- No secret keys are declared. It reads 6 settings from the environment.
- Is xlsx-tools-mcp maintained?
- The last commit was 16 days ago (2026-10-17). The latest release is v0.3.2.
- What can I use instead of xlsx-tools-mcp?
- Servers from other publishers that do the same job: Excel MCP Server.
- How does xlsx-tools-mcp compare with other MCP servers?
- safety score 92/100 (higher than 90% of 48,273 servers); tools 29 (the typical server has 7); tools that change things 34% (typical: 0%. Fewer write tools means less an agent can break). Full comparison.
Alternatives to xlsx-tools-mcp
Same job from other publishers: the closest match first, then the best rated.
- Excel MCP ServerCreate and edit Excel files with AI: charts, PivotTables, formulas. No Excel needed.not reviewedWidely usedA