Convert New Lines to Commas

Paste a column, get a single comma-separated line. The most common job on this site.

Already set up: split mode is newline, join is ,. Paste one item per line and press convert to join it up.

Examples

	Input	Output
Simple	`apple ⏎ banana ⏎ cherry`	`apple, banana, cherry`
Realistic	`[email protected] ⏎ [email protected] ⏎ [email protected]`	`[email protected], [email protected], [email protected]`

Why convert this way

This is the spreadsheet-column-to-list conversion. Copy a column of IDs, emails or SKUs, paste it here, and get something you can drop into a query, a config file or a form field that wants comma-separated input.

When you will need it

Turning a column of IDs into a query parameter
Filling a "comma-separated tags" field in a CMS
Building an email To: line from a contact export
Writing an array literal in code

Watch out: Blank rows in the source column become empty items — you get a, , b. Keep Remove empty lines on, which is the default.

What the settings do here

Split on newline — the tool reads apple⏎banana⏎cherry as 3 separate items.
Join with , — producing apple, banana, cherry.

Where this comes up

Typically the last step rather than the first. You have finished cleaning a column and now something downstream — a query parameter, a tag field, a config value — wants it as one line.

Related conversions

Convert Commas to New Lines Turn a, b, c into one item per line. This is the shape every other text tool expects. Convert a List to a SQL IN Clause Paste a column of values and get 'a', 'b', 'c' — quoted, comma-separated, ready for your… Convert New Lines to Pipes Join a column into a pipe-separated string. Common for regex alternation and legacy record formats.

Going the other way, or joining with something else entirely? The delimiter converter accepts any split and join pair including custom separators, and the index has the 16 ready-made ones.

Frequently Asked Questions

How do I turn a spreadsheet column into a comma-separated list?

Copy the column, paste it in, and join with a comma. A copied column arrives newline-separated, so split on newline rather than comma.

What happens to blank rows in the column?

They become empty items, producing output like a, , b. Keeping the remove-empty-lines option on, which is the default, drops them.

From the blog

How to Convert Excel to CSV with a Pipe Delimiter for Database Uploads Most databases don't play well with comma-delimited files when your data contains commas. Here's how to convert Excel to a pipe-delimited CSV so your database uploads go smoothly every time. Why Your CSV is Broken: Common Delimiter Errors and How to Fix Them CSV files break in predictable ways. Learn the most common delimiter errors, why they happen, and how to fix them fast without rewriting your data by hand. How to Escape Delimiters in CSV Files to Prevent Data Errors An unescaped comma can silently corrupt your CSV data. Learn how RFC 4180 quoting and escaping rules work, the most common mistakes to avoid, and how to verify your files before importing.