For an external solution, you can convert Excel directly to JSON at https://www.convertcsv.com/csv-to-json.htm or convert Excel to CSV at https://www.convertcsv.com/csv-to-csv.htm
Excellent. Note that on the convertcsv.com CSV to SQL Output Options, you change the text displayed for the Some Date field by either1. modifying the Template for it (last column in Output Options) using CONVERT(DATE,{f}) {f} is the text in Some Da...