Paste a column from a spreadsheet or a list with one item per line. Get one line of comma separated values, ready for SQL, code or a form field. Or switch direction to split a list back into lines.
Data often sits in a column: a spreadsheet of order numbers, emails copied from a CRM, tags from a CMS. Code and query tools want the same values on one line, separated by commas, often in quotes. A SQL query like WHERE id IN (1042, 1043, 1057) is the classic case, and so is a list of email addresses for the To field.
The tool also works the other way. A comma separated line copied from code or an email becomes one item per line, ready to paste into a spreadsheet column. Quotes around items are removed when splitting, so "red", "green" becomes red and green on their own lines.
Input
red green blue
Output
'red', 'green', 'blue'
With comma and space as the separator and single quotes, the column becomes a list you can paste into a SQL IN (...) clause.
Copy the column from Excel or Google Sheets, paste it here and keep the direction on "Lines to one line". Copy the result.
Switch the direction to "One line to lines", pick comma as the separator, and paste the list. Each item goes on its own line.
Yes, with =TEXTJOIN(", ", TRUE, A1:A100) in Excel 2019 or later. Adding quotes needs a longer formula, which is where this tool saves time.