Remove duplicates from CSV & Excel
Dedupe by one or more columns.
Remove ads, lift file-size limits, unlock multi-file joins.
Loading saved state…
How to remove duplicate rows
- 1
Add your file
Drop in a CSV, Excel (.xlsx, .xls), or TSV file, or pick it from your device. It is read in your browser — nothing is uploaded.
- 2
Choose which columns define a duplicate
Pick the column(s) that make two rows "the same" — an email on its own, or a combination like first name + last name + phone. Rows that match on those columns are treated as duplicates.
- 3
Keep one, then download
Tabularly keeps the first row of each duplicate group and removes the rest, in original order. Preview the cleaned table and download it as CSV or Excel.
Removing duplicate rows by column
Deduplicating removes repeated rows from a table, keeping one of each. The key question is what makes two rows “the same” — and that is rarely every column. A mailing list has duplicates when the email repeats, even if the signup date differs; a contact export is duplicated when first name + last name + phone match. You choose the column(s) that define a duplicate, and Tabularly collapses each group to a single row.
Picking one column is the common case (dedupe by email, by order ID, by SKU). Choosing several forms a composite key — rows count as duplicates only when they match on all of them. To remove only fully identical rows, select every column as the key. Either way, the first occurrence is kept and later copies are dropped, so the surviving rows stay in their original order.
This is the no-formula equivalent of Excel’s “Remove Duplicates”, but with control over exactly which columns matter and without altering your source file. Common uses: cleaning a mailing or CRM list before import, removing repeated transactions from a merged export, or collapsing duplicate leads gathered from several sources.
Everything runs in your browser — your data never leaves your device, unlike tools that upload your spreadsheet. The free tier handles files up to about 10 MB; Pro raises the limit for large exports.
Frequently asked questions
What counts as a duplicate? +
You decide. Duplicates are rows that share the same value(s) in the column(s) you pick as the key — not necessarily identical across every column. Pick "email" and two rows with the same email are duplicates even if other fields differ.
Can I remove duplicates by specific columns, not the whole row? +
Yes — that is the default behavior. Choose one column or several (a composite key). To dedupe on fully identical rows instead, select all columns as the key.
Which duplicate row is kept? +
The first occurrence in the file is kept and the later duplicates are dropped, so the surviving rows stay in their original order.
Does deduping reorder my data? +
No. Remaining rows keep their original order; only the duplicate rows are removed. You can sort the result separately if you want.
What file formats and sizes are supported? +
CSV, TSV, and Excel (.xlsx, .xls). The free tier handles files up to about 10 MB; Pro raises the limit substantially for large exports.
Do my files get uploaded to a server? +
No. Deduplication runs entirely in your browser, so your file contents never leave your device — you can confirm it in DevTools (network tab shows no upload).