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

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

Built distribution (wheel)

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

Total release size: 82.4 kB

Release files / mcp_win_stdio_excel-0.4.7.tar.gz

Download URL mcp_win_stdio_excel-0.4.7.tar.gz
Size 40.4 kB
Tags Source
SHA-256 checksum
How to use checksums
3cfb9bd170b93a845bdf205c288ae4226906b8d4b5bf8553fbc5ca2dd899bccb
BLAKE2b-256 checksum
How to use checksums
a220aeedc566867042de552d37de4ad5c4f4ecb72f8519edbc1191294643548a
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.7-py3-none-any.whl

Download URL mcp_win_stdio_excel-0.4.7-py3-none-any.whl
Size 42.0 kB
Tags Python 3
SHA-256 checksum
How to use checksums
3e19c970d1c40f904019f65e0e728503f0dd0103b6873868f1c9ce282208d332
BLAKE2b-256 checksum
How to use checksums
342e4529ae082bb22f4a06c482d97362118337dc0f3f7b86106691a56cf7f00e
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.7

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