Remove Duplicate CSV Rows

Paste a CSV and get a clean copy with every duplicate row removed. Free to use without an account, email address, or payment. The result downloads immediately after processing.

Paste a CSV and get a clean copy with every duplicate row removed.

Dedupe a CSV in one click. Compare by the whole row or by a single column, optionally case-insensitive and whitespace-tolerant. Header row is always kept. Strict CSV parser so quoted fields with commas are handled correctly.

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.
Pick whether to dedupe by the whole row or by a single column.
Process and download the deduplicated.csv file.

Use cases

Remove duplicate contacts before a CRM import.
Dedupe an order export so a finance report doesn't double-count.
Clean a scraped CSV that has the same URL repeated across pages.
Drop repeated rows out of a long log paste.

Frequently asked questions

Is the row order preserved?

Yes. The first occurrence of every row is kept in its original position. Only later duplicates are removed.

Can I dedupe by a single column?

Yes. Pick the column on the Dedupe tab and only the first row for each unique value in that column is kept.

Does the header get deduplicated?

No. The first row is always preserved as the header when 'First row is a header' is ticked, even if it happens to look similar to data rows.

How is case handled?

By default the comparison is case-sensitive. Untick 'Case-sensitive comparison' and 'Alice' and 'alice' count as the same value.

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.