Comma Separator – Convert Column to Comma Separated List

Our free comma separator tool automatically converts a column to a comma list or list to CSV (comma-separated values). Copy your column of data and watch the conversion happen. You can do the reverse and convert a delimited list to a column.

You can use our comma separator tool to convert column lists to comma-separated value (CSV) lists quickly and easily. Just follow these instructions.

Change any settings you want on the right side of the comma separator by selecting how you want to separate the line breaks once you remove them.

Delimiter: The delimiter is the value you want to separate items in your lists. You can choose from commas (the default), commas with spaces after, spaces, and others.

Remove Line Breaks: This setting will remove any extra line breaks in case you have blank rows.

Remove Paragraph Breaks: This setting removes paragraph breaks which are two two line breaks in a row.

Remove Extra Spaces: If you have any issues with double spaces after removing lines, select this option.

Paste your column or list of data into the left text box where it says “Enter/Get Column Data Here…”

You’ll see the new delimited list in the right text box labeled “Get/Enter Delimited List…”

It’s that simple.

You can also do the opposite: convert a CSV (or other delimited string) into a column of text). Just paste your string into the right text box, select the delimiter and other options, and see your column/list in the left text box.