Free online tools · No sign-up

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 uploaded

UTF-8 comma-separated CSV up to 1 MiB. Output uses quoted fields and CRLF, with spreadsheet formula protection.

Deduplication options

First or last means input order, not date. Strings are compared exactly, preserving spaces and case; 001 and 1 differ.

By default, each entirely empty key is kept; partially empty keys compare normally. Blank lines are skipped as before.

Enter content, then choose an action.

How to use

  1. Paste CSV or choose a UTF-8 file; enable the header option if the first row contains column names.
  2. Choose whole rows or key columns, select first or last occurrence, then remove duplicates. First and last refer to input order.
  3. 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