I've searched for XQuery tranformation support on WMB and WTX but no luck. Does anyone know if WMB is able to do XQuery message transformation/enrichment?
Try openning the csv file using File -> Open.. inside Excel instead of double clicking the csv file directly. You can then choose the character set Excel uses to read the file.