All tools › Text and Notepad
Remove Duplicate and Empty Lines
Keep only unique lines in a list, find repeats and see how many times each value occurs.
What the tool can do
- Three modes: remove duplicates, keep only repeated ones, keep only unique ones.
- You can choose which repeat to keep: the first or the last.
- Comparison by a chosen column: suits CSV and tables pasted from Excel.
- The “What repeats” table shows the values and the number of repeats.
- Ignoring case, extra spaces and empty lines.
The order of lines is kept. To sort the result, use the “Sort Lines” tool.