QuickFormatter: Reformat a column for SQL or email with a single click
I don’t really know how best to describe this application, so I’ll just explain why I wrote it. I tend to do a lot of work for marketing departments, and marketing tends to love Excel. They give me spreadsheets containing email addresses, tradeshow leads, customer lists, etc… And then they want me to use these spreadsheets to pull data from a database, send an email newsletter, or do miracles.
For quick ad-hoc queries I found myself writing SQL with WHERE IN clauses, and using the data from a one of the columns in the spreadsheet. So this application lets you copy a single column and paste it into the application window. Click a button and instantly the column is converted to being quoted and separated by commas for use in an IN clause. You can also separate the fields by semi-colon or comma. See the screenshot below for a better idea of what it does.
