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.6

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.6
File Size Uploaded Provenance Actions
mcp_win_stdio_excel-0.4.6.tar.gz 40.4 kB Without provenance Details for mcp_win_stdio_excel-0.4.6.tar.gz

Built distribution (wheel)

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

Total release size: 82.4 kB

Release files / mcp_win_stdio_excel-0.4.6.tar.gz

Download URL mcp_win_stdio_excel-0.4.6.tar.gz
Size 40.4 kB
Tags Source
SHA-256 checksum
How to use checksums
b0b9a53d47e66631f8c33da07013e7352fe7acc04a18abe9a3fe39b696d88e91
BLAKE2b-256 checksum
How to use checksums
b1ff9cf8025527d2bd20d60ae9c9851e790d1b82fe952e6cc10966bb096db751
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.6-py3-none-any.whl

Download URL mcp_win_stdio_excel-0.4.6-py3-none-any.whl
Size 42.0 kB
Tags Python 3
SHA-256 checksum
How to use checksums
85f1af4c854c0494c3c4479f921decfc8e20207860b77161f9a39b391e6a5200
BLAKE2b-256 checksum
How to use checksums
0d0f87a021f16e7750ef3da2cba9441629b24efade825eeafe18b189c181fe0e
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.6

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