Free Comma Separator: Convert a List to Comma Separated Values
Convert a column of items into a comma separated list, or split a comma list back into lines. Choose the separator, add quotes and remove duplicates as you convert.
How to use the comma separator
- Paste your list. It can be a column from Excel or Google Sheets, or a comma list from an email.
- Leave “Detect automatically” on, or choose how the items are separated.
- Choose how to join them: commas, new lines, semicolons, pipes or tabs.
- Add quotes if you need them, for example for code or SQL, and copy.
Common conversions
| From | To | Use |
|---|---|---|
| Spreadsheet column | Comma and space | Paste locations or interests into ad targeting |
| Comma list | New lines | Paste into a spreadsheet column |
| Keyword list | Double quotes, comma | Code, CSV files and APIs |
| Email addresses | Semicolons | The To field in Outlook |
| Tags | Comma | WordPress tags and YouTube tags |
Tips
- Turn on “Remove duplicates” when merging lists from different sources.
- For YouTube tags, keep the total under 500 characters. Check it with the character counter.
- To add the same text before or after each item, use our prefix and suffix tool.
More free tools and guides
Learn this hands-on
Practise tools like this on real projects in our digital marketing course in Faridabad, with weekday, weekend and online batches.
See the courseAll free toolsAsk on WhatsApp
Frequently Asked Questions
Is this comma separator free?
Yes. It is free with no sign-up and works in your browser.
How do I convert an Excel column to a comma separated list?
Copy the column from Excel, paste it here and choose Comma and space. Each row becomes one item in the list.
How do I split a comma list into lines?
Paste the comma list, choose Commas as the input separator and New line as the join option.
Can I put quotes around each item?
Yes. Choose single or double quotes in Wrap each item in. Quotes inside items are escaped.