Nick Benthem
Nick Benthem
~1 min read
Goal:
Audience:

So this is something I’ve been doing for a long time - if you have a CSV of values and don’t want to write a Python script to read in the results and execute SQL, you can go ahead and use Excel/GoogleSheets/{your favorite spreadsheet program} to create this into a comma seperated list.

Open your data in Excel and place your data in the first column. Add a second column with

=CONCAT("'",A2,"',")

Then expand downwards

ExcelExample

Bam. You’ve now got a list you can use in SQL.