xlsx-tools-mcp
PYPI · XLSX-TOOLS-MCP
MCP server for accurate, structure-preserving read/write access to Excel (.xlsx) files
Available components
Last scanned (1 day ago)
Scores higher than 78% of PyPI servers
Category Data and Analytics
How this component scores in each security and reliability category. Every signal is checked automatically from public evidence about the published package, including repeated runs of it in an isolated sandbox, and we only credit what we can confirm. How we score → Why this is hard to score →
Supply Chain Security99
- No malware found by supply-chain analysis.Pass
- No known CVEs affecting this package version or its production dependencies.Pass
- Runs hatchling.build at install time, a recognised build step with no custom scripting around it. View diagnostics → Pass
- 4 of 37 dependencies flagged as unhealthy. View diagnostics → Partial
Provenance & Transparency48
- Source repository is publicly reachable at the declared URL. View diagnostics → Pass
- Provenance check failed: no build-provenance attestation is published. See how to fix → View diagnostics → Fail
- Clear OSI-approved license (MIT).Pass
- Actively maintained (last published 18 days ago).Pass
- Publishes a security disclosure policy (SECURITY.md).Pass
Schema Quality & AI Usability66
- AI-judged instruction clarity (good).Pass
- Context-footprint check failed: tool/resource definitions use about 3926 tokens (~135/item across 29 items; 29 tools + 0 resources), over budget; trim descriptions and params. See how to fix → Fail
- Usage-examples check failed: none of the tools include examples. See how to fix → Fail
Stability & Change Management100
- No destabilizing schema changes in the last 30 days.Pass
Tool Coverage71
- 100% of tools have a non-trivial description (not blank, and not just the tool's name).Pass
- 0% of tool parameters carry a description.Fail
- Structured output schemas are declared (100% of tools); any adoption earns full credit.Pass
Tool Safety75
- No prompt-injection markers were found in the server instructions, tool names or descriptions we captured.Pass
- 0 of 4 tool(s) whose name or description implies an irreversible operation declare an MCP destructiveHint annotation; "delete_sheet" implies "delete" and declares no destructiveHint at all, which the MCP spec reads as destructive by default. See how to fix → Fail
- An AI judge read all 30 captured unit(s) of tool text and found none that tries to manipulate the model reading it.Pass
Capabilities100
- Implements a current MCP spec version (2026-07-28).Pass
Every change we have recorded for this component, newest first. Security-relevant changes are always shown. ▲ marks a change for the better, ▼ a change for the worse; unmarked changes are neutral.
- 2 Nov 26 +15
- Malware scan: unverified → pass ▲ security
- 1 Nov 26 −15
- Malware scan: pass → unverified ▼ security
- 30 Oct 26 +15
- Malware scan: unverified → pass ▲ security
- 28 Oct 26 −15
- Malware scan: pass → unverified ▼ security
- 27 Oct 26 +15
- Malware scan: unverified → pass ▲ security
- Stability: 0.97 → pass security
- 26 Oct 26 −15
- Malware scan: pass → unverified ▼ security
- Stability: pass → 0.97 functional
- 25 Oct 26 +15
- Malware scan: unverified → pass ▲ security
- 20 Oct 26 0
- Stability: 0.97 → pass security
Diagnostic detail from the automated scan of this channel: what the scanner observed at each step, so you can see exactly where a check passed or failed. It is informational only and never changes the trust score.
Captured 4 Nov 2026 · Analysed pypi/xlsx-tools-mcp@0.3.2
Provenance No attestation
The registry publishes no build provenance for this version, so there is nothing to verify.
| Result | No attestation |
|---|---|
| Ecosystem | pypi |
| Reason | No attestation published |
Background: How many MCP packages publish verified provenance →
Install scripts 1 script
| Hook | Tier | Command |
|---|---|---|
| build_backend | allowlisted | hatchling.build |
Background: Why install scripts are a supply-chain risk →
Dependencies 37 packages
| Packages resolved | 37 |
|---|---|
| Stale | 3 |
| No linked repository | 1 |
| Tree resolution | Complete |
Background: SBOMs and build attestations, explained →
The tools this component advertises to a client, with an estimated token cost for each. Expand a tool to see its parameters and schema. The per-tool counts are indicative and are not scored directly; the schema's total context footprint is one signal in Schema Quality & AI Usability. A tool's description is untrusted text the model reads on every call, which is what makes this list a security surface and not just an inventory: how tool poisoning works →
aggregate_sheet ~170
Group and aggregate sheet data with pandas (e.g. sum sales by region). Args: path: Path to the .xlsx file, or the name of a preloaded file. Omit if only one file is configured. sheet: Sheet name. group_by: Column names to group by (taken from the header row). agg: Mapping of column name to aggregation function, e.g. {"amount": "sum"}. cell_range: Optional A1-style range to read before aggregating. has_header: Whether the first row of the range holds column names.
| Name | Type | Req | Description |
|---|---|---|---|
| agg | object | yes | – |
| cell_range | – | – | – |
| group_by | array | yes | – |
| has_header | boolean | – | – |
| path | – | – | – |
| sheet | string | yes | – |
Structured output declared, but exposes no named fields.
No examples provided.
append_rows ~193
Append rows after the last used row of a sheet, then recalculate the workbook. Set `recalculate=False` to skip the LibreOffice recompute (e.g. for structurally complex workbooks you don't want round-tripped). Args: path: Path to the .xlsx file, or the name of a preloaded file. Omit if only one file is configured. sheet: Sheet name. rows: List of rows, each a list of cell values in column order. create_sheet_if_missing: Create the sheet first if it doesn't exist yet. recalculate: Run the LibreOffice recompute pass after saving.
| Name | Type | Req | Description |
|---|---|---|---|
| allow_external_formulas | boolean | – | – |
| backup | – | – | – |
| create_sheet_if_missing | boolean | – | – |
| path | – | – | – |
| recalculate | boolean | – | – |
| rows | array | yes | – |
| sheet | string | yes | – |
Structured output declared, but exposes no named fields.
No examples provided.
autofit_columns ~127
Automatically adjust column widths based on maximum text length. Args: path: Path to the .xlsx file, or the name of a preloaded file. Omit if only one file is configured. sheet: Sheet name. min_width: Minimum allowed column width. max_width: Maximum allowed column width. padding: Extra padding characters to add to max length.
| Name | Type | Req | Description |
|---|---|---|---|
| backup | – | – | – |
| max_width | integer | – | – |
| min_width | integer | – | – |
| padding | integer | – | – |
| path | – | – | – |
| sheet | string | yes | – |
Structured output declared, but exposes no named fields.
No examples provided.
clear_range ~154
Clear cell values and/or styles within a specified range without deleting rows or columns. Args: path: Path to the .xlsx file, or the name of a preloaded file. Omit if only one file is configured. sheet: Sheet name. cell_range: A1-style range (e.g. "A1:D10") to clear. clear_values: Whether to clear cell values (True by default). clear_styles: Whether to clear cell styles/formats (False by default).
| Name | Type | Req | Description |
|---|---|---|---|
| backup | – | – | – |
| cell_range | string | yes | – |
| clear_styles | boolean | – | – |
| clear_values | boolean | – | – |
| path | – | – | – |
| sheet | string | yes | – |
Structured output declared, but exposes no named fields.
No examples provided.
copy_sheet ~109
Duplicate a sheet including its contents, formulas, and styles. Args: path: Path to the .xlsx file, or the name of a preloaded file. Omit if only one file is configured. source_sheet: Name of the sheet to duplicate. target_sheet: Name of the new sheet (1-31 chars, valid Excel sheet name).
| Name | Type | Req | Description |
|---|---|---|---|
| backup | – | – | – |
| path | – | – | – |
| source_sheet | string | yes | – |
| target_sheet | string | yes | – |
Structured output declared, but exposes no named fields.
No examples provided.
create_chart ~218
Create a native Excel chart (bar, line, pie, scatter). Args: path: Path to the .xlsx file, or the name of a preloaded file. Omit if only one file is configured. sheet: Sheet name. chart_type: One of "bar", "line", "pie", "scatter". data_range: A1-style range holding the chart series values (e.g. "B1:B10"). categories_range: Optional A1-style range holding series category labels (e.g. "A2:A10"). title: Title string displayed on the chart. target_cell: Cell coordinate where the top-left corner of the chart is placed. backup: Whether to create a backup before modifying the workbook.
| Name | Type | Req | Description |
|---|---|---|---|
| backup | – | – | – |
| categories_range | – | – | – |
| chart_type | string | yes | – |
| data_range | string | yes | – |
| path | – | – | – |
| sheet | string | yes | – |
| target_cell | string | – | – |
| title | string | – | – |
Structured output declared, but exposes no named fields.
No examples provided.
create_sheet ~98
Add a new empty sheet to an existing workbook. Args: path: Path to the .xlsx file, or the name of a preloaded file. Omit if only one file is configured. sheet: Name for the new sheet. index: Zero-based position to insert at; omit to append at the end.
| Name | Type | Req | Description |
|---|---|---|---|
| backup | – | – | – |
| index | – | – | – |
| path | – | – | – |
| sheet | string | yes | – |
Structured output declared, but exposes no named fields.
No examples provided.
create_table ~203
Create a formal Excel Table (ListObject) on the specified range. Args: path: Path to the .xlsx file, or the name of a preloaded file. Omit if only one file is configured. sheet: Sheet name. cell_range: A1-style range (e.g. "A1:D10"). table_name: Unique table identifier across the workbook. style_name: Table style name (e.g. "TableStyleMedium9"). show_filter: Whether to display auto-filter dropdown arrows. show_row_stripes: Whether to apply alternating row shading. backup: Whether to create a backup before modifying the workbook.
| Name | Type | Req | Description |
|---|---|---|---|
| backup | – | – | – |
| cell_range | string | yes | – |
| path | – | – | – |
| sheet | string | yes | – |
| show_filter | boolean | – | – |
| show_row_stripes | boolean | – | – |
| style_name | string | – | – |
| table_name | string | yes | – |
Structured output declared, but exposes no named fields.
No examples provided.
create_workbook ~88
Create a new .xlsx workbook. Args: path: Path for the new file. New files aren't preloaded, so this must be a real path. sheets: Sheet names to create (defaults to a single "Sheet1"). overwrite: Replace an existing file at path when True.
| Name | Type | Req | Description |
|---|---|---|---|
| overwrite | boolean | – | – |
| path | string | yes | – |
| sheets | – | – | – |
Structured output declared, but exposes no named fields.
No examples provided.
delete_columns ~166
Delete columns, shifting the columns to their right leftward. Set `recalculate=False` to skip the LibreOffice recompute (e.g. for structurally complex workbooks you don't want round-tripped). Args: path: Path to the .xlsx file, or the name of a preloaded file. Omit if only one file is configured. sheet: Sheet name. start_column: 1-based column index to start deleting from. count: Number of columns to delete. recalculate: Run the LibreOffice recompute pass after saving.
| Name | Type | Req | Description |
|---|---|---|---|
| backup | – | – | – |
| count | integer | – | – |
| path | – | – | – |
| recalculate | boolean | – | – |
| sheet | string | yes | – |
| start_column | integer | yes | – |
Structured output declared, but exposes no named fields.
No examples provided.
delete_rows ~164
Delete rows, shifting the rows below them upward. Set `recalculate=False` to skip the LibreOffice recompute (e.g. for structurally complex workbooks you don't want round-tripped). Args: path: Path to the .xlsx file, or the name of a preloaded file. Omit if only one file is configured. sheet: Sheet name. start_row: 1-based row index to start deleting from. count: Number of rows to delete. recalculate: Run the LibreOffice recompute pass after saving.
| Name | Type | Req | Description |
|---|---|---|---|
| backup | – | – | – |
| count | integer | – | – |
| path | – | – | – |
| recalculate | boolean | – | – |
| sheet | string | yes | – |
| start_row | integer | yes | – |
Structured output declared, but exposes no named fields.
No examples provided.
delete_sheet ~82
Delete a sheet from a workbook. Fails if it is the only sheet left. Args: path: Path to the .xlsx file, or the name of a preloaded file. Omit if only one file is configured. sheet: Sheet name to delete.
| Name | Type | Req | Description |
|---|---|---|---|
| backup | – | – | – |
| path | – | – | – |
| sheet | string | yes | – |
Structured output declared, but exposes no named fields.
No examples provided.
get_cell ~101
Get full detail for a single cell: value, formula, number format, font, fill, merge, comment. Args: path: Path to the .xlsx file, or the name of a preloaded file. Omit if only one file is configured. sheet: Sheet name. cell: Cell reference, e.g. "C5".
| Name | Type | Req | Description |
|---|---|---|---|
| cell | string | yes | – |
| path | – | – | – |
| sheet | string | yes | – |
Structured output declared, but exposes no named fields.
No examples provided.
get_workbook_info ~63
Get workbook-level metadata: sheets, exact dimensions, active sheet, defined names. Args: path: Path to the .xlsx file, or the name of a preloaded file. Omit if only one file is configured.
| Name | Type | Req | Description |
|---|---|---|---|
| path | – | – | – |
Structured output declared, but exposes no named fields.
No examples provided.
insert_columns ~162
Insert blank columns, shifting existing columns right. Set `recalculate=False` to skip the LibreOffice recompute (e.g. for structurally complex workbooks you don't want round-tripped). Args: path: Path to the .xlsx file, or the name of a preloaded file. Omit if only one file is configured. sheet: Sheet name. start_column: 1-based column index to insert before. count: Number of columns to insert. recalculate: Run the LibreOffice recompute pass after saving.
| Name | Type | Req | Description |
|---|---|---|---|
| backup | – | – | – |
| count | integer | – | – |
| path | – | – | – |
| recalculate | boolean | – | – |
| sheet | string | yes | – |
| start_column | integer | yes | – |
Structured output declared, but exposes no named fields.
No examples provided.
insert_rows ~162
Insert blank rows, shifting existing rows down. Set `recalculate=False` to skip the LibreOffice recompute (e.g. for structurally complex workbooks you don't want round-tripped). Args: path: Path to the .xlsx file, or the name of a preloaded file. Omit if only one file is configured. sheet: Sheet name. start_row: 1-based row index to insert before. count: Number of rows to insert. recalculate: Run the LibreOffice recompute pass after saving.
| Name | Type | Req | Description |
|---|---|---|---|
| backup | – | – | – |
| count | integer | – | – |
| path | – | – | – |
| recalculate | boolean | – | – |
| sheet | string | yes | – |
| start_row | integer | yes | – |
Structured output declared, but exposes no named fields.
No examples provided.
list_configured_files ~66
List files preloaded at server startup (via the XLSX_MCP_FILES env var). Call this first if unsure which files are available — every other tool's `path` argument accepts these names directly (or can be omitted if only one is configured), no filesystem search needed.
Input schema present but exposes no named parameters.
Structured output declared, but exposes no named fields.
No examples provided.
list_sheets ~60
List every sheet in a workbook with its approximate row/column counts. Args: path: Path to the .xlsx file, or the name of a preloaded file. Omit if only one file is configured.
| Name | Type | Req | Description |
|---|---|---|---|
| path | – | – | – |
| Name | Type | Req | Description |
|---|---|---|---|
| result | array | yes | – |
No examples provided.
merge_cells ~98
Merge a rectangular range of cells into one. Args: path: Path to the .xlsx file, or the name of a preloaded file. Omit if only one file is configured. sheet: Sheet name. cell_range: A1-style range, e.g. "A1:C1".
| Name | Type | Req | Description |
|---|---|---|---|
| backup | – | – | – |
| cell_range | string | yes | – |
| path | – | – | – |
| sheet | string | yes | – |
Structured output declared, but exposes no named fields.
No examples provided.
profile_sheet ~99
Profile sheet data: metadata, inferred types, null counts, min/max, sample values. Args: path: Path to the .xlsx file, or the name of a preloaded file. Omit if only one file is configured. sheet: Sheet name. sample_rows: Number of non-null sample values to return per column.
| Name | Type | Req | Description |
|---|---|---|---|
| path | – | – | – |
| sample_rows | integer | – | – |
| sheet | string | yes | – |
Structured output declared, but exposes no named fields.
No examples provided.
query_sheet ~162
Query sheet data using pandas expressions without returning the entire sheet into the LLM context. Args: path: Path to the .xlsx file, or the name of a preloaded file. Omit if only one file is configured. sheet: Sheet name. filter_query: Pandas query expression (e.g. "status == 'PAID' and amount > 500"). columns: Optional list of columns to return. max_rows: Maximum rows to return (default 100). cell_range: Optional range to restrict reading before querying.
| Name | Type | Req | Description |
|---|---|---|---|
| cell_range | – | – | – |
| columns | – | – | – |
| filter_query | string | yes | – |
| max_rows | integer | – | – |
| path | – | – | – |
| sheet | string | yes | – |
Structured output declared, but exposes no named fields.
No examples provided.
read_sheet ~195
Read cell values from a sheet. Args: path: Path to the .xlsx file, or the name of a preloaded file. Omit if only one file is configured. sheet: Sheet name. cell_range: Optional A1-style range (e.g. "B2:F20"). Omit to read the full used area. max_rows: Optional cap on the number of rows returned, to bound response size for large sheets. offset_row: Skip a number of data rows (0-indexed from first data row). format: "array" (default 2D list), "records" (list of dicts, first row as keys), or "markdown" (table string).
| Name | Type | Req | Description |
|---|---|---|---|
| cell_range | – | – | – |
| format | string | – | – |
| max_rows | – | – | – |
| offset_row | integer | – | – |
| path | – | – | – |
| sheet | string | yes | – |
Structured output declared, but exposes no named fields.
No examples provided.
recalculate_workbook ~63
Force a LibreOffice headless recalculation pass and report any formula errors found. Args: path: Path to the .xlsx file, or the name of a preloaded file. Omit if only one file is configured.
| Name | Type | Req | Description |
|---|---|---|---|
| path | – | – | – |
Structured output declared, but exposes no named fields.
No examples provided.
rename_sheet ~126
Rename an existing sheet. Warning: This tool does NOT automatically update formula references in other sheets. Formulas depending on the old sheet name will break. Args: path: Path to the .xlsx file, or the name of a preloaded file. Omit if only one file is configured. old_name: Current name of the sheet. new_name: New name for the sheet (1-31 chars, valid Excel sheet name).
| Name | Type | Req | Description |
|---|---|---|---|
| backup | – | – | – |
| new_name | string | yes | – |
| old_name | string | yes | – |
| path | – | – | – |
Structured output declared, but exposes no named fields.
No examples provided.
restore_backup ~68
Restore a backup file over a target workbook atomically. Args: backup_path: Path to the .bak file to restore from. target_path: Path to the target .xlsx/.xlsm file to overwrite.
| Name | Type | Req | Description |
|---|---|---|---|
| backup_path | string | yes | – |
| target_path | string | yes | – |
Structured output declared, but exposes no named fields.
No examples provided.
search_workbook ~140
Search cell values across one or all sheets for a substring match. Args: path: Path to the .xlsx file, or the name of a preloaded file. Omit if only one file is configured. query: Substring to search for. sheet: Restrict the search to one sheet; omit to search every sheet. match_case: Case-sensitive match when True. limit: Optional cap on the number of matches returned, to bound response size for large sheets.
| Name | Type | Req | Description |
|---|---|---|---|
| limit | – | – | – |
| match_case | boolean | – | – |
| path | – | – | – |
| query | string | yes | – |
| sheet | – | – | – |
| Name | Type | Req | Description |
|---|---|---|---|
| result | array | yes | – |
No examples provided.
set_cell_style ~172
Apply formatting to a range of cells. Args: path: Path to the .xlsx file, or the name of a preloaded file. Omit if only one file is configured. sheet: Sheet name. cell_range: A1-style range, e.g. "A1:D1". style: Keys among: bold, italic, font_size, font_color (hex RGB, e.g. "FF0000"), bg_color (hex RGB), horizontal, vertical (alignment), border ("thin", "medium", "thick", ...), number_format (e.g. "#,##0.00").
| Name | Type | Req | Description |
|---|---|---|---|
| backup | – | – | – |
| cell_range | string | yes | – |
| path | – | – | – |
| sheet | string | yes | – |
| style | object | yes | – |
Structured output declared, but exposes no named fields.
No examples provided.
unmerge_cells ~94
Undo a merge on a range of cells. Args: path: Path to the .xlsx file, or the name of a preloaded file. Omit if only one file is configured. sheet: Sheet name. cell_range: A1-style range that was previously merged.
| Name | Type | Req | Description |
|---|---|---|---|
| backup | – | – | – |
| cell_range | string | yes | – |
| path | – | – | – |
| sheet | string | yes | – |
Structured output declared, but exposes no named fields.
No examples provided.
write_cells ~229
Write values and/or formulas into specific cells, then recalculate the workbook. Set `recalculate=False` to skip the LibreOffice recompute (e.g. for structurally complex workbooks you don't want round-tripped). Args: path: Path to the .xlsx file, or the name of a preloaded file. Omit if only one file is configured. sheet: Sheet name. cells: List of {"cell": "A1", "value": ...} or {"cell": "B1", "formula": "=A1*2"}. create_sheet_if_missing: Create the sheet first if it doesn't exist yet. recalculate: Run the LibreOffice recompute pass after saving. Returns: Write result including `errors_found` — any Excel error values produced by recalculation.
| Name | Type | Req | Description |
|---|---|---|---|
| allow_external_formulas | boolean | – | – |
| backup | – | – | – |
| cells | array | yes | – |
| create_sheet_if_missing | boolean | – | – |
| path | – | – | – |
| recalculate | boolean | – | – |
| sheet | string | yes | – |
Structured output declared, but exposes no named fields.
No examples provided.
How do I install the xlsx-tools-mcp server?
xlsx-tools-mcp runs locally as a PyPI package, launched with uvx xlsx-tools-mcp. Ready-made configuration for Claude, Cursor, VS Code, Codex and 5 more is on this page, copied from each client's own documentation.
pypi · xlsx-tools-mcp
claude mcp add ruriazz-xlsx-tools-mcp -- uvx xlsx-tools-mcp
What is the xlsx-tools-mcp server?
xlsx-tools-mcp is listed in the public MCP registry as io.github.ruriazz/xlsx-tools-mcp. MCP server for accurate, structure-preserving read/write access to Excel (.xlsx) files. This page covers its PyPI package (xlsx-tools-mcp).
Is the xlsx-tools-mcp server safe to use?
xlsx-tools-mcp scores 79 out of 100 on VerifyMCP. We found no known CVEs affecting it as of 4 November 2026. That is a record of what we were able to check automatically, not an endorsement. The category breakdown on this page shows every signal behind the number, including the ones we could not confirm.
What tools does the xlsx-tools-mcp server expose?
xlsx-tools-mcp exposes 29 tools: restore_backup, list_configured_files, list_sheets, get_workbook_info, read_sheet, and 24 more. Their descriptions and schemas cost roughly 3,832 tokens of context every time the server is loaded.
Is the xlsx-tools-mcp server still maintained?
xlsx-tools-mcp is still listed as active in the MCP registry. We last reached this channel on 4 November 2026. Those dates come from our own scans of the registry and the channel itself, not from anything the publisher announced.
What licence is the xlsx-tools-mcp server under?
xlsx-tools-mcp declares the MIT licence, which is OSI-approved. That covers the source only, and says nothing about the cost of any service it calls.