CSV Duplicate Row Remover: what to check
Exact duplicate record warnings are shown first. Nothing is deleted merely because two rows share a name or an identifier.
What counts as an exact duplicate
Every parsed field must match another record in the same order. The header is excluded from the comparison. Quoted and unquoted representations that decode to the same values can match, while different whitespace or different letter case remains different data.
A repeated student name, product code, or invoice number alone is not an exact duplicate record. If the other fields differ, the rows may represent different events. This tool does not merge records based on one column.
Decide whether repetition is an error
The warning names the repeated record and the earlier matching record. Repetition can be intentional in attendance logs, transactions, and event data. Skip a warning to keep the record unchanged.
Apply Fixes approves removal of the displayed duplicate record only. Remaining records retain their relative order. The file is then checked again and the next issue is displayed. Undo brings the removed record back before download.
Download the reviewed result
The CSV export keeps field content and correct escaping. An error report records duplicate warnings and whether their locations remain open or have changed. Check totals against your source system if record count is significant for an import.
Try a real CSV example
| Code | Item |
|---|---|
| 0007 | Notebook |
| 0007 | Notebook |
| 0007 | Notebook refill |
Only the second record exactly repeats the first. “Notebook refill” remains a separate record even though its code matches.
Download the example CSVSelect the example in the tool above. Your file is processed locally, and changes require your approval.