Advertisement
top slot

Dedupe

Remove duplicate rows from a CSV

Spreadsheets

Dedupe

Remove duplicate rows from a CSV

Advertisement
top slot

Drop a CSV file here

your file never leaves the browser

rows · columns
A row counts as duplicate when these columns match:
Found duplicate rows in groups.
After dedupe: rows (down from ).
Showing 500 of rows. Download for the full file.
Group
Showing 200 of duplicate groups.

About Dedupe

What this does

Find and remove duplicate rows from a CSV. You choose what counts as "the same row":

  • All columns — drop only exact duplicates
  • One or more columns — keep just one row per email, per customer ID, per SKU, etc.

For each duplicate group, you can keep the first occurrence or the last — useful when later rows have updated info.

Bonus features

  • Trim whitespace before comparing — so "alice@x.com " matches "alice@x.com"
  • Case-insensitive match — so Alice@X.com matches alice@x.com
  • Preview the duplicates before downloading — see exactly what gets dropped
Advertisement
in-content slot

Frequently asked questions

Yes — non-duplicate rows stay in their original position. When duplicates are found, only the kept row (first or last, your choice) remains.

Yes — the "Duplicates" tab shows every group of duplicate rows so you can verify before downloading.

Tested up to ~500k rows. Beyond that, split the file first.

Embed this tool on your site

Drop a one-line iframe snippet into any blog, lesson plan, or knowledge base. Powered-by-Toolenza link included.

Embed this tool

Paste this snippet into any HTML page. The tool runs entirely in your reader's browser.

Advertisement
bottom slot
Sticky ad — mobile-sticky

Dedupe

No reviews yet — be the first to share your thoughts.

Your rating
  1. No reviews yet — be the first to share your thoughts.
Powered by Codenzia
Sticky ad — mobile-sticky
↑↓ navigate open
Toolenza Brain
Tip: describe a result you want, not a tool. The Brain picks for you.
⌘⇧K to open · esc to close
Thanks! We read every message.