What does removing duplicate rows mean?
Removing duplicate rows means deleting repeated records from a table so each person, order or product appears once. Duplicates creep in when lists are merged, forms are submitted twice or exports overlap, and they inflate counts and send people the same email twice.
Paste or open a CSV and decide what counts as a duplicate: entire rows, or a set of key columns. Choose whether capitals and extra spaces matter and which copy to keep. You'll see how many rows were checked, removed and left, with the cleaned table and the removed copies ready to download.
How to use the Remove duplicate rows
1.Paste or open the CSV
With headers in the first row.
2.Choose what makes a duplicate
Whole rows, or columns such as email or SKU.
3.Download
The de-duplicated rows, and the removed copies if you want them.
Example: a newsletter list
Six sign-ups where Asha appears three times and Ravi twice:
- Exact whole-row match
- 1 removed
- Whole rows, ignoring capitals
- 2 removed
- Matching on email only
- 3 removed, 3 subscribers left
Matching on email catches "Ravi K." too, leaving one row per subscriber.
Matching the way people mean it
Exact matching misses copies like ASHA@example.com and asha@example.com, or a name with an extra space. Ignoring capitals and spaces catches those. Matching on chosen columns treats two rows as the same customer when their email matches, even if the name was typed differently.
Keep first holds on to the earliest row of each group, keep last the most recent, which suits exports where newer rows hold updated details. The original order of the kept rows is preserved.
Frequently asked questions
Can I see what was removed before downloading?
Yes. The removed copies are listed underneath and can be downloaded separately.
Does it change the values I keep?
No. Matching ignores capitals and spaces, but kept rows stay exactly as they were.
Can it find near-duplicates like misspelled names?
No. Match on a reliable column such as email or phone instead.
Is the file uploaded?
No. Matching happens locally.
Related tools
CSV cleaner
Trim spaces, drop empty rows, rename, split and merge columns in a CSV.
Remove Duplicate Lines
Delete repeated lines from a list and keep the first of each.
CSV sort and filter
Filter CSV rows by conditions and sort by one or two columns.
CSV analyzer
Profile every column of a CSV: types, missing values, stats and outliers.
CSV chart maker
Turn CSV columns into a bar, line, scatter, histogram or share chart.
CSV validator
Check a CSV for broken quotes, uneven rows and header problems.
More Developer tools
JSON & data
Network & system
Web & API
Git & releases
Encoding & security
- Base64 encode & decode
- URL encode & decode
- JWT decoder
- Hash generator
- HTML entity encoder
- Text to binary
- Morse code translator
- Caesar cipher & ROT13
- Random string generator
- Secret key generator
- 2FA code generator (TOTP)
- Encrypt & decrypt text
- Encrypt & decrypt files
- SSH key generator
- Base32 encoder and decoder
- Unicode escape converter
- Nano ID generator
- JWT generator
Text & code
- Regex tester
- Text diff checker
- Cron expression explainer
- Lorem ipsum generator
- Markdown previewer
- Slug generator
- Strip HTML tags
- Unicode character inspector
- URL parser
- Markdown TOC generator
- cURL converter
- Whitespace visualizer
- Markdown link extractor
- Regex escape
- Regex match extractor
- Split text by regex
- HTML, CSS and JS playground
- Mock data generator
- Keyboard event tester
- ASCII table