LIST CLEANUP GUIDE · 5 MIN READ
How to clean copied lists without a spreadsheet
Lists copied from PDFs, websites and email often look correct at first glance but contain duplicate entries, irregular spaces and empty rows. A simple repeatable workflow produces a clean list without touching a spreadsheet.
1. Normalize spaces
Start with a spacing cleanup pass. Once obvious padding is gone, follow with Remove blank lines so the list has a predictable shape before deeper editing.
2. Remove extra blank rows
Use Remove blank lines for notes with paragraphs, or remove empty rows entirely if every line should be an item. Keep an original copy until you have reviewed the result.
3. Remove duplicates and order the result
Remove duplicate lines preserves the first occurrence of each item. Next, Sort lines puts the final list in a predictable order. For lists where order has meaning, skip sorting.
4. Compare revisions
When two people supply lists, use Compare two lists to identify entries unique to each side and entries held in common. This makes review faster and produces a clear record of what changed.
5. Review before export
After cleanup, scan the first and last few lines and look for accidental merges, lost punctuation or items that should remain repeated. Deduplication is powerful, but you still need a final human review before the list becomes source data.
List cleanup FAQ
Should I sort before removing duplicates?
Usually no. Remove formatting noise first, deduplicate, and only sort if the final order does not carry meaning.
What if duplicate rows differ only by case?
Normalize case or spaces before deduplication when you know those differences are accidental. If case is meaningful, review manually.