Paste a messy list and clean it in one step: remove duplicates, delete blank lines, trim extra spaces and sort it A to Z. Perfect for email lists, product codes, names or anything copied from another system.
RemovesDuplicates, blanks, extra spaces
SortsA to Z or Z to A
PrivateNothing leaves your browser
Do it in Excel with one formula
In Excel 365, combine TRIM, FILTER, UNIQUE and SORT. With the list in A2:A100:
=SORT(UNIQUE(TRIM(FILTER(A2:A100,A2:A100<>""))))FILTER drops the blanks, TRIM removes extra spaces, UNIQUE removes duplicates and SORT puts the result in order. In older versions, use Data → Remove Duplicates instead.
Frequently asked questions
Is Kochi the same as kochi?
By default, yes: duplicates are matched regardless of case. Tick the case option to treat them as different.
Which copy of a duplicate is kept?
The first one, in its original position, unless you sort the list.
Does it remove duplicates within a line?
No. Each line is treated as one item.