Allow Excel to open report (csv) without worrying about encoding
The encoding for such csv file is in UTF-8 (no Byte Order Mark) and Excel failed to interpret such file, resulting in non-Unicode character turning garble.
Since we open this report in a Spreadsheet software like Microsoft Excel, it would be beneficial to have Byte Order Mark added to the csv report in the first place.
The workaround now is either
1) Open the csv file in a modern text editor and re-save it using UTF-8 (with Byte Order Mark)
2) Open a blank spreadsheet on Excel. From "Data" tab click on import from text data source. The manually imported csv files would be correctly imported.
Both workaround would required few extra steps before getting the report display correctly.
AdminRaymond Chan
(Admin, Box)
shared this idea
-
Anonymous
commented
I think this is due to the stupid Microsoft Corporation. However, I am in favor of this idea, because we are forced to obey a huge fool.