Column to Comma Separated Converter
Paste a column of values and join them into a comma, semicolon, pipe, or custom-delimited list. Flip the direction to split a delimited list back into a clean column.
How to use the column converter
- Paste your column or list. Drop one value per line for column-to-delimited, or paste a single delimited string for delimited-to-column.
- Pick a direction and a delimiter. Direction sets join vs split; the dropdown picks comma, semicolon, pipe, tab, or your own custom string.
- Copy or download. The output box updates as you type. Use Copy for a quick paste into a spreadsheet, or Download to save a .txt file.
One tool, four conversion patterns
This page bundles the four most common column-and-list conversion jobs into one widget. Use the Direction toggle and the Delimiter dropdown to switch between them without leaving the page.
- Column to comma: Direction "Column to delimited", Delimiter "Comma".
- Comma to column: Direction "Delimited to column", Delimiter "Comma".
- Column to semicolon: Direction "Column to delimited", Delimiter "Semicolon".
- Semicolon to column: Direction "Delimited to column", Delimiter "Semicolon".
The same widget also covers pipe, tab, and any custom delimiter. Splitting four pages out would dilute ranking for what is functionally a single job: turn a vertical list into a horizontal list, or back.
When you need this converter
Spreadsheet and CSV preparation
Turn a column from Google Sheets or Excel into a CSV row, or paste a CSV row into a fresh column. Quote-wrap to keep commas inside values intact.
SQL IN-clause building
Convert a column of customer IDs or emails into 'a','b','c' for a WHERE id IN (...) query. Turn on Wrap in quotes and pick comma.
Site-list pasting for search
Build a Google search like site:a.com OR site:b.com OR site:c.com by pasting a column and joining with a custom OR site: delimiter.
Name list cleanup
Receive a list of names mid-paragraph, split on comma to get a clean column, trim each value, and drop the empties left by trailing punctuation. For a one-step cleanup of stray commas, hand the result to our comma remover.
Email recipient list construction
Take a column of email addresses from a CRM export and join with comma-and-space for the To: field of an email client, or with semicolon for Outlook.
Programmatic list flattening
Convert pasted log lines into a single line, or split a long comma-delimited config value back into one item per line for review.
What is column-to-delimited conversion?
Column-to-delimited conversion is the boring middle step that sits between two tools that do not speak the same shape. A spreadsheet stores values vertically (one cell per row, one value per cell). A SQL query, an email To: field, a JSON array literal, or a URL query string wants them horizontally on one line, glued together by a chosen separator. The job of this converter is to flip between those two shapes without losing values, blanks, or quoted commas in transit.
The typical workflow is four steps. You highlight a column in Sheets or Excel, copy it to the clipboard, paste into this widget, and pick a delimiter. The reverse flow does the same in the other direction: paste a delimited line, and the tool hands you a column you can drop straight back into a spreadsheet cell range.
Select the column or column range in Google Sheets, Excel, or Numbers. The clipboard captures one value per line by default.
Drop into the Input box. Each row becomes one entry. Blank rows survive unless you turn on Remove empty values.
Comma for CSV, semicolon for Outlook, pipe for SQL, tab for TSV, or a custom string for niche formats.
The output updates live as you type. Use Copy for clipboard paste, or Download for a saved .txt artifact.
The reverse direction (delimited to column) is the same flow run backward. Paste a long single-line value, pick the delimiter that joins it, and the tool fans the values out into rows you can paste into a spreadsheet, a column field in a form, or a YAML list.
Common delimiters and where each one shows up
The widget supports six built-in delimiters plus a custom field. The table below shows the canonical use case for each, and the trap that catches most people when they pick the wrong one.
| Delimiter | Output looks like | Typical use case | Watch out for |
|---|---|---|---|
Comma , | red,green,blue | CSV exports for Excel and Sheets, comma-separated config values, JSON-array stringification. | Commas inside values (addresses, full names). Turn on Wrap in quotes so the importer treats the value as one field. |
Semicolon ; | red;green;blue | Outlook recipient lists, European CSV (where comma is the decimal separator), some PHP and Java config files. | European number formats already use the comma as a decimal point; that is why their CSV switches to semicolon. |
Pipe | | red|green|blue | SQL IN alternatives, log-file fields, regex alternation, and any data set where commas and tabs appear inside values. | Pipe is hard to type on some keyboard layouts (Shift+Backslash on US). Confirm the consumer expects it. |
Tab \t | red green blue | TSV files, paste-into-spreadsheet flows that drop values across columns, IDE clipboard for table data. | Tabs are invisible in plain text. The output looks like whitespace; trust the tool and paste into a TSV-aware target. |
Space | red green blue | Command-line argument lists, search-query strings, simple human-readable rows. | Useless for any value that contains a space. Use only when every value is a single token (codes, IDs, single words). |
| Newline | one value per line | This is the column form. Pick it on the reverse direction to break a delimited string back into a column. | Trailing newlines produce a blank last entry. Remove empty values cleans this on output. |
| Custom | your choice | Email lists with , (comma plus space), SQL quoted lists with ', ', URL query joins with &, site-list joins with OR site:. | Type the exact characters including spaces. Trailing spaces in the custom field are kept and matter. |
If the destination is software you control, pipe is the safest pick (rarely appears in human-typed values). If the destination is a spreadsheet, comma is the default and Wrap in quotes handles the edge cases. If the destination is an email client, semicolon for Outlook and comma-plus-space for Gmail covers the two big targets.
Related tools
Frequently asked questions
How do I handle commas that appear inside my values?
If your values contain commas (for example, Smith, John), use a different delimiter such as semicolon or pipe, or turn on Wrap each value in quotes. Quoted CSV output is the standard way to keep commas inside a single cell when a tool consumes the file.
Does it parse CSV-quoted values when going the other direction?
Yes. When you split a delimited list back into a column, the converter respects double-quoted fields and treats the comma inside the quotes as part of the value, not as a separator. This matches the RFC 4180 CSV rule used by Excel and Google Sheets.
What happens to empty lines or empty values?
The Remove empty values toggle is on by default. With it on, blank lines and zero-length tokens are dropped before joining or splitting. Turn it off if you need to preserve every position (for example, when the row order matters and a missing value is meaningful).
Can I use a multi-character custom delimiter?
Yes. Pick Custom from the Delimiter dropdown and type any string in the field below it. The converter splits or joins on the exact string, so | (pipe with spaces), ::, or AND all work. Avoid characters that also appear inside your values, otherwise the split will cut a value in half.
Does it handle Unicode and non-English characters?
Yes. The tool processes text as UTF-16 internally, so accented letters, CJK characters, emoji, and combining marks are preserved on both join and split passes. Trimming uses Unicode-aware whitespace, so non-breaking spaces and zero-width characters are stripped from the edges.
Why is pipe a safer delimiter when building a SQL IN clause?
Pipe (|) almost never appears in names, addresses, or free-text data, so splitting on pipe will not accidentally cut a value in half. For a SQL IN clause you usually still want comma-separated quoted strings; build the list with Wrap in quotes on and Delimiter set to comma, but use pipe as a sanity-check intermediate format when the source data is messy.
Can I paste a column copied from Excel or Google Sheets?
Yes. When you copy a single column from a spreadsheet, the clipboard contains one value per line separated by a newline. Paste it into the input box, leave Direction on Column to delimited, and pick the delimiter you need. The converter treats each newline as a row boundary.
I'm pasting a column from a confidential spreadsheet (internal financials, employee lists, customer SKUs). Does any of it touch your servers?
No. The conversion is a string-join in the page's JavaScript. The pasted cells, the chosen delimiter, and the joined result all stay in the browser tab. There is no upload step, no analytics ping carrying the values, and no cache-write outside your own local browser storage. See also: Remove Line Breaks.
More wordcounter.ai tools
Other tools you might find useful.