MCP.Market

xlsx-tools-mcp server

by ruriazz·io.github.ruriazz/xlsx-tools-mcp·v0.3.2·4 stars

MCP server for accurate, structure-preserving read/write access to Excel (.xlsx) files

A92/100grade A
What users say
No reviews yet
Be the first
Safety scan
A92/100

full report

Adoption
Growing

4 stars52 downloads/wk

Reviews

Write one

Nobody 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 posts

Read from the package source without running it. The installed server may list more.

  • aggregate_sheet

    Group and aggregate sheet data with pandas (e.g. sum sales by region).

  • append_rows

    Append rows after the last used row of a sheet, then recalculate the workbook.

  • autofit_columns

    Automatically adjust column widths based on maximum text length.

  • clear_range

    Clear cell values and/or styles within a specified range without deleting rows or columns.

  • copy_sheet

    Duplicate a sheet including its contents, formulas, and styles.

  • create_chartwrite action

    Create a native Excel chart (bar, line, pie, scatter).

  • create_sheetwrite action

    Add a new empty sheet to an existing workbook.

  • create_tablewrite action

    Create a formal Excel Table (ListObject) on the specified range.

  • create_workbookwrite action

    Create a new .xlsx workbook.

  • delete_columnswrite action

    Delete columns, shifting the columns to their right leftward.

  • delete_rowswrite action

    Delete rows, shifting the rows below them upward.

  • delete_sheetwrite action

    Delete a sheet from a workbook. Fails if it is the only sheet left.

  • get_cell

    Get full detail for a single cell: value, formula, number format, font, fill, merge, comment.

  • get_workbook_info

    Get workbook-level metadata: sheets, exact dimensions, active sheet, defined names.

  • insert_columnswrite action

    Insert blank columns, shifting existing columns right.

  • insert_rowswrite action

    Insert blank rows, shifting existing rows down.

  • list_configured_files

    List files preloaded at server startup (via the XLSX_MCP_FILES env var).

  • list_sheets

    List every sheet in a workbook with its approximate row/column counts.

  • merge_cells

    Merge a rectangular range of cells into one.

  • profile_sheet

    Profile sheet data: metadata, inferred types, null counts, min/max, sample values.

  • query_sheet

    Query sheet data using pandas expressions without returning the entire sheet into the LLM context.

  • read_sheet

    Read cell values from a sheet.

  • recalculate_workbook

    Force a LibreOffice headless recalculation pass and report any formula errors found.

  • rename_sheet

    Rename an existing sheet.

  • restore_backup

    Restore a backup file over a target workbook atomically.

  • search_workbook

    Search cell values across one or all sheets for a substring match.

  • set_cell_style

    Apply formatting to a range of cells.

  • unmerge_cells

    Undo a merge on a range of cells.

  • write_cellswrite action

    Write 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

no findings
  • 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
Overall 92/100. Components that don't apply are left out of the denominator. Any critical finding is an F.RubricAppeal a findingJSON

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
Add to Cursor

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 Server
    Create and edit Excel files with AI: charts, PivotTables, formulas. No Excel needed.
    A