List Converter (Lines and Comma Separated)
Turn one-item-per-line text into a comma separated list, with optional quotes, or split a list back into lines. Remove blanks and duplicates too.
Turn one-item-per-line text into a comma separated list, with optional quotes, or split a list back into lines. Remove blanks and duplicates too.
Pasting a column from a spreadsheet into a SQL IN clause or an array needs commas and quotes around each item. This tool does that in one step, and reverses it.
You can also drop blank lines and duplicates while you convert.
apple banana cherry 'apple', 'banana', 'cherry'
Yes. Type it in the Separator box, for example ; or |. Use \n for a new line.
Choose single quotes, which is what SQL string values use.
Yes, each item is trimmed.
No. It is processed in your browser.