Drop repeated lines from a CSV export without breaking quoted fields or the header
Processed in your browser. Nothing is uploaded. Checked against sources on 17 Oct 2026.Sorting a CSV in a text editor and deleting repeats breaks as soon as a field contains a comma or a line break inside quotes. This page reads the CSV properly, keeps the header row out of the comparison, and removes rows that repeat in every column or in only the columns you choose. Semicolon and tab files keep their delimiter, and the result is written back in the same layout.
Drop your files or click to choose them.
Adjust the options and check the preview.
Download the result. Nothing was uploaded.
Duplicate rows creep in whenever two exports are combined, a form is submitted twice or a list is copied from several places. Finding them by eye stops working after a few hundred rows.
| Option | What it does |
|---|---|
| Whole row | Two rows match only when every column matches |
| Chosen columns | Rows match when those columns match, such as Email or Order number |
| Ignore upper and lower case | [email protected] and [email protected] are the same |
| Ignore extra spaces | Spaces at the ends of a cell, and doubled spaces inside, do not count |
| Keep the last copy | The newest row of each group survives instead of the first |
| Remove empty rows | Rows with nothing in them go as well |
See it before it happens. As soon as the file is read, the page counts the duplicates and lists the first rows that would be removed, with their row numbers. Changing an option updates the count at once. When the Download button is pressed, the cleaned file is saved, and the removed rows can be saved separately to check.
The rest of the article, and all 6 questions about Remove Duplicate Rows (CSV and Excel), are on the Remove Duplicate Rows (CSV and Excel) page.
Drop the CSV on Remove Duplicate Rows. Duplicates are counted at once, comparing whole rows, and the first rows that would be removed are listed. Tap a column such as Email to compare only that column, then press Download to save the cleaned CSV with its header and delimiter unchanged.
Drop the .xlsx here and tap the column that identifies a row, for example Customer ID. Rows with a value already seen in that column are removed and the first one stays. The download is a new .xlsx with the kept rows, their numbers, dates and formats unchanged.
The first copy of each repeated value is kept by default, and the kept rows stay in their original order. Tick Keep the last copy when the newest row should win, such as the latest address of a customer who signed up twice.
Yes. Before you download, a table lists the rows that will go with their row numbers. After that, Download the removed rows saves every removed row as its own file, with the header, so the cleaning can be checked or undone.
Rates and rules change; check the source before you rely on a figure.
Still stuck? Ask about Remove Duplicate Rows (CSV and Excel) and anybody who knows can answer. No account needed.
Same job, other tools: Markdown to Plain Text – Strip every Markdown mark and keep the words.
On the related tools: Convert Any File – Photos, documents, spreadsheets, archives: drop it and see what is possible.