List Cleaner

About the List Cleaner

Lists rarely arrive in the shape you need. Something copied from an email is comma separated, an import wants one item per line, and a document wants numbers or bullets. This cleaner converts between those formats and tidies each item as it goes.

It also removes blank entries, trims stray spaces and can quote each item, which is what a spreadsheet or a database query usually requires.

How to use the List Cleaner

1. 1Paste your list in whatever format you have.
2. 2Tell the tool how items are currently separated.
3. 3Choose the output format: lines, commas, bullets or numbers.
4. 4Enable trimming, deduplication or quoting as needed.
5. 5Copy the cleaned list.

Features

• Line, comma, semicolon and tab input separators
• Line, comma, bullet and numbered output
• Trimming, blank removal and optional deduplication
• Optional quoting of each item
• Item count before and after cleaning

Why people use it

• Prepare a list for import without a spreadsheet.
• Turn a paragraph of names into a tidy numbered list.
• Build a quoted, comma-separated set for a query.

Common use cases

• Converting emails pasted from a message into one address per line.
• Turning a line-separated list into a comma-separated value for a form.
• Numbering a list of agenda items for a document.

Privacy and your data

Everything you type or open here is processed by your own browser. No file, text or result is uploaded to a server, stored in a database or shared with anyone, and closing the tab clears it completely.

Frequently asked questions

Related tools