Free tool · CSV in · CSV out
CSV duplicate row remover
Compare every field in a row, keep its first occurrence, and preview how many records were removed. Short rows are compared as if their missing trailing cells were empty.
Paste the data instead
Choose a file, paste data, or try the example to preview the result.
Preview
How it works
- ChooseCompare every field in a row, keep its first occurrence, and preview how many records were removed. Short rows are compared as if their missing trailing cells were empty.
- PreviewCheck the result in the preview before downloading. Input files stay on your device.
- DownloadSpaces remain significant. Use the CSV cleaner first if leading or trailing spaces should be removed before comparison.
Questions
Does this compare one column or the entire row?
The entire row. Two records with the same ID but different values are both retained. Letter case matters unless you select the case-insensitive option.
Is my file uploaded?
No. The file is read and processed by JavaScript in your browser. No account is needed.
What are the limits?
Spaces remain significant. Use the CSV cleaner first if leading or trailing spaces should be removed before comparison. Text input is limited to 25 MB and tables to 200,000 cells.
Keep going
Related tools, and the longer explanations behind them.