Text to List

Turn comma-separated text into a list, or a list into commas, bullets, numbers, JSON, HTML or SQL. Remove duplicates and sort.

Runs in your browserNo sign-upWorks offline
Ctrl+Enter to run
Input131 characters
Output
✓ ReadySample content shown

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

  1. Paste your text on the left.
  2. Choose what separates the items, or leave it on Detect.
  3. Choose the output format and order, and whether to remove duplicates.
  4. 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.

Related tools