Quote:
Originally Posted by StefanM
Same with the tsv settings file, created by mgpai's script:
Doubleclicking for opening it in Excel results in corruption of some strings.
So, you have to import it, select UTF-8,...
Also haven't found a way to tell Excel that I want to open all files as UTF-8.
Question 1:
You seem to be pretty familiar with Excel, too.
Any ideas, e.g. how to let Excel treat all *.txt, *.csv, *.tsv, ... as UTF-8?
|
I don't even have/use Excel
I just google those answers
Please see:
lukemiller.org/journal/2005/03/changing-default-text-import-origin.html
smallbusiness.chron.com/open-utf8-excel-63726.html
It seems Excel does support BOM, see
superuser.com/questions/911369/excel-change-default-encoding-file-origin-of-text-import-wizard-to-utf-8-650
@mgpai: see stackoverflow.com/questions/4389005/how-to-add-a-utf-8-bom-in-java, just have to add the BOM character at the beginning of the string should do it, for example