CSV deduplicator
Compare CSV rows or selected columns, keep the first or last record, and review or download removed rows. Process data locally in your browser.
Local processing · Inputs are not uploadedUTF-8 comma-separated CSV up to 1 MiB. Output uses quoted fields and CRLF, with spreadsheet formula protection.
Preview: up to 20 records, 12 columns and 160 characters per field. Copy and downloads contain all results. Numbers refer to CSV records after skipping blank lines, including the header, not text lines.
Kept record numbers
Removed record numbers
Enter content, then choose an action.
How to use
- Paste CSV or choose a UTF-8 file; enable the header option if the first row contains column names.
- Choose whole rows or key columns, select first or last occurrence, then remove duplicates. First and last refer to input order.
- Review kept and removed records and download each CSV. Comparison preserves case and spaces; 001 differs from 1. Blank lines are skipped; entirely empty keys are kept separately by default.
Example
id,name 001,Ana 001,Bea 002,Leo
With a header and id as the key: keeping first gives Ana and Leo; keeping last gives Bea and Leo. The other 001 record appears in removed rows.
Frequently asked questions
Will row order change?
Kept and removed records each preserve input order; last occurrence means position, not latest date.
Are commas and line breaks in fields supported?
Quoted CSV fields are supported. Incomplete quotes or inconsistent row widths cause an error.
How are duplicates compared?
Compare exact strings across whole rows or selected columns, preserving spaces and case; 001 and 1 differ. Duplicate headers are distinguished by column position.
Related tools
CSV ↔ JSON
Convert CSV and JSON in your browser, preserving strings and checking table structure.
CSV comparison by key
Compare two CSVs by ID or SKU and download added, removed and changed records.
JSON formatter
Validate, format or minify JSON; copy or download the result.