Exported csv file code irrecognized

[adamp4]

Hi, Ard

Thanks a lot for sharing such innovative & efficient tool.
The idea to combine spreadsheet & mindmap is so cool which could manage info just like a database, i really appriciate it and would truly recommend it to all of my friends.
The only lack i found is the code "utf-8" of exported csv file is irrecognized by excel which could only recognize ANSI and could never be set as utf-8 ( office 2010).
Could you kindly add a option of exported csv file code or change the code to ANSI by default? It would be very helpful for Asian users like me.

Best Wishes
Adam Wu

[aardappel]

I personally have no idea how to encode unicode chars as ANSI. Suprising Excel can't handle unicode??

@t2b3 any idea?

[adamp4]

I personally have no idea how to encode unicode chars as ANSI. Suprising Excel can't handle unicode??

@t2b3 any idea?

Thanks for your kind reply, i just found the code "UTF-8 with Signature" also works, pls find recoded exported csv below as reference.
1.csv

[tobiolo]

I personally have no idea how to encode unicode chars as ANSI. Suprising Excel can't handle unicode??

@t2b3 any idea?

Sorry, I have no idea.
Seems that "ANSI" itself is not a well-defined term, but either way the ANSI codepage does not include characters from Asian character sets... Maybe this can help?
https://answers.microsoft.com/en-us/msoffice/forum/all/how-to-open-utf-8-csv-file-in-excel-without-mis/1eb15700-d235-441e-8b99-db10fafff3c2