Text Transform

Line splitter

Your text

What to do

Separator

Result 0 → 0 characters · 0 lines

Transformed in your browser · nothing is uploaded

Local · not a CSV parser — quoted commas will split

Converts between a delimited list and one item per line, in either direction. Whitespace around each item is trimmed and empty entries are dropped.

How to use the line splitter

1 Paste your text into the first box.

2 Choose what you want done to it.

3 Copy the result, or save it as a text file.

This is the small piece of data plumbing that comes up constantly: a spreadsheet column needs to become a comma-separated list for a query, or a comma-separated list needs to become a column to paste back into a spreadsheet. Both directions trim whitespace, which matters because " apple" and "apple" are different values to almost everything downstream. One limitation to be aware of: this splits on the separator wherever it appears, so it is not a CSV parser — a value containing a quoted comma will be split in the middle. For real CSV, use a CSV tool.

Questions

Can I use a separator other than a comma? −

Yes, put any string in the separator field — a semicolon, a pipe, a tab.

Does it handle quoted CSV values? +

Is whitespace trimmed? +

Can I number the lines? +

How do I get a column out of a spreadsheet? +

Sources

MDN — working with strings

Was this tool any good?

INTERNAL SIGNAL ONLY · WE USE IT TO FIND TOOLS WORTH REBUILDING