csv-cleaner SKILL.md skillA

csv-cleaner from 0xelitesystem/claude-skills-templates is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add 0xelitesystem/claude-skills-templates/csv-cleaner@git:20260429.1e75732

Pins git:20260429.1e75732 in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
0xelitesystem/claude-skills-templates
Path
skills/csv-cleaner/SKILL.md
Versions recorded
1
Latest version
git:20260429.1e75732, committed Apr 29, 2026
Size
2,640 bytes
Repository stars
2
License
MIT

Diagnose and clean messy CSV, TSV, or spreadsheet files. Use whenever the user uploads a CSV or TSV that has data quality issues, asks to "clean", "normalize", "fix", or "deduplicate" tabular data, or hands over a file with encoding problems, broken headers, type inconsistencies, duplicate rows, or missing values. Triggers on "clean this CSV", "fix this data", "this spreadsheet is messy", "deduplicate these rows", or any data-quality request on a tabular file. Always run scripts/diagnose.py…

Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.

What the file says

# CSV Cleaner

Two-phase workflow: diagnose first, clean second. Never start fixing before knowing what is broken.

## Phase 1: Diagnose

Run `scripts/diagnose.py` on the input file:

```bash
python scripts/diagnose.py <path-to-file>
```

The script reports:

- Encoding (utf-8, latin-1, utf-16, etc.)
- Delimiter (comma, tab, semicolon)
- Quote character and escape behavior
- Header row detection (present, absent, or duplicate)
- Row count
- Column count consistency across rows
- Type inference per column (integer, float, date, string, mixed)
- Null distribution per column
- Duplicate row count

Read the output carefully before doing anything else. The diagnosis tells you which fixes apply.

## Phase 2: Clean

Apply fixes in this order:

1. Fix encoding: re-read with detected encoding, write as utf-8.
2. Normalize line endings to `\n`.
3. Strip BOM and zero-width characters.
4. Fix headers: lowercase, snake_case, replace spaces with underscores, ensure uniqueness.
5. Trim whitespace from every cell.
6. Coerce types where the column is type-consistent.
7. Standardize null representations: empty string, "NA", "null", "n/a" all become empty.
8. Deduplicate exact rows.
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add 0xelitesystem/claude-skills-templates/csv-cleaner@sha256:971f2984ef4ba62a

The line at the top of this page pins the label git:20260429.1e75732, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.

Badge

mdr badge

[![mdr](https://markdownregistry.com/badge/art_r52kkuijjtz6m5ws.svg)](https://markdownregistry.com/a/art_r52kkuijjtz6m5ws)

3 badge image fetches in 30 days. What the badge shows.

Versions

The registry has recorded 1 version of this file, committed on Apr 29, 2026.

versioncommittedcommitsizeaudit
git:20260429.1e75732 latest2026-04-29 1e75732 2,640 BA view

Audit of the latest version

A  17 of 17 checks passed. Fixed automatic checks with no AI involved, so the same checks give the same answer every run.
  • pass: Frontmatter block present
  • pass: Frontmatter declares a name
  • pass: Frontmatter declares a description
  • pass: Size between 200 bytes and 200 KB (2640 bytes)
  • pass: No zero-width or bidi control characters
  • pass: No instruction hidden inside an HTML comment
  • pass: No link to an exfiltration or paste host
  • pass: No credential-shaped string
  • pass: No instruction to send local credentials anywhere
  • pass: No text hidden with inline styles
  • pass: No prompt-injection phrasing
  • pass: No curl or wget piped into a shell
  • pass: No recursive delete of root, home or parent
  • pass: No instruction to read or print local credentials
  • pass: No base64 blob over 200 characters
  • pass: No link to a raw IP address
  • pass: No script tag

Source

GitHub

0xelitesystem/claude-skills-templates · 2 stars · license MIT · pushed 2026-09-30 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_r52kkuijjtz6m5ws
GET https://markdownregistry.com/api/v1/resolve?ref=0xelitesystem/claude-skills-templates/csv-cleaner
GET https://markdownregistry.com/api/v1/blob/971f2984ef4ba62aac8dc0374c2c61544d2e0bb66640c9b19c07c81a778f3327

Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.

Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.

More from 0xelitesystem/claude-skills-templates

brand-voice SKILL.md skill
0xelitesystem/claude-skills-templates · skills/brand-voice/SKILL.md · Apply a configured brand voice and tone guide to drafts, rewrites, and edits. Use whenever the user wants text edited…
git:20260429.1e75732 · audit A · 2 stars
code-reviewer SKILL.md skill
0xelitesystem/claude-skills-templates · skills/code-reviewer/SKILL.md · Run a structured five-stage code review on a diff, file, or pull request. Use whenever the user wants code reviewed…
git:20260429.1e75732 · audit A · 2 stars
decision-doc SKILL.md skill
0xelitesystem/claude-skills-templates · skills/decision-doc/SKILL.md · Produce a structured decision document with explicit tradeoffs, weighted criteria, scored options, a recommendation…
git:20260429.1e75732 · audit A · 2 stars
one-pager SKILL.md skill
0xelitesystem/claude-skills-templates · skills/one-pager/SKILL.md · Turn raw notes, transcripts, or longform content into a tight one-page executive brief. Use whenever the user wants a…
git:20260429.1e75732 · audit A · 2 stars

Every file in 0xelitesystem/claude-skills-templates

Other files named csv-cleaner

csv-cleaner SKILL.md skill
zhuyansen/agent-skills-hub · ops/skillmgr-runs/in/input/library/csv-cleaner/SKILL.md · Clean messy CSV files: fix headers, trim whitespace, normalise dates and drop duplicate rows before analysis.
git:20261010.859e8f6 · audit A · 461 stars

Browse by kind, by grade A, or by owner.