Skip to main content

excel-diff2-mcp

MCP (Model Context Protocol) server for comparing Excel files with hierarchical module matching.

Features

  • Hierarchical Module Matching: Match Excel data by multiple levels of functional modules
  • Stacked Output: Output two tables stacked in a single result
  • Dual Output Formats: Support both CSV and Markdown output
  • Flexible Input: Accept HTTP(S) URLs or Base64-encoded file content
  • Auto Header Detection: Automatically detect header rows
  • Merged Cell Handling: Fill merged cells downward for accurate comparison

Installation

pip install excel-diff2-mcp

Usage

Command Line

excel-diff2-mcp

As MCP Tool

from mcp.client.session import Session

async with Session() as session:
    result = await session.call(
        "compare_excel",
        file1="https://example.com/file1.xlsx",
        file2="https://example.com/file2.xlsx",
        compare_columns=["一级功能模块", "二级功能模块"],
        output_format="markdown",  # optional: "csv" (default) or "markdown"
    )

compare_excel Parameters

Parameter Type Required Description
file1 str Yes First Excel file (URL or Base64 content)
file2 str Yes Second Excel file (URL or Base64 content)
compare_columns list Yes Columns for hierarchical matching
table_name1 str No Display name for table 1
table_name2 str No Display name for table 2
output_format str No Output format: "csv" (default) or "markdown"

compare_columns Formats

Single array (same columns for both tables):

["一级功能模块", "二级功能模块"]

Dual array (different columns per table):

[["一级功能模块", "二级功能模块"], ["一级功能点", "二级功能点"]]

Output

CSV Format

表1名称,,,,
一级功能模块,二级功能模块,描述,比对结果
模块A,子模块1,描述内容,一级、二级功能模块均在【表2】找到
模块B,子模块2,描述内容,一级功能模块在【表2】找到

表2名称,,,,
一级功能模块,二级功能模块,描述,比对结果
模块A,子模块1,描述内容,一级、二级功能模块均在【表1】找到
模块C,子模块3,描述内容,未在【表1】找到

Markdown Format

## 表1名称

| 一级功能模块 | 二级功能模块 | 描述 | 比对结果 |
| --- | --- | --- | --- |
| 模块A | 子模块1 | 描述内容 | 一级、二级功能模块均在【表2】找到 |
| 模块B | 子模块2 | 描述内容 | 一级功能模块在【表2】找到 |

## 表2名称

| 一级功能模块 | 二级功能模块 | 描述 | 比对结果 |
| --- | --- | --- | --- |
| 模块A | 子模块1 | 描述内容 | 一级、二级功能模块均在【表1】找到 |
| 模块C | 子模块3 | 描述内容 | 未在【表1】找到 |

Supported File Formats

  • .xlsx - Excel 2007+ format
  • .xls - Excel 97-2003 format
  • .csv - Comma-separated values
  • .xlsm - Excel macro-enabled format
  • .xlsb - Excel binary format

License

MIT

Metadata

Release files for excel-diff2-mcp 1.2.0

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

Source distribution (sdist)

Source distribution for excel-diff2-mcp 1.2.0
File Size Uploaded Provenance Actions
excel_diff2_mcp-1.2.0.tar.gz 52.2 kB Without provenance Details for excel_diff2_mcp-1.2.0.tar.gz

Built distribution (wheel)

Table of built distributions (wheels) for excel-diff2-mcp 1.2.0
File Interpreter ABI Platform Actions
excel_diff2_mcp-1.2.0-py3-none-any.whl Python 3 none any Details for excel_diff2_mcp-1.2.0-py3-none-any.whl

Total release size: 59.9 kB

Release files / excel_diff2_mcp-1.2.0.tar.gz

Download URL excel_diff2_mcp-1.2.0.tar.gz
Size 52.2 kB
Tags Source
SHA-256 checksum
How to use checksums
c43cbf99088532e2dc068666128401d7ea3c2977e44db3a08f87cb08a845f4b0
BLAKE2b-256 checksum
How to use checksums
b1b957398325fe760ec1f63fc8df48f090d2599b243f7887686e9e1cc210fcae
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/6.2.0 CPython/3.11.5

Release files / excel_diff2_mcp-1.2.0-py3-none-any.whl

Download URL excel_diff2_mcp-1.2.0-py3-none-any.whl
Size 7.7 kB
Tags Python 3
SHA-256 checksum
How to use checksums
a3f9ec3233e69b695508b6da6f8d88c6c189398552bea2a3424f0000272d708d
BLAKE2b-256 checksum
How to use checksums
169cc4eb01d8ab19f1eb49358c937f69426eaf7681d3086be606ac1a47c668df
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/6.2.0 CPython/3.11.5

Security for excel-diff2-mcp 1.2.0

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.

Release history Release notifications | RSS feed

This release

1.2.0 This release

2 release files No provenance

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