Column to Comma Separated List
Paste a column straight out of Excel or Google Sheets and get one line back. Add quotes for a SQL query, or wrap each item in tags to build an HTML list in a single step.
How to use this tool
- 1Paste your column into the left box — one item per line, straight from Excel or Google Sheets.
- 2The delimited list appears on the right as you type. Press Copy to take it.
- 3Open Settings to change the separator, add quotes, or wrap each item in tags.
- 4You can also paste a delimited list into the right box to turn it back into a column.
What this tool is for
Spreadsheets keep values in a column. Code, settings files and database queries want them on one line. This tool sits between the two. Paste a column of email addresses, product codes, IDs or names, and get back a single line in exactly the shape you need.
Common uses
- SQL IN queries — quotes set to Single, separator a comma.
- CSV cells — comma separator, quotes off.
- Tag and keyword boxes — comma separator with "Remove extra spaces" on.
- HTML lists — item prefix
<li>, item suffix</li>, list prefix<ul>, list suffix</ul>. - Email "To" field — semicolon for Outlook, comma for Gmail.
The cleanup switches
Data copied out of a spreadsheet or a PDF is rarely clean. Remove paragraph breaks drops the blank rows, and remove extra spaces collapses double spaces and trims the ends. Both are applied before remove duplicates, so two rows that differ only in spacing are correctly treated as the same value.
Frequently asked questions
How do I turn an Excel column into a comma separated list?
Select the column in Excel or Google Sheets, copy it, and paste it into the left box. Each cell arrives on its own line and the joined list appears on the right straight away. There is no button to press.
Can I put quotes around each item for a SQL query?
Yes. In Settings set Quotes to Single and leave the separator as a comma. You get 'a','b','c' — ready to paste inside a SQL IN clause.
What is the number in the delimiter box?
It is the character code of your separator. 44 is a comma, 59 a semicolon, 124 a pipe, 9 a tab and 10 a new line. Codes are used because a tab or a new line cannot be typed into a normal text box. The quick buttons set it for you.
What do the item and list prefixes do?
The item prefix and suffix wrap every single value, so <li> and </li> turn your column into list items. The list prefix and suffix wrap the whole result once, so <ul> and </ul> close it off. Together they build a full HTML list in one step.
Can it work the other way around?
Yes. Type or paste into the right box instead and the left box fills with one item per line, ready to paste back into a spreadsheet column.
Is there a limit on how many items I can paste?
No. The work happens in your browser, so a list of ten thousand rows is fine. Nothing is uploaded and nothing is counted.
More free tools you can open
See all tools →Click any card below to open that tool. All of them are free.
- ConvertersComma Separator – Column to CSVComma Separator tool to quickly add commas between words, numbers or lines. Format and separate your text online with ease.Open this tool
- ConvertersCSV to JSON ConverterCSV to JSON Converter lets you quickly convert CSV data into structured JSON format online. Easy, fast and free to use.Open this tool
- ConvertersJSON to CSV ConverterJSON to CSV Converter helps you quickly transform JSON data into CSV format online. Convert structured data easily and efficiently.Open this tool
- ConvertersUppercase to Lowercase ConverterUppercase to Lowercase Converter quickly changes capital letters into lowercase text. Convert and format your text online for free.Open this tool
- ConvertersWord CounterWord Counter counts words, characters, sentences and paragraphs as you type, with reading time, speaking time and a readability score. Free, nothing uploaded.Open this tool
- ConvertersSquare Your Image ToolSquare Image Tool lets you easily crop or resize images into a perfect square. Create square images online quickly and easily.Open this tool