CSV Cleaner

Dedupe rows, drop empty lines, trim cells, and switch delimiters in one pass. Gratis te gebruiken zonder account, e-mail of betaling. Het resultaat downloadt meteen na verwerking.

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.

Category: Text
Availability: Free to use without an account, email address, subscription, or payment.
Input: Entered in the browser

How it works

Paste your CSV into the editor and pick the input delimiter.
Choose a mode: dedupe, remove empty, trim, or change delimiter.
Process 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.

Using the interactive tool

Open the canonical HTML page to provide input and generate or download a result. This Markdown alternate contains the complete descriptive and instructional content, but it does not execute the interactive interface.