Workspace

Remove duplicate rows

Remove duplicate rows, comparing all columns or chosen key columns.

Result

Run the tool to see results here.

About Remove duplicate rows

Remove duplicate rows is a free online data tool. Remove duplicate rows, comparing all columns or chosen key columns.

Enter your input, adjust the options (data, format, delimiter and columns and more) and run it. The result appears right next to the form, is never stored, and you can copy or save it in one click. No account is needed.

How to use Remove duplicate rows

  1. Type or paste your input into the form.
  2. Choose the options you need: data, format, delimiter, columns and keep.
  3. Press Run, or use Ctrl/⌘ + Enter.
  4. Copy or save the result from the panel on the right.

Remove duplicate rows FAQ

What does Remove duplicate rows do?

Remove duplicate rows, comparing all columns or chosen key columns.

Is Remove duplicate rows free to use?

Yes. Remove duplicate rows is free, with no sign-up or account required.

Is my data safe?

Results are never stored. See our privacy policy for details.

What options does Remove duplicate rows have?

You can set: Data, Format, Delimiter, Columns, Keep and Case Insensitive.

More spreadsheet & data tools

📊

CSV / TSV / JSON / XML converter

Convert tabular data between CSV, TSV, JSON, XML and a Markdown table.

📊

CSV delimiter converter

Change a CSV delimiter (input delimiter is auto-detected unless given).

📊

CSV cleaner

Trim cells, drop empty rows/columns, normalise headers.

📊

Find & replace across columns

Literal find/replace in all or selected columns.

📊

Column splitter

Split one column into several on a delimiter.

📊

Column merger

Merge several columns into one.

See all Spreadsheet & data tools →

Popular on Toolsera

🖼️

QR code generator

Make a QR code for text, a link, a contact card (vCard), Wi-Fi, email, SMS, phone, WhatsApp, a map location, a calendar event or a UPI payment. Download as PNG or SVG, copy or share.

🛠️

JSON formatter

Pretty-print JSON, optionally sorting keys.

✍️

Word, character & sentence counter

Words, characters, sentences, paragraphs, lines, reading and speaking time.

🧮

Percentage calculator

percent-of: a% of b | what-percent: a is what % of b | change: % change from a to b | increase: b increased by a% | decrease: b decreased by a%