Remove duplicate rows

Find and remove duplicate rows, either rows that are identical in every column or rows that share a value such as a SKU.

Free · no sign-up · runs in your browser

Drop a CSV file here, or

Your file is processed in your browser. It is not uploaded.

How it works

1
Drop in your CSV.
2
Choose what makes two rows the same: every column, or key columns such as SKU.
3
Check the list of removed rows, then download the cleaned file.

The first one by default. Choose "the last row" to keep the newest version when a file was appended to over time.

Yes. Every removed row is listed with its row number, and you can download the removed rows as their own CSV.

Yes, if you compare whole rows or Variant SKU. Don't compare by Handle alone: every variant of a product shares the Handle.

Split a large CSV into smaller files, each with the header row. Rows of the same product stay in the same file.

Turn garbled text like "CafÃ©" back into "Café", and convert the file to UTF-8, the encoding every store platform expects.

Excel drops leading zeros from barcodes and shows long ones as 1.23457E+11. This tool repairs what can be proven correct and flags what can't.

Convert an .xlsx workbook to a UTF-8 CSV. Barcodes keep their digits, dates become YYYY-MM-DD, and accents survive.

Turn product titles into clean Shopify URL handles, from a list of titles or for a whole product CSV.