Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIDeepSeekDeepSeekMuseMuse+22 more

    Smart Spreadsheet Merge Semantic Dedup

    1

    Consolidates folder-wide spreadsheets into a single file using four-layer semantic and fuzzy deduplication.

    $5

    /mo

    Subscription · cancel anytime

    Secure checkout via Stripe

    • Always the latest version
    • Delivered live to your agent via MCP
    • Cancel anytime, access ends at period end
    Security scanned
    Smart Spreadsheet Merge Semantic Dedup

    Smart Spreadsheet Merge Semantic Dedup

    Example session with this skill installed

    Consolidate all the spreadsheets in the /client-data folder. There are a lot of duplicates but some names are abbreviated or have typos.

    • Read your context and instructions
    • Compiled the smart spreadsheet merge

    I found 5 files with 1,200 total rows. I've mapped the inconsistent 'CustName' and 'Client' headers to a unified 'Customer' column. I propose using 'Customer' + 'Email' as the dedup key. Once you confirm, I'll run the four-pass semantic detection.

    $5/mo

    Subscription · always the latest version

    • Secure checkout via Stripe
    • Cancel anytime
    • Delivered live via MCP

    About this skill

    Surfaces: Claude Code ✅ · Cowork ✅ · claude.ai ⚠️ uploaded files only, no local folder path · Chrome ❌ no shell to run cluster.py or write a workbook · API ⚠️ needs Bash plus a turn-taking loop for the two approval gates

    Runtime: Python 3.7+ — ordered dict.fromkeys dedup at scripts/cluster.py:73 (inferred); nothing else pins a floor, imports are stdlib only

    Packages: openpyxl + pandas for the workbook I/O this skill delegates to the public xlsx skill (SKILL.md:12) — preinstalled in the claude.ai sandbox, elsewhere: pip install openpyxl pandas. scripts/cluster.py needs nothing

    Tools: Bash / Python execution (cluster.py, workbook read-write) · directory listing and file read across a whole folder (step 1) · file write and delivery to the user, /mnt/user-data/outputs/ then present (SKILL.md:48) · multi-turn dialogue — steps 4 and 6 are blocking approval gates

    Network: none at runtime. pypi.org at install time only if openpyxl / pandas are absent

    Model: any. Pass D judges synonyms, translations and brand-vs-legal-name pairs by meaning (SKILL.md:38) — a stronger model produces fewer bad groups to veto at the gate

    Companions: requires the public xlsx skill, read first (SKILL.md:12) · spreadsheet-data-auditor routes cross-file dedup here

    Degrades to: without shell, Passes A–C fall back to manual grouping and no workbook is written — only trivial folders are feasible. Without a turn-taking session the step-4/6 gates cannot run, and the merge must not proceed without them. LibreOffice recalc is not needed — the output sheets carry values, not formulas

    Generated from SKILL.md + scripts/ + references/ on 2026-08-14. Items marked (inferred) follow from a code signal rather than a declaration.

    Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for Data & Databases.

    Requires public xlsx skill. Not for silent background processing; requires user sign-off at two specific approval gates to prevent accidental data loss during semantic merging.

    How to use

    1. 1

      Connect your agent to the Agensi MCP

      Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup

    2. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 3

      Ask for what you need

      Your agent loads this skill and uses it on your task. It always asks before buying a skill.

    Reviews

    No reviews yet

    Be one of the first to try it. Every listed skill goes through the trust checks below.

    Security scanned

    Checked by our 8-point scan before listing

    Fresh listing

    Recently published to Agensi

    Free to use

    No account required to browse

    Trust & safety

    Security scan

    Security scan passed 3 months ago

    Permissions

    Read Files
    Browser
    Terminal / Shell
    Listed3 months ago

    What's inside

    Frequently Asked Questions

    This skill merges multiple spreadsheets from an entire folder into a single file while using a sophisticated four-layer semantic process to identify and remove duplicates that simple keyword matching would miss, such as synonyms, translations, or brand variations.

    It is fully compatible with Claude Code and Cowork; however, on claude.ai, it only works with uploaded files rather than local folder paths, and it cannot run in standard Chrome environments without shell access.

    The skill includes two mandatory approval gates where the AI presents its deduplication logic for your review, ensuring you have total control over what data is consolidated before the final file is written.

    You will need Python 3.7+ and the 'openpyxl' and 'pandas' libraries; while these are preinstalled in many sandboxes, they can be easily added via pip in other environments.

    No, the skill operates entirely offline at runtime with no external API calls, using your chosen AI model to judge synonyms and semantic meanings locally.

    This skill is designed to work alongside the public 'xlsx' skill for file I/O and can be triggered automatically by the 'spreadsheet-data-auditor' for seamless cross-file cleaning.

    New in Data & Databases