Convert a Column to a Comma Separated List

It splits your text on every line break, handling Windows CRLF, old Mac CR and Unix LF endings alike. By default it trims whitespace around each value and skips empty lines, optionally wraps each value in your chosen quote character, then joins the remaining values with the delimiter you selected.

The Join with menu offers comma and space, a bare comma, semicolon and space, pipe, a single space, and tab. Comma and space is the default because it reads well in prose, while a bare comma or tab suits pasting into spreadsheets and code.

Yes. Tick Wrap in quotes and every value is surrounded by the quote character you pick: double, single, or backtick. This is handy for building a SQL IN list, a JavaScript array, or any code that expects quoted strings. The quotes are added before the delimiter joins the values.

Yes. Click the swap button and the tool reverses direction, taking a delimited list and putting one value on each line. In reverse mode it splits on the chosen delimiter, trims each piece, and drops empty results, so a stray trailing separator does not leave a blank line.

With Trim spaces on, leading and trailing whitespace is stripped from each value, and with Remove blank lines on, empty lines vanish entirely. Turn either option off to preserve the original spacing or keep placeholder blank lines in the output.

There is no fixed cap. The conversion runs in your browser, so the practical limit is your device's memory. Thousands of lines convert instantly, and the character count under the output shows how large the result is.

Yes. This tool joins whatever values you paste and does not remove duplicates. If you need a unique list, remove duplicate lines first with a dedup tool, then paste the cleaned column here.

It uses the delimiter shown in the menu. When you swap into reverse mode the label changes to Split on, and the list is broken apart wherever that separator appears. Choose the separator that matches the list you are pasting in.

Yes. Everything happens locally in your browser and nothing is sent to a server, so pasted values, names or IDs never leave your device.