Column to CSV Row
Turn a column of values into a single comma-separated CSV row, with the right quoting, dedupe and sorting.
Drag & drop a .txt or .csv file, or click to browse
How it works
Paste a column copied straight out of Excel, Google Sheets or a database result grid —
one value per line — and it is joined into a single comma-separated CSV row as you type.
Pick the separator (comma, comma + space, semicolon, tab, pipe, space or any characters you
type) and choose how values are quoted: only when needed, never, or always with double or
single quotes. Single quotes plus commas is exactly the shape a SQL
IN ('a', 'b') list wants; “only when needed” follows RFC 4180 and wraps a value
only if it contains the separator, a quote or a line break, doubling any quotes inside it so
the row stays valid CSV.
Trim, skip blank lines, remove duplicates and sort A→Z are one click each, and the Direction switch reverses the whole thing — paste a CSV row and get the column back, with quoted fields unwrapped correctly. Copy the result or download it as a file. Everything runs in your browser with JavaScript: nothing is uploaded, stored or logged, so it is safe for customer IDs, email lists and export data.
Frequently asked questions
How do I turn a column from Excel into a comma-separated list?
Copy the column in Excel or Google Sheets and paste it into the input box — one value per line is exactly what the tool expects. The joined CSV row appears instantly below. Pick a separator (comma, comma + space, semicolon, tab, pipe, space or your own characters), tick Trim, Skip blank lines, Remove duplicates or Sort A→Z if you need them, then use Copy result or Download file.
What happens to values that already contain a comma?
With the default "Only when needed" quoting they are wrapped in double quotes and any quotes inside them are doubled, following RFC 4180 — so Portland, OR becomes "Portland, OR" and the row stays a valid CSV instead of silently gaining an extra column. You can also force quotes on every value, switch to single quotes for a SQL IN ('a', 'b') list, or turn quoting off entirely.
Is my data uploaded anywhere?
No. The joining, splitting, quoting and deduplication all run in your browser with JavaScript, so the values never leave your device and nothing is stored or logged. That makes it safe for customer IDs, email addresses and export data — unlike converter sites that post your text to their server, and there are no ads or sign-ups here.