Column to Comma Converter

The join. Lines are split, trimmed, and empties removed. The rest are joined with a comma and a space. Order is preserved. There is no sort and no quote wrapping. red, green, blue is three items. A two-line list of oat and rye is two items. A line that is only spaces disappears. A line that contains a comma stays one item and the extra comma remains, so a later split on commas will not match the item count. If your items contain commas, do not use this page. Use a CSV writer that quotes fields. The stacked text tool goes the other way for words separated by spaces, not for lines you already broke.

The count. Items is the number of non-blank lines. It is the check against the commas. If you expected four and the count is three, one line was blank or two items shared a line. Look at the box. The comma line will not invent the missing item.

red, green and blue on three lines become one line with commas and spaces. Blank lines are dropped so a trailing enter does not add an empty item. The item count is the check. Three lines in, three items out. A line of spaces is blank and disappears. Commas already in a line stay, which can make the result ambiguous. If your items contain commas, this page is the wrong shape. Quote them yourself or use a CSV tool that understands quotes. This page joins with a comma and a space and does nothing else. It does not sort. Order is the order of the lines.

red, green, blue is a sentence list. It is not a CSV row with quoting rules. Oat, rye is the two-item check. If you paste a spreadsheet column, look for empty rows the spreadsheet hid. They disappear here, and the count drops. If the count matches the rows you can see, the join is faithful. If a cell contained a comma, you will see it in the line and you should stop. Split that cell into two lines, or leave this page. The order is top to bottom. A later sort is a different tool. Do not expect this page to remove duplicates. Two identical lines become the same word twice.

Three colours are the long sample and two grains are the short one. Both should match the lines you can see in the box, ignoring blanks. A spreadsheet export sometimes adds a blank line at the end. That line is dropped and the count stays honest. If you needed the blank as an empty field, this join is the wrong tool. An empty field in a CSV is a pair of commas, which this page will not invent. Type the comma yourself if that is the format a program expects. The item count is the number of lines you can still see after blanks are removed.

Three colours

Inputs: Lines: red, green, blue on separate lines

Leave the box as red, then green, then blue, each on its own line, and press Join. The item count is 3.

Result: Items: 3 Comma line: red, green, blue

Two grains

Inputs: Lines: oat and rye

Replace the box with oat on one line and rye on the next, then press Join. The item count is 2.

Result: Items: 2 Comma line: oat, rye

Why is there a space after the comma?

The join is comma-space, so the line reads as a sentence list rather than a jammed CSV.

Are blank lines kept?

No. A line that is empty after trimming is dropped.

Will items be sorted?

No. The first line stays first.

What if an item contains a comma?

It stays. A later split on commas will not match the item count. Use a real CSV writer.

Is this the word stack?

No. Stacked text breaks a sentence into words. This page joins lines you already separated.

Is the list uploaded?

No. The join runs in the browser.