What the Text to List does
Text to List splits text into items and puts them back together the way you need. Paste a comma-separated line, a column copied from Excel or a messy list, choose what separates the items (or let the tool detect it), and get one item per line, bullets, a numbered list, a comma-separated line, a JSON array, an HTML list or a SQL IN list. Spaces are trimmed, empty items dropped, and duplicates and sorting are one click away.
How to use it
- Paste your text on the left.
- Choose what separates the items, or leave it on Detect.
- Choose the output format and order, and whether to remove duplicates.
- Copy or download the list.
Example
“Mumbai, Delhi, Bengaluru, Chennai, Kolkata, Delhi, Pune” becomes six lines, one city each, with the second Delhi removed. Choosing SQL gives ('Mumbai', 'Delhi', 'Bengaluru', 'Chennai', 'Kolkata', 'Pune'), ready for a WHERE city IN query.
Common jobs
Turn a column of email addresses copied from a spreadsheet into one comma-separated line for the To box, or turn a comma-separated list of tags into lines for a spreadsheet. Existing bullets and numbers at the start of items are removed automatically, so you can convert between list styles.
Sorting uses natural order, so “Item 2” comes before “Item 10”, and ignores upper and lower case.
Questions people ask
Is my text sent anywhere?
No. Everything happens in your browser as you type, so private notes, lists and documents never leave your device.
Are quotes in SQL handled?
Yes. An apostrophe inside an item, as in D’Souza typed with a straight quote, is doubled so the SQL stays valid.
Can I split on my own character?
Yes. Choose My own and type any text, such as a pipe | or “ and ”.
Can it make a JSON array for code?
Yes. Choose JSON array to get a properly quoted list such as ["Mumbai", "Delhi"], ready to paste into JavaScript or a config file.