KOENJP

Remove Duplicate Rows

DEDUPE · CLEAN

Find duplicate rows in a CSV or .xlsx by the columns you choose and keep the first or last one. Split columns, trim spaces, remove empty rows, then download CSV or .xlsx.

Or paste a table

Your files are processed right here in your browser. Nothing is uploaded or stored on a server.SheetJS CE 0.20.3 (Apache-2.0) · loaded only for .xlsx files

Good to know. Very large files may be slow, and the preview shows only the first rows (the download has everything). Formatting and formulas are dropped; only values remain.

HOW TO

How to use

  1. Drop a CSV or .xlsx file, or paste a copied table.
  2. Pick the key columns (none means the whole row), whether to ignore spaces and case, and which row to keep.
  3. Rows to be removed are highlighted; click Remove duplicates. Split columns, trim spaces or remove empty rows if needed.
  4. Undo anytime, then download the result as CSV or .xlsx.
PAIRS WELL WITH

Pairs well with

FAQ

FAQ

Does it change the row order?

No. Remaining rows stay in their original order. With “Last” selected, the bottom-most row of each duplicate group is kept.

How large a file can it handle?

It depends on your browser’s memory, but hundreds of thousands of rows usually work. The preview shows the first 300 rows, and the download includes all of them.

Is my data uploaded?

No. All cleaning happens inside your browser.