List Converter
Turn a list into comma-separated text, and back.
Questions
How do I turn a column from a spreadsheet into a comma-separated list?
Copy the column (each cell becomes a line), paste it here and keep “Lines to separated text”. Choose “Comma” for no spaces, or add quotes around each item for SQL IN (...) lists and code.
How do I split comma-separated text into lines?
Choose “Separated text to lines” and the separator your text uses. Spaces around each item are trimmed, and quotes around items are removed when you pick the same quote style.
What does “and before the last item” do?
It writes the list the way a sentence would: “apples, pears and plums”.
Is it free? Do I need an account?
It is free to use and there is nothing to sign up for. There are no watermarks and no daily limits.
Missing something, or not working as it should? Tell us