CSV Dedupe & Cleaner - Remove Duplicate Rows and Tidy Your Data
Merged exports and repeated imports leave the same rows twice. Paste the CSV, choose what counts as a duplicate, and get a clean file with the counts to prove it.
How to use the CSV Dedupe & Cleaner
- Paste your CSV.
- Optionally name key columns (numbers from 1, or header names) - blank means the whole row must match to count as a duplicate.
- Tick trimming, empty-row removal or case-insensitive matching as needed.
- Click Dedupe & Clean and check the before/after counts.
- Copy or download the cleaned CSV.
How it works
Duplicates are detected with an exact key built from either the whole row or only the key columns you list, joined with a control character that cannot appear in normal data - so ab,c and a,bc can never collide. The first occurrence of each key is kept and later ones are counted as removed. Trimming happens before matching, so " Ali " and "Ali" are recognized as the same value. Output is re-serialized with CRLF line endings and correct quoting. The header row is never removed as a duplicate.
Frequently Asked Questions
Is this dedupe tool free?
Yes - completely free, no sign-up, no cap.
What counts as a duplicate?
By default, rows whose every cell matches. With key columns set, rows that match on just those columns - the first one is kept.
Does trimming affect matching?
Yes, when ticked: cells are trimmed before duplicate detection, so stray spaces do not hide duplicates.
Are counts shown?
Yes - total rows before and after, and exactly how many duplicates were removed.
Is my data uploaded?
No. Cleaning happens 100% in your browser.
Related Developer Tools
CSV to JSON Converter
Convert CSV to a JSON array of objects - a real parser that handles quoted commas and escaped quotes.
JSON to CSV Converter
Turn a JSON array of objects into a clean CSV file - union of all keys, proper quoting, one click.
CSV Viewer & Editor
Load CSV into an editable table grid - edit cells, sort columns, add rows and download the result.