What is natural sort?

Natural sort compares runs of digits as numbers, so item2 comes before item10. A plain alphabetical sort compares character by character and would put item10 first.

How do I make a quoted, comma-separated list for SQL?

Set the output separator to comma + space, choose single quotes, and wrap the result with ( and ). Quotes inside items are escaped with a backslash, which some SQL dialects do not accept (standard SQL doubles the quote instead), so check items that contain apostrophes.

List Converter: Comma, Newline & Delimiter Lists

Convert delimited lists between common separators and count their items locally.

About List Converter

Convert a list between separators: new line, comma, semicolon, tab, whitespace, pipe or a custom string, with the input separator auto-detected. Along the way you can trim items, remove empty entries, deduplicate (optionally case-insensitive), sort alphabetically, in reverse, naturally or by length, reverse the order, quote items, add a prefix or suffix to each and wrap the whole result. The item count is shown before and after.

Common uses

Turn a column copied from a spreadsheet into a comma-separated list.
Build a SQL IN (...) clause by quoting items and wrapping them in parentheses.
Deduplicate and sort a list of email addresses, tags or IDs.
Convert a comma-separated string into one item per line.

FAQ

What is natural sort?: Natural sort compares runs of digits as numbers, so item2 comes before item10. A plain alphabetical sort compares character by character and would put item10 first.
How do I make a quoted, comma-separated list for SQL?: Set the output separator to comma + space, choose single quotes, and wrap the result with ( and ). Quotes inside items are escaped with a backslash, which some SQL dialects do not accept (standard SQL doubles the quote instead), so check items that contain apostrophes.