CSV Column to List Converter
Turn a Spreadsheet Column Into a Comma-Separated List
Need to use CSV Column to List Converter right now?
Copying a column straight out of Excel or Google Sheets gives you one value per line, but SQL queries, JavaScript arrays, and many form fields expect that same data as a single delimited line instead. Paste the column in and this tool joins it with your choice of comma, semicolon, or pipe, with optional quoting for code and SQL use.
Column of values (one per line)
Result
Features
- Runs entirely in your browser
- Privacy-first — your data is never uploaded
- Real-time, instant results
- 100% free, no sign-up required
- Works on desktop, tablet, and mobile
- No installation needed
Who uses this tool?
About CSV Column to List Converter
Spreadsheet and database exports frequently give you data as a single column — one value per row, pasted as one value per line once you copy it into a text editor — but plenty of other places you need that same data expect a comma-separated (or semicolon- or pipe-separated) list instead: a SQL `IN (...)` clause, a comma-separated tag field, a JavaScript array you're about to paste into code, or a form field that only accepts a single-line, delimited value.
Retyping or manually joining a column of values with commas is exactly the kind of mechanical, error-prone task worth automating — miss a comma, add an extra space inconsistently, or forget to skip a stray blank row, and you end up debugging a subtly malformed list. This tool takes a column of values (pasted directly from a spreadsheet, one per line) and joins them with your choice of separator, handling the spacing and formatting consistently every time.
Three separator choices cover the situations that come up most often: comma (the default and most universal choice, used in CSV-adjacent contexts, SQL IN clauses, and general lists), semicolon (common in some European CSV conventions and certain data formats that reserve the comma for decimal points), and pipe (commonly used as a delimiter specifically because it rarely appears naturally within the data itself, unlike commas which can appear inside text values).
The "wrap each value in quotes" option is essential for a specific common use case: building a SQL `IN ('value1', 'value2', 'value3')` clause or a JavaScript array of strings (`["value1", "value2"]`) both require each individual value to be quoted, not just separated by commas — this tool handles that formatting automatically rather than requiring you to add quotes to every line by hand.
How it works
- Paste your column of values. One value per line, exactly as copied from a spreadsheet or list.
- Choose a separator and formatting. Pick comma, semicolon, or pipe, and whether to wrap each value in quotes.
- Copy the joined result. A single-line, delimited string is generated instantly.
Examples
Joining a column with quotes (for SQL or code)
Input
apple banana cherry
Output
"apple", "banana", "cherry"