Comma Separator

Turn a column copied from Excel into a comma-separated list for SQL, code or emails, and back again.

Runs in your browser. Nothing is uploaded Free, no sign-up Works on mobile
Convert
Delimiter
Quotes

How to use Comma Separator

  1. Paste your values, one per line.
  2. Choose the delimiter and quotes.
  3. Copy the list. Use Swap to convert back to lines.

Frequently asked questions

How do I make a list for an SQL IN clause?

Choose single quotes and “Comma + space”. The output looks like 'a', 'b', 'c', ready for IN (...).

Can it split a comma-separated list into lines?

Yes. Choose “List → column”.

Related tools

All Text Tools →