Copy the column, without the heading
Copy only the values from a single column in Excel or Google Sheets. Leave out the heading and any totals: the converter treats each nonblank line as a value, so a heading would appear in the list.
Check how the spreadsheet stores the values before you copy them. If it has already changed 00123 into 123, the missing zeros cannot be recovered later. Store identifiers as text when their exact spelling matters.
Example input
00123
00456
O'Brien
00123Choose Comma-separated and paste the column
Open the comma separator and SQL list builder, paste the column into Your list, and choose Comma-separated under Output format. The default separator is a comma followed by a space. Trim whitespace is on by default and is useful when an export has accidental spaces around values; turn it off if those spaces belong to the value.
Blank lines are skipped. Remove duplicates is optional and off by default. When it is on, the first occurrence of each value is kept.
Example result
00123, 00456, O'Brien, 00123Add quotes only when the destination needs them
If you need a quote around every value, stay on Comma-separated and choose a preset under Wrap each value, or switch the output format to Double-quoted strings. Wrapping in Comma-separated format adds the characters literally and does not escape quotes or apostrophes inside a value, so O'Brien wrapped in single quotes becomes 'O'Brien', which many parsers will misread.
Double-quoted strings uses JSON-style quoting: each value is wrapped in double quotes and internal quotes are escaped. That is the safer choice when a value may contain a comma or a quote. You can also change the separator, for example to a semicolon, in Comma-separated and Double-quoted strings formats.
Example result
"00123", "00456", "O'Brien", "00123"Choose SQL or JSON when you need their rules
Custom wrapping does not provide SQL or JSON escaping. For a query, choose SQL IN strings, which adds the parentheses and single quotes and doubles apostrophes. The spreadsheet-to-SQL guide walks through that workflow. For a JSON array of strings, choose JSON array.
If you have several columns rather than one, use the table converter or the CSV to JSON converter instead of joining the cells into a single list.
Clean the column first if you need to
If the pasted column still contains blank lines, repeated values or messy spacing and you want to tidy it before choosing a format, use Text cleanup. It can remove blank lines and duplicates while keeping the first occurrence of each line. Your list is processed in your browser.