exportify icon indicating copy to clipboard operation
exportify copied to clipboard

Unicode names displayed wrong

Open ozanbdesign opened this issue 2 years ago • 3 comments

great project thank you

my issue is when i export csv

unicode names in filename.csv are right

however inside csv file, song filenames are wrong and replaced by other characters

for example in spanish for ñ or similar characters

ozanbdesign avatar Jul 10 '23 08:07 ozanbdesign

Hi yeah I have the same problem with all non-latin characters i.e. Chinese or Japanese with this.

Is there anyway around this?

Hydramus avatar Jul 29 '23 22:07 Hydramus

Hi yeah I have the same problem with all non-latin characters i.e. Chinese or Japanese with this.

Is there anyway around this?

I found an way to solve it.(My eng is unskillful,maybe has some mistake on expression) use notepad open the csv file,you can see Encoding format which the csv file use (In the bottom right corner and Maybe it's utf8) close the notepad ,open the csv files by Excel(do not use WPS because I haven't tried before). found data-‘get Data’-'from file'-'from text/csv' choose your csv file an it will open an new page, choose"65001:unicode(UTF-8)" and you can see it show correct word (the chinese and japanese are correct show in my computer and may spanish can work too) push "load" and the correct list will save to your CSV file

Huang2326 avatar Aug 29 '23 03:08 Huang2326

Thanks to @Huang2326 for the inspiration, in fact, you can directly import data in a new Excel file, just select utf8 encoding. Here is an operation process, I hope it can help you. demo

JimZhu6 avatar Sep 03 '23 12:09 JimZhu6