Break a comma separated line back into one item per line
Processed in your browser. Nothing is uploaded. Updated on 24 Oct 2026.A comma separated line is easy to send and horrible to read. Paste one here to get one item per line, ready to paste into a spreadsheet column, a checklist or a form that wants them separately. Spaces around each value are trimmed, empty entries between two commas are dropped, and the count is shown so you can check nothing went missing on the way.
Direction is already set to One line back to a list.
Paste the comma separated line into Your list.
Change the Separator if the values are split by semicolons, pipes or spaces.
Press Copy to take one item per line.
Joining a list of lines into one separated line is a two-minute job in a text editor and a five-second job here, and the difference is not the time. It is the three faults the manual version leaves behind: a separator hanging off the end, the blank row a spreadsheet copy always brings with it, and the entry that appears twice because the list was pasted from two places.
Choose the separator: comma, comma and a space, semicolon, pipe, space, tab, or anything you type yourself. Choose whether each item is quoted, with single, double or backtick quotes, and whether the whole line is wrapped in round, square or curly brackets. Those two together turn a column of order numbers into ('ORD-1041','ORD-1042','ORD-1043'), which is one paste into a SQL IN clause, or into a JavaScript array, or into a shell argument list.
The same page runs backwards. Switch the direction and a comma separated line becomes one item per line, which is what you want when somebody sends you a long line and you need it as a column again. Splitting also breaks at line ends, because a list pasted out of an email is usually a mixture of both.
The rest of the article, and all 7 questions about List to Comma Separated, are on the List to Comma Separated page.
Paste the list into the box on the left and the joined line appears on the right immediately. Choose comma, comma and space, semicolon, pipe, space or tab as the separator. No separator is left on the end, and the blank line a copy usually brings with it is dropped and counted.
Set quotes to single and the wrapper to round brackets. Each item is then quoted on its own and the whole line wrapped, giving ('A1','A2','A3') as one copy. Turn on remove duplicates as well, because a repeated value in an IN clause is harmless but usually means the source list was pasted twice.
Yes. Switch the direction and each value goes on its own line, which is what a spreadsheet column or a checklist needs. Splitting breaks at the chosen separator and at line ends together, so a list pasted out of an email, part on one line and part on the next, still comes out correctly.
List yahan paste kijiye. Comma separated line turant ban jaati hai, aur aap chunte hain ki comma chahiye, semicolon, pipe ya space. Excel formula kaise likhein yeh sochne ki zarurat nahi, khaali lines apne aap hat jaati hain aur ginti neeche dikh jaati hai.
Still stuck? Ask about List to Comma Separated and anybody who knows can answer. No account needed.
On the related tools: URL Extractor – Find every link in pasted text or HTML and get them as a clean, deduplicated list · Unicode to Kruti Dev Converter – Turn Unicode Hindi into Kruti Dev 010 keys for Word, PageMaker and typing practice · Dummy Text Generator – Fill a layout with neutral dummy text of the length you need.
In the collection Text Tools.