Cleaning a list of references
Remove references entered several times before building a single inventory, after checking that the spelling variants really refer to the same item.
Clean up a list in seconds by deleting repeated values, keeping the first occurrence of each one in its original order, ready to copy or reuse.
Duplicates removed
0
Remove duplicates from a list of text values while keeping the first occurrence of each one. The tool handles one entry per line and lets you decide whether capital letters and spaces at the edges of a line count in the comparison.
Each non-empty line is compared with the values already seen. When two lines are treated as identical, only the first is kept in the result. Two options, both on by default, ignore differences between upper and lower case and trim spaces at the start and end of each line before comparing; switch them off for a strict comparison. Empty lines are dropped. The counter of removed duplicates does not include empty lines: it only measures repeated occurrences. The tool does not correct spelling or recognise synonyms. For example, “Leeds” and “leeds” are grouped when case is ignored, but “Leeds” and “Leds” stay separate. Keep your original list if the repetitions carry statistical meaning. To decide whether two values should count as the same, look at the quality of the source. In a contact directory, differences in capitals rarely matter; in a list of technical codes, they may distinguish valid identifiers. Trimming edge spaces is handy after a copy and paste, but it never touches spaces in the middle of an expression. If a line appears three times, the tool keeps the first occurrence and removes the others according to the selected rules. It never matches values that are merely similar. For an audit, keep a copy of the original list and note the options you used so you can explain the result. Removing duplicates is not the same as counting occurrences: if you care about how often each value appears, use a value counter instead.
Enter one value per line, in the order you want to keep.
Decide whether the comparison ignores case and edge spaces.
Review the result and the counter of removed repetitions before copying.
Remove references entered several times before building a single inventory, after checking that the spelling variants really refer to the same item.
Group the repeated values in a list of answers. If case or spaces matter, adjust the options first.
Deduplicate a list before comparing it with a second source, so you can tell present values from repeated occurrences.
The second “A” is removed and the counter shows 1 duplicate.
Input
A
B
AResult
A
BWith “ignore case” on, which is the default, “paris” is a duplicate of “Paris”. Without it, all three lines are kept.
Input
Paris
paris
LyonResult
Paris
LyonYes. First occurrences are returned in the order in which they appear.
Yes, that is the default behaviour: the option that ignores case is on. Switch it off to keep the two spellings apart.
Not while edge-space trimming is on, which it is by default. If you switch it off, “Leeds” and “Leeds” followed by a space remain two different values.
No. They are ignored and left out of the counter.
No. Two values spelled differently stay separate.
Related tools
Tools similar or complementary to this one.
Compare two lists to find the items they share and the ones that differ.
Merge two lists into a single set of lines ready to copy or reuse.
Sort the items of a list alphabetically or numerically, in ascending or descending order.