Skip to main content

locacsv.comRemove Duplicate Rows from a CSV

CSV DEDUPLICATE · DISTINCT

Remove Duplicate Rows from a CSV

Detect duplicates using all columns or selected columns and keep the first matching row. Your CSV never leaves your browser.

CSV processing stays in your browser

Your files are not uploaded to a server.

File selection

Choose 1 CSV file up to 50 MiB. Its name and contents are never sent outside your browser.

Drag and drop a CSV file here

1 CSV file, up to 50 MiB

How it works

Keep one row for each email address

Compare email addresses and keep only the first matching row.

Input example

2 columns · 2 rows
Input example
EmailName
[email protected]Alice Smith
[email protected]Alice Smith (updated)

Output example

2 columns · 1 row
Output example
EmailName
[email protected]Alice Smith
The left table shows the input, and the right table shows the output.

Equivalent to DISTINCT. The number of excluded duplicate rows is also shown.