CSV: An Encoding Nightmare
It would appear in a recent update Microsoft has added support for safely reading and writing UTF-8 CSVs to Excel. There is a new format in the save dialog CSV UTF-8 (Comma delimited) which is distinct from Comma Separated Values which is also still in there.
In my testing it appears to safely bot…
Read More / Comment »