{}VeryQuickTools
A1

CSV Cleaner

Paste in messy CSV, repair delimiters and stray whitespace, remove duplicate rows, and export clean JSON or a Markdown table.

What this does

This tool tidies up comma-separated data that has drifted out of shape: stray spaces around values, duplicate rows, blank lines, and inconsistent spacing after commas. Paste your data in, choose how you want it back, and it is cleaned in the browser — nothing is uploaded to a server.

You can export the result as clean CSV, as a JSON array of objects keyed on the header row, or as a Markdown table ready to drop into notes or a README.

Common questions

Does my data get uploaded anywhere?

No. All parsing happens in your browser. Closing the tab discards it.

What counts as a duplicate row?

After trimming, two rows with identical values in every column are treated as duplicates, and only the first is kept.

Can it handle values that contain commas?

Yes. A value wrapped in double quotes can contain commas, line breaks, and escaped quotes (written as two double quotes), and it is treated as a single field. Clean CSV output re-quotes any value that needs it.