CSV Deduplicator
Remove duplicate CSV rows locally.
Free. No signup required.
What this tool does
Remove duplicate CSV records by all columns or selected keys. Keep the first or last matching row and review the cleaned table locally before export.
How to use
Choose columns to compare or use all columns, then remove repeated records.
Features
Compare full rows or selected key columns and choose which occurrence to retain.
When to use it
Clean repeated exported records by an ID column without treating every changed field as a new record.
Example and checks
Comparing every column retains both rows because their status differs. Selecting only id treats them as duplicates; keep-first retains draft and keep-last retains ready. Choose keys based on what a record means, not merely on which choice removes the most rows.
id,status
A,draft
A,readyCommon questions
Which columns determine whether a row is duplicate?
All columns are compared unless you select key columns. The first matching row is kept by default; you can keep the last instead. The header is not a data row.
Data processing
This tool processes its input locally in your browser without sending it to a server for processing. Input and results are not included in share URLs.
Related tools
CSV Viewer
Preview CSV headers and rows locally.
CSV to JSON
Convert header-based CSV to a JSON array locally.
JSON to CSV
Convert an array of JSON objects to CSV locally.