What this skill does
Every CSV export from a real system has the same problems — inconsistent date formats, stray whitespace, duplicate rows from a retried sync, phone numbers in four different formats — and cleaning it by hand in a spreadsheet is slow and easy to get subtly wrong. This skill takes a messy CSV and fixes the common issues automatically, then reports exactly what it changed so nothing is silently altered without a record.
How it works
- Issue detection — scans every column for inconsistent formatting (mixed date formats, inconsistent casing, stray whitespace, mixed phone/currency formats), exact and near-duplicate rows, and empty-vs-null inconsistencies.
- Normalization — standardizes each column to a single consistent format (choosing the most common existing format as the target unless you specify one), trims whitespace, and removes exact duplicate rows.
- Change report — outputs the cleaned CSV alongside a plain-English change log: how many rows were deduplicated, which columns were reformatted and how, and any rows flagged as ambiguous for manual review rather than auto-corrected.
Requirements
- Works on Claude AI (Claude Code, or claude.ai with code execution enabled) — cleaning runs via code execution (Python/pandas) so it can handle large files without loading everything into the model's context at once.
Setup
- Unzip the package into your Skills directory, keeping the folder structure intact.
- Attach or point it at your CSV file — see
SKILL.mdfor the exact invocation pattern and how to specify target formats (e.g. force all dates toYYYY-MM-DD). - Review the change report before treating the cleaned file as final — ambiguous rows are flagged, not silently guessed.
What's included
SKILL.md— the skill definition and detection/normalization logicexamples/sample-run.md— a worked example cleaning a sample messy export
