With the ITCM r12.9 and 14.0 a new entry is provided in the policy, go to
configuration policy / <Your Default Computer Policy> / DSM / Administration console
here there is a new entry "CSV Export Data Format", by default it is set to "Unicode"
Unseal the policy and change it to "ANSI", seal the policy and verify that the manager have been updated with the changes.
you can issue the next command to verify the results it will be "unicode" or "ANSI"
ccnfcmda -cmd getparametervalue -ps /itrm/adminconsole -pn csvexportdataformat
Close and open the Report Explorer and proceed again with the same steps:
right click on the results and select "open with / Excel desktop (CSV files) "
now the excel is displayed with the results by column, here next the screenshot with the results