USEFUL DETAILS
Keep your codes intact.
Leading zeros stay put. Blank lines are skipped. Choose custom wrapping for quotes or brackets, or SQL IN strings for SQL escaping. For several spreadsheet columns, use the table converter.
The toolkitLists & tables
Comma separator & SQL lists.
Paste a column of values. Get a comma-separated list, quoted strings, a SQL IN list or a JSON array.
Custom wrapping adds characters literally. SQL and JSON formats apply their own escaping.
SQL strings use standard doubled-quote escaping. Paste the result after IN in your query.
Quick start
- Paste a single column from Excel or Google Sheets.
- Choose the separator and wrapping, or select SQL IN strings or JSON array.
- Copy the result or download it as text.
Product codes → SQL list
Format: SQL IN strings. Codes keep their leading zeros.
Input
00123
00456
00789Result
('00123', '00456', '00789')Common questions
How do I turn an Excel column into a comma-separated list?
Copy the cells in a single column, paste them into Your list and select Comma-separated. Each nonblank line becomes one value. This tool handles a single column; use the table converter for a whole spreadsheet table.
Can I wrap every value in quotes or parentheses?
Yes. In Comma-separated format, choose a wrapping preset or enter Before each value and After each value. For example, parentheses turn apple and pear into (apple), (pear). Custom wrapping adds the characters literally; choose SQL or JSON format when you need those formats' escaping rules.
Will leading zeros and apostrophes survive?
Leading zeros stay intact because values are treated as text. SQL mode wraps each value in single quotes and doubles embedded apostrophes: O'Brien becomes 'O''Brien'. Check the generated text against your database's requirements before using it in a query.