How to Remove Duplicates from a List Online
Duplicate lines in a list are tedious to clean up by hand, especially when the list is long enough that you can't just scan it visually. Paste it here, check one box, and you're done.
Remove duplicates now. Free, nothing to install.
Remove Duplicate Lines → Open Text Fixer (More Options) →How to do it
- Paste your list into Text Fixer. One item per line. If your data is comma-separated, use the Split CSV button in the toolbar first to put each value on its own line. A column copied out of Excel or Google Sheets pastes in as one item per line already (or, to keep the data in the spreadsheet, see how to remove duplicates in Google Sheets).
- Enable Remove Duplicates. It's in the options panel. The output updates instantly.
- Check the output. The first occurrence of each item is kept. All later copies are gone.
- Copy the result. Use the Copy button on the output panel.
What counts as a duplicate
Two lines are duplicates if they're identical after your other options are applied. A few things that affect this:
- Case sensitivity: on by default. "Apple" and "apple" are treated as different items. Uncheck Case Sensitive in Options if you want them treated as the same.
- Trailing spaces: Ignore Leading/Trailing Spaces is on by default, so "apple " and "apple" count as the same item.
- Extra internal spaces: "John Smith" (two spaces) and "John Smith" (one space) are different unless you also enable Ignore Extra Spaces.
When the results still look wrong
If Remove Duplicates is on but you're still seeing what look like identical lines in the output, invisible characters are almost always the cause. Non-breaking spaces, zero-width spaces, and hidden carriage returns are invisible but make two lines compare as different.
Paste your list into the Invisible Character Detector to see exactly what's in each line. Then run it through the Data Cleaner to strip out the hidden characters before deduplicating.
Deduplicating and sorting at the same time
Text Fixer applies all active options together. Enable Remove Duplicates and Sort A-Z at the same time and the output will be deduplicated and sorted in one step. You don't need to run the tool twice.
Comparing two lists for duplicates?
If you want to find items that appear in both of two separate lists, that's the Compare tool.