Join lines and separate with commas
Turn a list (one per line) into comma-separated items, with quotes or in SQL IN format, or do the reverse and split into lines.
How to usePaste the list.
Available in: 
Join lines and separate with commas: what it is for
Paste an Excel column or a list with one item per line and see it all on one line, separated by commas, semicolons, spaces or tabs, with or without quotes. SQL mode builds the IN ('a', 'b') clause with quotes already escaped. In reverse mode, the tool splits the text into lines by the chosen separator.
How to use
- Paste the list.
- Choose join or split and the separator.
- Copy the result.
When to use it
- Building SQL filters from Excel.
- Pasting a list of emails into the To field.
- Turning comma-separated tags into a column.
Frequently asked questions
What is it for?
To take an Excel column into an email, a filter or an SQL query, or to turn a comma-separated list back into a column.
How do I do the reverse?
Choose Split into lines and enter the separator used in the text, like a comma or semicolon.
Is it really free?
Yes, 100% free. No sign-up, no subscription and no usage limits. All Tools123 tools are free and run right in your browser.