Dzzz

Remove duplicate rows

On-device

Remove duplicate rows from a CSV/Excel file

Remove duplicate rows from a CSV, TSV, XLSX or JSON file, right on your device — dedupe by the whole row or by chosen key columns, keeping either the first or last occurrence. Nothing is uploaded.

Not sure which CSV tool you need? See all six →

About this tool

What you provide

  • One CSV, TSV, XLSX or JSON file.
  • The columns duplicates are matched on, or none to match the whole row.
  • Whether to keep the first or the last occurrence.

What you get

  • The table with duplicate rows removed, previewed before download.
  • How many rows were removed.
  • The result as CSV, XLSX, JSON or TSV.

Limits

  • Duplicates are matched on exact cell text, so a difference in spacing or letter case counts as a different row.
  • One file at a time, up to 25 MB, processed in your device's memory.
  • Only the first sheet of an Excel workbook is read.

How to use it

  1. Choose a file

    Tap "Choose a file to dedupe" or drop a CSV, TSV, XLSX or JSON file onto the dashed area.

  2. Pick the matching columns

    Tick the columns under "Match duplicates by"; leave them all unticked and the whole row is matched instead.

  3. Choose which copy to keep

    Under "Keep" select "First occurrence" or "Last occurrence".

  4. Remove duplicates and save

    Tap "Remove duplicates" to see how many rows went and preview the result, then choose CSV, XLSX, JSON or TSV to download it.

Frequently asked questions

How do I remove duplicate rows from a CSV file?

Upload your CSV or Excel file to the Dedupe CSV tool and it removes duplicate rows, leaving you a clean file to download.

Is my file uploaded when I dedupe a CSV here?

No — the deduplication runs on your device, so the file stays on your device.

Does this work on Excel files or only CSV?

It works on both CSV and Excel files.