Make a list from Excel Column for SQL

Use this free Jet City Data tool to convert a vertical list of data into a comma separated list with or without quotes. Good for use in SQL queries.

Add Quote:



If you have a long list of values, say you are copying it from Excel or whatever, and you need to paste it into an sql query, just use the handy form to convert your column of data in to a comma separated list. Choose single quotes, or whatever other delimiter you need. For some reason the select all part of the javascript does not work, but I hope to fix that in the near future. If anybody has any ideas on that, please contact Jet City Data and let us know! Thank you again for using the free tools from Jaydata.