Search code examples
excelcsvhindi

Python input csv file not keeping foreign language (hindi) words


I am trying to make a csv file for Python input that will be an input for dictionary conversion from English to Hindi. However whatever I type in Hindi in the csv file gets reduced to question marks. I have seen other people have asked the similar questions here (for a variety of diff languages) and have been asked to try saving the file in unicode-8 format.( When saving go to Tools>encoding) but even doing that hasn't worked for them and is not working for me.


Solution

  • Yes, you want to save the csv file in UTF-8 format. Is this a file you are generating from a text editor, or exporting from some program, or generating in python?

    In most text editors, when you go to Save As, you get the encoding option. Select Unicode UTF-8