Lines to Comma Separated List
Joins lines into a comma separated list, or splits a list on commas into one item per line.
0 characters
What is Lines to Comma Separated List?
Lists come in two common shapes: one item per line, and items separated by commas. Spreadsheets, forms and code often need one shape while your data is in the other.
What this tool does
In list mode it joins the lines with a comma and a space, skipping empty lines. In lines mode it splits on commas and semicolons and puts each item on its own line.
How to use it
- Choose the direction.
- Paste your lines or your list.
- Copy the result.
Did you know?
- Many databases accept a comma separated list in an IN clause, so this is a quick way to prepare IDs for a query.
- The tool trims spaces around each item.