DEVELOPER & DATA

Data Cleaner

Clean pasted lists line by line: trim, collapse spaces, drop blanks, strip quotes, change case, NFC, ASCII quotes, remove invisible characters, dedupe.

The cleaned lines plus a count for every step in the fixed order they run, so you can see exactly what changed and re-run it on the next export.

Example: A supplier list copied from a PDF: leading spaces, double spaces inside names, a few zero-width spaces and curly quotes — one pass returns plain, trimmed, deduplicated lines with counts.

v0.1.0 · last reviewed 20 September 2026
Loading the workspace…
BUILT TO BE UNDERSTOOD

Each step counted,
in a fixed order.

What every switch does, the order the steps run in, and what the tool leaves alone.

The steps, in order

Invisible characters (zero-width space/joiner/non-joiner, word joiner, bidi marks, soft hyphen, BOM) removed → NFC normalisation → typographic quotes, dashes, ellipsis and odd spaces to ASCII → trim → inner runs of spaces and tabs to one space → surrounding quotes stripped → case change → blank lines removed → duplicates removed (exact match after the steps above). The order matters — trimming before deduping merges "a" and "a " — and is fixed so the counts mean the same thing every time.

Counts

Each line-level step reports how many lines it changed; the blank and duplicate steps report lines removed. A step that is off is not listed.

What it leaves alone

Accented letters and symbols stay (the ASCII option converts only quotes, dashes, ellipsis and spaces); nothing inside a line is reordered; "Title" case capitalises every word — the Title Case utility has the AP/Chicago rules. Nothing leaves the browser; the same four anonymous usage counts as the rest of the site apply.

SOURCES

Last reviewed 20 September 2026. How results are checked: How we verify.