- Home
- Skills
- Data & Databases
- Smart Spreadsheet Merge Semantic Dedup
Works with the AI tools you already use
Smart Spreadsheet Merge Semantic Dedup
Consolidates folder-wide spreadsheets into a single file using four-layer semantic and fuzzy deduplication.
$5
/moSubscription · cancel anytime
Secure checkout via Stripe
- Always the latest version
- Delivered live to your agent via MCP
- Cancel anytime, access ends at period end
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.
Subscription · always the latest version
- Secure checkout via Stripe
- Cancel anytime
- Delivered live via MCP (optional)
What you get
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.
How to install
Works the same in every agent - Claude, Cursor, Codex, Copilot and 20+ more.
- 1
Download the ZIP
Free skills download straight away. Paid skills unlock right after purchase.
- 2
Unzip into your skills folder
Every agent reads skills from one folder on your machine. Drop the unzipped folder in there.
- 3
Ask your agent to use it
Restart the agent if it was already running. It picks the skill up automatically - no config needed.
Skills folder by agent
Click the path to copy it. Create the folder if it does not exist yet.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill passes our trust checks below.
Security scanned
Passed our 8-point scan before listing
Fresh listing
Recently published to Agensi
Free forever
No account required to browse
Trust & safety
Security scanned
Verified clean 21 days ago