How to Remove Blank Lines from a List
A list copied from a PDF, a spreadsheet, or an email often comes with stray empty lines scattered through it - gaps left over from page breaks, merged cells, or formatting that doesn't survive the copy-paste. They're easy to miss until an import script chokes on them or a mail merge sends a message to a blank name.
Quick answer
Paste your list into Text Fixer. Blank lines are removed automatically by default, with no option to enable - it's the tool's standard behavior. If you actually want to keep blank lines (to preserve spacing between sections, for example), check Keep Blank Lines in the options panel.
Remove blank lines now. Free, nothing to install.
Open Text Fixer →The fastest way: just paste it in
Unlike most of Text Fixer's other cleanup options, this one needs nothing turned on. Paste the list in and every line that's empty, or contains only whitespace, is already gone from the output. Copy the result and that's the whole process.
What actually counts as a "blank" line
A line doesn't need to be zero-length to count as blank - a line that contains only spaces or tabs, with nothing else, is treated as blank too and gets removed the same way as a truly empty line.
Text like this, with blank and whitespace-only lines mixed in:
apple banana cherry date
comes out as:
apple banana cherry date
When you need more control than "remove everything"
Sometimes you don't just want blank lines gone, you want to see what was removed, or you're cleaning up a list alongside other issues (null-like values, currency symbols, inconsistent casing) in one pass. Two options for that:
- Use Filter Lines with the "Is blank" match type set to Remove - this keeps the removed blank lines visible in a separate panel rather than just discarding them.
- Use List Data Cleaner if you're already running a bigger cleanup pass (trimming, null values, date formats) - it has its own dedicated Remove Blank Lines toggle alongside those other fixes.
Cleaning up a messier list than just blank lines?
See the full guide to cleaning up a list - trimming, deduplicating, fixing case, and more.