search

watsonbox / exportify

Export/Backup Spotify playlists using the Web API
https://exportify.app/
MIT License
3.15k stars 436 forks source link

Unicode names displayed wrong #145

Closed ozanbdesign closed 8 months ago

ozanbdesign commented 1 year ago

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

Hydramus commented 1 year ago

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

Is there anyway around this?

Huang2326 commented 1 year ago

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

JimZhu6 commented 1 year ago

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