Excel only places quotes around certain fields, how do I force excel to save a CSV file with quotes around every column?
Seems that even now, Excel has problems saving a proper CSV file. An old ExcelForum.com post lists a number of macros that do the trick.
This page also has the solution which comes straight from the horse's mouth:
If the link degrades, the topic to search for is:
"Procedure to export a text file with both comma and quote delimiters in Excel" and/or "Q291296"
tl;dr: use their macro