CSV Duplicate Row Remover
Clean up duplicates in a CSV by whole row or by specific columns, all at once
도구를 불러오는 중…
🔒 Everything runs 100% in your browser. Your files and input are never uploaded to any server.
Paste in a CSV or upload a file, and this tool finds and removes duplicate rows based on the entire row or the columns you specify. With options to ignore case and whitespace differences, it can clean up even the messy duplicates found in real-world data.
How to use
- Paste your CSV into the input box, or drag and drop a file to load it.
- Choose the delimiter and the 'duplicate criteria' (whole row or specific columns).
- If needed, turn on the ignore-case and ignore-whitespace options.
- Check the result and save it with the Download CSV or Copy button.
FAQ
- Are my file or inputs sent to a server?
- No. CSV parsing and duplicate removal are handled entirely inside your browser. No data is ever sent to or stored on a server.
- Which of the duplicates is kept?
- It keeps the first occurrence and removes any identical rows that appear afterward. The original sort order is preserved.
- How do 'ignore case' and 'ignore whitespace' work?
- They apply only when comparing the comparison key. Ignore case treats A and a as the same, and ignore whitespace trims leading/trailing spaces and collapses repeated ones before comparing. The values in the rows that remain are kept exactly as in the original.