have generate csv file includes double byte characters (chinese, japanese), csv file opens , text reads correctly when use text editor.
but generated csv file show garbage text when opened in excel, did miss?
unfortunately don't miss something. microsoft not able handling csv files unicode if opening them excel.
if excel saves csv files, uses not unicode encoding per default other iso encodings dependent of office language version. not unicode not default, although stand of art in 21 century, furthermore not possible use unicode while saving csv excel. file format can save unicode unicode text (*.txt). tabulator delimited text format instead of csv.
so if excel opening csv files, not assume unicode in it. instead assume same default encoding use while saving csv. thats why garbage characters occur if there is unicode in csv.
there 1 exception. if csv utf-8 encoded and there utf-8 bom @ beginning of file and delimiter default delimiter, then excel can open csv properly.
but there text import wizard. if using this, can determine encoding in step 1 file origin. 65001 : unicode (utf-8) utf-8. wizard should able import csv files properly.
