Comma separator for emails
Paste a list of email addresses — one per line, from a spreadsheet column, or buried in text — and get it back comma separated, semicolon separated, or one per line. Ready to paste into Gmail, Outlook, or your code. No sign-up.
Why you need a comma-separated email list
Email clients and code want addresses in one specific shape. Gmail's To, Cc and Bcc fields expect addresses separated by commas; classic Outlook expects semicolons; a spreadsheet wantsone address per row; and a SQL IN clause or a JSON array wants each address wrapped in quotes. But the list you have is almost always in the wrong shape — a column copied from Excel, a forwarded thread, a CRM export. This tool converts between all of those shapes in one paste.
How it works
- Paste anything containing email addresses into the left box — a column, a comma list, or messy text.
- Every address is detected automatically, whatever it's currently separated by.
- Pick your output separator: comma, comma + space, semicolon, new line, space, or a custom one.
- Optionally wrap each address in quotes, then copy the result or download it as a .txt file.
Because the input is parsed for email addresses (not just split on line breaks), stray spaces, blank lines, names next to addresses and duplicate entries never end up in your output.
Gmail vs Outlook: comma or semicolon?
Gmail and most modern clients accept commas between recipients. Classic Outlook defaults to semicolons and will show an error like "check the recipient name" if you paste a comma-separated list (you can enable commas under File → Options → Mail → "Commas can be used to separate multiple message recipients").Outlook on the web accepts both. If in doubt, generate a semicolon-separated list for Outlook and a comma-separated one for everything else — switching takes one click here.
Part of the toolkit
Formatting is usually the last step. Pull addresses out of raw text with the email extractor or out of a spreadsheet with theCSV extractor, tidy the list with the email list cleaner orduplicate remover, check it with the email validator — then come back here and format it for wherever it's going.
Frequently asked questions
How do I convert a column of emails to a comma-separated list?
Copy the column in Excel or Google Sheets, paste it into the box on the left, and the comma-separated version appears instantly on the right. Duplicates are removed automatically (you can turn that off), and one click copies the whole list.
Does Gmail use commas or semicolons between email addresses?
Gmail separates addresses with commas. Outlook traditionally uses semicolons — pasting a comma-separated list into classic Outlook can fail unless you enable commas in its settings. This tool outputs either format, so pick Comma for Gmail and Semicolon for Outlook.
Can I convert a comma-separated list back to one email per line?
Yes — it works in both directions. Paste your comma- or semicolon-separated list and choose the New line separator to get one address per line, ready for a spreadsheet column or a CRM import.
Can I wrap each email in quotes?
Yes. Choose double or single quotes and each address is wrapped individually — e.g. "a@x.com", "b@y.com" — which is handy for SQL IN clauses, JSON arrays, or code.
Is my email list uploaded anywhere?
No. The conversion runs entirely in your browser with JavaScript. Your list is never uploaded, stored, or logged — nothing leaves your device.