Turn a column of values into a comma-separated list

The job

You copied a column out of a spreadsheet or a query result, and the next tool wants the values on one line — a SQL IN() clause, a config list, a tag field. Paste, choose a delimiter, done.

Worked example: SQL IN clause

Paste the emails from a spreadsheet column into the delimiter converter. Direction: lines to a delimited list. Delimiter: comma. Wrap each item in: single quotes. Input of three lines becomes 'ana@example.com','ben@example.com','cy@example.com' — ready to drop into WHERE email IN (...).

Worked example: the other direction

Received a pipe-separated string like red|green|blue? Choose “delimited list to lines”, set the delimiter to pipe, and you get one value per line — convenient for pasting back into a spreadsheet column.

Limits and gotchas

Splitting is literal: if an item itself contains the delimiter — a CSV field like "Tanaka, Taro" — it splits there too, and no quoting is interpreted on the way back. For real CSV files use the CSV to JSON converter, which understands quotes. Very large pastes stop at 200,000 characters or 50,000 items.

• The trim option removes spaces around items — usually what you want for numbers and IDs.
• The custom delimiter accepts any text, including multi-character strings like || or ->.