Column to Comma
Convert one-item-per-line text into a comma-separated list instantly. This column to comma tool is useful for Excel exports, tag lists, and quick copy formatting.
Whether you call it column to comma or lines to comma separated, this free tool handles it instantly in your browser.
Options
Example usage
Example input
apple banana orange
Example output
apple, banana, orange
Batch Processing
Enter multiple inputs, one per line. Each line will be processed separately.
Why this tool?
Everything runs right in your browser — no uploads, no sign-up, no waiting. Your text never leaves your device.
Quick tips
- •Outputs update live as you type.
- •Use the sticky copy button to grab results quickly.
- •Bookmark this page for fast access.
More like this
Discover related tools and step-by-step guides for this kind of task.
How it works
- Paste line-separated text into the input box.
- The tool joins each non-empty line into one comma-separated string.
- Trim mode keeps the final list tidy and ready to paste elsewhere.
Use cases
Flattening a column back into one line
This is the return trip: you have one item per line and need them joined into a single comma-separated string. The destination is usually a field that only accepts one line — a spreadsheet cell, a tags input, a database column, a query parameter, or a config value. Copying a multi-line block into any of those either fails outright or silently keeps only the first line.
The typical workflow is a full round trip: convert a comma list to a column with Comma to Column, clean it up (dedupe, sort, remove blanks), then flatten it back here. Doing the editing while the list is vertical is far easier than counting commas in a wall of text.
Details that decide whether the result works
Trailing whitespace is the usual saboteur. Lines copied from a spreadsheet or a web page frequently end with an invisible space, and joining them produces "apple , banana" — which looks fine at a glance but will not match "apple" anywhere downstream. Trimming as you join removes the problem at the source.
Blank lines matter too: an empty line in your column becomes an empty item in the output ("apple,,banana"), which many systems read as a missing value rather than nothing at all. Run Remove Empty Lines first if your source came from an export. And whether you want a space after each comma depends entirely on the destination — humans reading a sentence want it, while a strict API parameter often does not.
Cleanup
Explore all text cleanup tools
Browse every tool for this kind of task, along with helpful guides that show you how to get the most out of them.
Related tools
Supporting guides
Conversion History
Loading...
FAQ
Does it ignore blank lines?
Yes. Empty lines are skipped so the final comma-separated output stays clean.
Can I use this after sorting lines?
Yes. It works well after tools like Sort Lines or Remove Empty Lines when you want to turn the final list into one line.
Will the tool add spaces after commas?
Yes. The output uses a readable comma-space format by default.