Text to List Converter
Turn comma-separated text into a list, or a list into comma-separated values, bullets, HTML or JSON.
Text to List Converter
Lists travel between tools in different shapes: one item per line in a spreadsheet column, comma-separated in an email, a JSON array in code, an HTML list on a page. Paste your items in any of these shapes, tell the tool how they are separated (or let it detect it), and get them back in the shape you need, trimmed, de-duplicated and sorted if you like.
How to use Text to List Converter
- Paste your items.
- Choose how they are separated, or leave it on Detect automatically.
- Choose the output format, such as one per line, comma-separated, a bulleted or numbered list, an HTML list or a JSON array.
- Optionally trim, remove duplicates and sort, then copy the result.
When it comes in handy
- Turning a spreadsheet column into a comma-separated list for an email or SQL query.
- Converting a keyword list into a JSON array for code.
- Cleaning and de-duplicating tag or email lists.
Frequently asked questions
- Can I use my own separator?
- Yes. Choose "Something else" and type any separator, such as a pipe (|) or " / ".
- Does it handle quotes in CSV?
- It is a simple splitter, not a full CSV parser. For CSV with quoted fields that contain commas, use the CSV to JSON tool.