Skip to main content

mcp-win-stdio-excel

Windows-native Model Context Protocol (MCP) server for Microsoft Excel: 44 tools combining high-speed Pandas querying, OpenPyXL bulk write & editing, native Excel Tables (ListObject), column/row structural mutations, cell merging, professional styling & conditional formatting, charts, data cleaning, transformations, RapidFuzz reconciliation, diff auditor, and native Windows Excel COM automation.

Part of the mcp-win-stdio Windows-optimized suite.


🚀 Features (44 Tools)

  • Native Excel Tables (ListObject): Create named, styled tables (create_table) with auto-filters and list all tables across sheets (list_tables).
  • Structural Row & Column Mutations: Insert/delete columns with dynamic formula templates (insert_column, delete_column), insert/delete rows (insert_rows, delete_rows), and merge cell ranges (merge_cells).
  • Deterministic Workbook Diffing: Compare two workbooks cell-by-cell or key-aligned with numeric tolerance (diff_workbooks).
  • Vectorized Data Queries: High-speed Pandas slicing, filtering, and aggregation on large spreadsheets (query_rows, query_excel_sql).
  • Bulk 2D Matrix Writing: High-efficiency table writes (write_range) with automatic leftover row cleanup (clear_subsequent_rows=True).
  • Professional Cell Styling & Layout: Apply fonts, hex colors, fills, borders, text wrapping, and currency/percent/date formats (format_cells).
  • Dynamic Conditional Formatting: Highlight threshold cells, duplicate/unique values, 2/3-color heatmap gradients, and formula rules (apply_conditional_formatting).
  • Sheet Layout & Panes: Auto-fit column widths, freeze header panes, adjust row heights, and toggle gridlines (set_sheet_layout_and_freeze).
  • Chart Generation: Native embedded Excel charts (Bar, Column, Line, Pie, Area) with custom titles, dimensions, and legends (create_chart).
  • Data Hygiene & Deduplication: Automated string trimming, date normalization, blank stripping, and key deduplication (clean_and_deduplicate_sheet).
  • In-Memory Transforms & Grouping: Pandas grouping, multi-column aggregations (sum, mean, count), filtering, and sorting (transform_sheet_data).
  • Typo-Tolerant Reconciliation: Pre-flight key diagnostics (analyze_reconciliation_keys) and fuzzy joins (reconcile_and_merge) producing clean 3-tab audit workbooks (Matched, Unmatched_Source, Unmatched_Target).
  • OpenPyXL Direct Editing: Safe cell updates with inline styling, row appending, multi-sheet management, broken formula audits (audit_formulas), search & replace (search_and_replace_cells), and CSV/JSON exports.
  • Native Windows Excel COM Automation: Background/visible Excel process control, formula recalculation, pivot table refreshes, PDF export, and VBA macro execution.

🛠️ Included Tools (44 Tools)

  • Inspection: get_workbook_info, preview_sheet, get_column_values, compare_column_values, summarize_column, search_text, profile_sheet, list_tables.
  • Structural & Tables: create_table, insert_column, delete_column, insert_rows, delete_rows, merge_cells, diff_workbooks.
  • Querying & Slices: query_rows (Pandas vectorized expressions), read_range, query_excel_sql (in-memory SQLite queries).
  • Editing & Export: create_workbook, append_rows, write_range (bulk 2D write), update_cells (values + inline styles), add_sheet, rename_sheet, delete_sheet, export_to_csv, export_to_json, audit_formulas, search_and_replace_cells.
  • Styling & Layout: format_cells, apply_conditional_formatting, set_sheet_layout_and_freeze.
  • Analysis & Copilot Tools: create_chart, clean_and_deduplicate_sheet, transform_sheet_data.
  • Reconciliation: analyze_reconciliation_keys, reconcile_and_merge.
  • Windows COM Automation: recalculate_and_save, export_to_pdf, refresh_data_and_pivots, run_vba_macro, get_active_excel_window.

📦 Installation

pip install mcp-win-stdio-excel

(Installing this package automatically installs mws CLI orchestrator).


🚀 One-Command Claude Setup

mws setup excel
# or:
mws add excel

Manual Configuration Example

In %APPDATA%\Claude\claude_desktop_config.json:

{
  "mcpServers": {
    "excel": {
      "command": "python",
      "args": ["-m", "mcp_win_stdio.excel"]
    }
  }
}

📖 CLI Commands & Interactive Guide

mws excel guide     # Complete tool reference & prompt recipes
mws excel doctor    # Verify Excel COM automation, Pandas, and OpenPyXL
mws excel setup     # Configure Claude Desktop / Claude Code
mws excel run       # Launch server over stdio

📜 License

MIT License. Copyright (c) 2026 Mohan Kumar Indala.

Metadata

Release files for mcp-win-stdio-excel 0.4.3

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for mcp-win-stdio-excel 0.4.3
File Size Uploaded Provenance Actions
mcp_win_stdio_excel-0.4.3.tar.gz 39.4 kB Without provenance Details for mcp_win_stdio_excel-0.4.3.tar.gz

Built distribution (wheel)

Table of built distributions (wheels) for mcp-win-stdio-excel 0.4.3
File Interpreter ABI Platform Actions
mcp_win_stdio_excel-0.4.3-py3-none-any.whl Python 3 none any Details for mcp_win_stdio_excel-0.4.3-py3-none-any.whl

Total release size: 80.5 kB

Release files / mcp_win_stdio_excel-0.4.3.tar.gz

Download URL mcp_win_stdio_excel-0.4.3.tar.gz
Size 39.4 kB
Tags Source
SHA-256 checksum
How to use checksums
815499164658c3eb373af333885faabfe03f9318b299a20cd6af6c0f01e28a36
BLAKE2b-256 checksum
How to use checksums
9ee3efee454133f0a4b31676386f321890182c6c18acf0bd5e94a012805d348b
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/7.0.0 CPython/3.14.7

Release files / mcp_win_stdio_excel-0.4.3-py3-none-any.whl

Download URL mcp_win_stdio_excel-0.4.3-py3-none-any.whl
Size 41.1 kB
Tags Python 3
SHA-256 checksum
How to use checksums
fd16f33eccb4efd6b1d375e47385c056b7e2bac53f237d13cbfdad364ba267e5
BLAKE2b-256 checksum
How to use checksums
88c9f8bdea03d4b4290ce4528c5986b6ea363b9dcd737c1e1b4164f114ea58be
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/7.0.0 CPython/3.14.7

Security for mcp-win-stdio-excel 0.4.3

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

No provenance found

None of the files in this release were uploaded with provenance metadata.

A note on package security

PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.

To learn more about protecting yourself from malicious actors, visit our package security documentation.

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page