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.3.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.3.3
File Size Uploaded Provenance Actions
mcp_win_stdio_excel-0.3.3.tar.gz 39.0 kB Without provenance Details for mcp_win_stdio_excel-0.3.3.tar.gz

Built distribution (wheel)

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

Total release size: 79.9 kB

Release files / mcp_win_stdio_excel-0.3.3.tar.gz

Download URL mcp_win_stdio_excel-0.3.3.tar.gz
Size 39.0 kB
Tags Source
SHA-256 checksum
How to use checksums
f1ce4658aabd50b56afeddff59b35f8dc5ed77a53e9e24be850f6f1931719cf0
BLAKE2b-256 checksum
How to use checksums
c1cfef1c3f105c88ed809a88f2fb7a3e3ce83e20df458734549dbdc0aab3b6ab
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.3.3-py3-none-any.whl

Download URL mcp_win_stdio_excel-0.3.3-py3-none-any.whl
Size 40.8 kB
Tags Python 3
SHA-256 checksum
How to use checksums
18d150f6de84f917840efda920b09b9abf0b0a56a0da7a7af31df57f30531d2c
BLAKE2b-256 checksum
How to use checksums
66ed21d7a1b839f83dfc40e4839766f51db40c148bb6e044c97d2cb9a6ba82d9
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.3.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