CSV Cleaner
Dedupe rows, drop empty lines, trim cells, and switch delimiters in one pass.
Paste a messy CSV and get back a clean one. Remove duplicate rows (full row or by column), drop blank rows, trim whitespace inside every cell, and convert between comma, semicolon, tab, or pipe delimited files. Live preview, strict RFC 4180 parser, clean .csv download.
How it works
- Paste your CSV into the editor and pick the input delimiter.
- Choose a mode: dedupe, remove empty, trim, or change delimiter.
- Unlock the result and download the cleaned .csv file.
Use cases
- Dedupe a contact export before importing it into a CRM.
- Drop empty rows out of a CSV exported from a spreadsheet.
- Trim trailing spaces in every cell of a scraped CSV.
- Convert a semicolon-delimited European CSV to a standard comma CSV.
- Turn a tab-separated export into a clean CSV ready for Excel.
Frequently asked questions
Does it preserve the header row?
Yes. If you leave 'First row is a header' ticked, the header is always kept at the top and is never deduped or removed, even in empty-row mode.
Can I dedupe by a single column?
Yes. On the Dedupe tab, pick the column to compare by (1 through 8). Only the first row for each unique value in that column is kept, in original order.
What about quoted fields with commas or newlines inside?
Handled. We use a strict RFC 4180 parser that understands quoted fields, escaped quotes (""), and both LF and CRLF line endings, so nothing inside a value gets misread.
Does it fix encoding issues?
We strip the UTF-8 byte order mark (BOM) at the start of the file if present, so the first header cell isn't corrupted by an invisible character. For other encoding problems, save your file as UTF-8 first.
Is there a size limit?
Up to 2 MB of CSV per job, comfortably tens of thousands of rows. Split larger files into separate runs.
How long is the result kept?
The cleaned .csv is auto-deleted after 7 days. Re-download is available during that window via the secure link.
Related tools
- Remove Duplicate CSV Rows: Paste a CSV and get a clean copy with every duplicate row removed.
- Remove Empty CSV Rows: Drop every blank row from a CSV in one click and keep your header intact.
- CSV Delimiter Converter: Convert a CSV between comma, semicolon, tab, and pipe delimited formats.
- CSV to JSON Converter: Paste a CSV and download a clean JSON file, with headers preserved.
