Remove Duplicate Rows Online

Import a table and the Remove duplicates step is already added. The first occurrence of each row is kept, every later copy is dropped, and the summary tells you exactly how many rows were removed.

By default the whole row is used as the key. Select one or more columns when only some fields decide what a duplicate is — an email address, for example — and the preview still shows every change before you export CSV or Excel.

Clean a Table

Remove duplicates, trim spaces, split columns, find and replace, fill blank cells. Build a cleaning recipe and export the result. The file never leaves your browser.

Your data never leaves this browser

The file is parsed, previewed and charted on your own device. Nothing is uploaded — not even a sample. Close the tab and the data is gone.

Or paste table text
Import a file to get started. Everything runs locally.

How it works

  1. 1.Import the table to clean (Excel, CSV, TSV or JSON, or paste) — nothing is uploaded.
  2. 2.Add the steps you need from the list: delete empty rows, trim spaces, remove duplicates, find and replace, split or merge columns, normalise dates, numbers and phone numbers.
  3. 3.Order the steps with the arrows, or ask the AI for a plan and apply the steps it suggests.
  4. 4.Press Clean the table: every step reports how many rows and cells it changed, then export the result as CSV or Excel.

Frequently asked questions

Which copy of a duplicate row is kept?
The first one, in file order. Every later row that matches it is removed, so the earliest record of each value survives.
Can I deduplicate on one column only?
Yes. Select just that column in the step and rows are compared by that value alone — useful for mailing lists where the email address is what matters.

Related tools

Text to Columns Converter

Split one column into several in your browser: the split step is ready, pick the column and the delimiter, preview the result and export CSV or Excel.

Normalize Date Formats in a Spreadsheet

Rewrite a messy date column into one format in your browser: choose the column and the order, convert to ISO or a local style, then export the table.