Turning a column of values into a single comma-separated line (or the reverse) is a one-line job in code but a fiddly one by hand, especially once quoting and escaping are involved. This converts a column of lines into a comma-separated list, or splits a delimited list back into one item per line.

When you'd use this

Building a SQL `IN (...)` clause from a pasted list of IDs, turning a column copied from a spreadsheet into a comma-separated value for a config file or API parameter, or splitting a long comma-separated string back into a readable list.

Common errors

A value that itself contains a comma needs quoting to survive the round trip without being split incorrectly - if a converted list looks like it gained extra items it shouldn't have, check for unquoted commas inside the original values.

Frequently asked questions