Remove duplicate CSV rows.

Paste a CSV or open a file. Your data stays in this browser; nothing is uploaded.

Open a CSV file (up to 2 MB)Or paste comma-separated dataFirst row is a headerTrim spaces around each cellRemove exact duplicate rowsPrefix formula-like cells with an apostrophe for safer spreadsheet imports

This also converts negative numbers to text. Uncheck only when you trust the source and need those values unchanged. Always review spreadsheet import behavior.

Cleaned CSV

How duplicate removal works

Two rows are duplicates only when every cell matches. Matching is case-sensitive. With trimming enabled, spaces at the start and end of each cell are ignored. The first copy stays in its original order. The optional header is always kept separately.

Commas and line breaks inside cells

Standard quoted CSV fields are supported, including embedded commas, doubled quotation marks, and line breaks. Semicolon-separated files are not supported. Rows with inconsistent column counts are rejected so the tool does not silently shift data into the wrong columns.

Keep your original file

The download is a new file; this tool does not overwrite your original. Review the result before importing it into a CRM, store, or spreadsheet. There is no local storage or analytics code in the tool itself.