Duplicate Row Remover
Find rows that repeat — across all columns or just the ones you pick, such as Email — and keep a single copy. You see exactly which rows will be removed before you download the cleaned file. Everything is processed in your browser; your data is not uploaded.
1. Data and matching options
Local onlyProcessed in your browser; your files and data are not uploaded or stored. Formulas, macros and scripts in your data are never run.
2. Cleaned result
Live previewCSV downloads use safe export by default: cells starting with =, +, -, @, a tab or a carriage return get a leading apostrophe so spreadsheet apps treat them as text.
Data is processed in your browser's memory. Limits: 20 MB per file, 200,000 rows, 1,000 columns and 3,000,000 cells.
About Duplicate Row Remover
Duplicate Row Remover finds rows that repeat in CSV or TSV data and keeps one copy. You choose which columns decide whether rows match, whether case and surrounding spaces matter, and whether to keep the first or last row of each group.
Duplicates creep in when exports are combined or forms are submitted twice. Removing them blindly can delete the wrong row. This tool shows the removed rows separately, keeps your values unchanged, and lets you match on exactly the columns that define a duplicate.
Step by step
- Upload or paste the table.
- Tick the columns to compare (all are ticked at first).
- Set case sensitivity, space handling and keep first or keep last.
- Review the removed rows and the cleaned output.
- Download the cleaned file, and the removed rows if you want them.
What it offers
- Match on any combination of columns
- Case-sensitive or case-insensitive comparison
- Ignore surrounding spaces when comparing
- Keep first or keep last matching row
- Separate preview and download of removed rows
- Original values preserved unless you choose output trimming
Tips for best results
- Match on a true identifier such as an email or ID where possible.
- Use keep last when later rows contain more recent information.
- Review removed rows before downloading.
- Keep the removed-rows file as an audit trail.
Why people use it
Controlled
You decide exactly what counts as a duplicate.
Reviewable
Removed rows are shown before you commit.
Private
Data is processed only in your browser.
Common questions
This runs entirely in your browser
No file or text you enter here is uploaded. Encoding and decoding happen on your device using native browser APIs — close the tab and nothing remains on a server.