List & Column Converter
Turn a column into a comma list, a comma list into lines, or either into quoted values, a JSON array, an SQL IN list or a numbered list. Delimiter detected.
The same items in the shape the next tool wants — lines, commas, quotes, JSON, SQL, tabs — with blanks dropped, spaces trimmed and the item count stated.
Example: alpha / beta / gamma on three lines → 'alpha', 'beta', 'gamma' as quoted values, or ('alpha', 'beta', 'gamma') as an SQL IN list, or ["alpha","beta","gamma"] as JSON.
Split on one thing,
join with another.
How the delimiter is detected, what each output format writes, and where quoting rules come from.
Splitting
With the delimiter on auto, the page looks for line breaks first (a pasted column), then tabs (a spreadsheet column), then semicolons, then commas, and otherwise splits on whitespace; it says which one it used. Choose the delimiter explicitly when the data contains several — a comma list of names with spaces, for example. Items are trimmed and empty items dropped unless you switch those off. Quoted fields with embedded delimiters (real CSV) are not parsed here; the CSV ↔ JSON utility does that.
Output formats
Lines, comma, comma-space, tab and custom join the items with that separator. Quoted wraps each item in the quote you pick and escapes the same character inside an item with a backslash. JSON writes a JSON array with standard escaping, so it can be pasted into code. SQL writes an IN list in parentheses with single quotes, doubling any apostrophe inside an item (o'neil → 'o''neil'), which is the SQL standard escape; choose "no quotes" for numeric lists. Numbered prefixes 1., 2., 3. A prefix and suffix can be added to every item before joining.
What the tool does not do
It does not parse quoted CSV fields, deduplicate (see Remove Duplicate Lines), change case, or validate that items are numbers. A comma list cannot carry an item that itself contains a comma, and the page says so when that happens. Nothing you enter leaves the browser; the same four anonymous usage counts as the rest of the site apply.