How to use it
- Choose List → one line or One line → list.
- Paste your list or your delimited text.
- Pick the separator, quotes and other options.
- Copy the result.
List to one line
Paste a list with one item per line, for example a column copied from Excel or Google Sheets:
apple
pear
plum
peach
and get a single line: apple, pear, plum, peach.
Options:
- Separator: comma and space, comma, semicolon (with or without space), pipe ( | ), tab or space.
- Quotes: none, "double" or 'single'. Quotes inside an item are escaped with a backslash.
- Add “and” before the last item:
apple, pear, plum, and peach. With a comma separator and three or more items, the serial (Oxford) comma is used, as recommended by Chicago style; with two items you getapple and pear. - Remove duplicates while joining.
Items are trimmed and empty lines are skipped automatically.
One line to list
Switch to One line → list to go the other way. Paste apple, pear; plum or a row copied from a spreadsheet, and each item ends up on its own line.
With Auto-detect, the tool counts commas, semicolons, tabs and pipes and splits on whichever appears most. If none of those appear, it splits on spaces. You can also choose the separator yourself. Remove quotes strips surrounding quote marks from each item, so "apple", "pear" becomes apple and pear.
Recipes
| Goal | Settings |
|---|---|
SQL IN (…) list | Separator , · quotes 'single' |
| JSON or JavaScript array content | Separator , · quotes "double" (add [ ] around it) |
| Email recipients | Separator ; (Outlook) or , (most other apps) |
| Tags or keywords field | Separator , |
| Readable sentence | Separator , · add “and” |
| Paste back into one spreadsheet row | Separator tab |
Need something at the start or end of every item, like a prefix or HTML tags? Use add prefix and suffix to lines first, then join here.
Comma-separated vs. CSV
A comma-separated line is the simplest case of CSV (comma-separated values). Real CSV files have several rows and columns, and fields that contain commas must be wrapped in double quotes, with inner quotes doubled (""). This tool joins and splits single lists, which covers most everyday needs.
For multi-column data, use extract columns, which understands quoted CSV fields and lets you pick and reorder columns. To clean the list before joining, try remove duplicate lines or sort lines.
Conversion happens in your browser; your data is not uploaded.
Excel tips
- Column to comma-separated: select the cells, copy, paste here, copy the one-line result.
- Comma-separated to column: split here into a list, copy, and paste into a single cell; the spreadsheet puts each line into its own row.
- Into one row instead of one column: join with the tab separator and paste into the first cell of the row.
Excel also has a TEXTJOIN function, but this tool is quicker for a one-off conversion and handles quotes for you.
Frequently asked questions
How do I convert a column to a comma-separated list?
Copy the column, paste it with “List → one line” selected, keep the comma-and-space separator, and copy the result.
How do I split comma-separated values into lines?
Choose “One line → list” and paste the text. Auto-detect finds the separator, or you can pick it.
Can I put quotes around each item?
Yes. Choose double or single quotes in the Quotes option.
Does it use the Oxford comma?
Yes. With “and” before the last item, a comma separator and three or more items, you get “apple, pear, and plum”.
Is my data uploaded?
No. Everything happens in your browser.
Last updated: November 12, 2026