Turn a column of lines into a comma separated list, and back.
The comma separator converts a list with one item per line, such as a column copied from Excel, into a single line separated by commas, semicolons, pipes, spaces or tabs, and back. Wrap each item in single or double quotes to build SQL IN lists or code arrays.
Spaces can be trimmed, empty items skipped and duplicates removed in the same step.
Lines to a list, and a list to lines.
Comma, comma and space, semicolon, pipe, space or tab.
Single or double quotes, with quotes inside items escaped.
Trim spaces, skip empty items, remove duplicates.
Paste the values, choose comma and single quotes, then wrap the result in parentheses.
Copy the column, paste it here and choose the delimiter.
They're doubled, e.g. it's becomes 'it''s', which is valid SQL and CSV.
Yes, choose List to lines.