0

My webapp generates a CSV file with normal UTF-8 encoding which contains Cyrillic symbols. The file reads just fine in python and the results also display in the browser. However, when I open it in programs like Excel or Editor, the cyrillic symbols are replaced by plain "????".

I tried adding a cyrillic font and adding a cyrillic keyboard, but it didn't solve the issue. I am running Windows 7 in German. Does anybody have any tips?

UPDATE

The problem even happens on a Russian laptop which normally supports cyrillic. On some forums I read something about a windows encoding - could this be the issue?

Vincent
  • 1,067
  • 17
  • 38
  • Try prepending a UTF-8 BOM to the file. `u'\ufeff'`. Windows programs like notepad are really fond of UTF-8 boms even though it is not required for byte ordering nor for detecting UTF-8. – Esailija Apr 17 '13 at 09:49
  • What happens when you copy/paste to Excel? – Pleun Apr 17 '13 at 09:50
  • When I copy and paste to Excel, it show's correctly. – Vincent Apr 17 '13 at 09:51
  • Esailija - would you have any suggestion where to look for more information on how to do this? – Vincent Apr 17 '13 at 10:09
  • 1
    See http://stackoverflow.com/questions/155097/microsoft-excel-mangles-diacritics-in-csv-files which talks about issues with Excel importing UTF-8 CSVs. – borrible Apr 17 '13 at 10:27

0 Answers0