Remove Duplicates from a List
Tools and Utilities • Text and List Utilities
Frequently Asked Questions
How do I remove duplicates from a list while keeping the original order?
Use List mode, enable Preserve original order, and then click Remove duplicates. The output keeps items in the same sequence as the original input while removing repeated values.
What is the difference between keep first occurrence and keep last occurrence?
Keep first occurrence retains the earliest appearance of each value and removes later repeats. Keep last occurrence retains the most recent appearance and removes earlier repeats.
Why does trimming whitespace change which items are considered duplicates?
Without trimming, values like "Apple" and " Apple " are treated as different because the spaces are part of the text. With Trim whitespace enabled, extra spaces are removed before comparison, so those entries match and can be deduplicated.
How can I remove duplicates from a CSV by a specific column?
Switch to CSV mode, load or paste the CSV, then choose "A specific column" and select the column to use as the uniqueness key. Rows are treated as duplicates when that column repeats, and you can still choose keep first or keep last occurrence.
When should I use case-sensitive matching for deduplication?
Enable case-sensitive matching when capitalization carries meaning, such as codes where "ab" and "AB" must remain distinct. Turn it off when you want "Apple" and "apple" treated as the same value.