0

I have an Excel-CSV file contains a foreign language. Originally, it looks like this:

!ЯкутÑк ТЦ "Центральный" фран,1

There is the possibility to encode the text by 65001 unicode (utf-8)

After the encoding, the text looks like this:

!Якутск Орджоникидзе, 56 фран,0

However. if I save the file and open it again it looks like this:

!?????? ????????????, 56 ????,0

How can I keep the encoding which I did by 65001 unicode (utf-8)?

Banjo
  • 1,191
  • 1
  • 11
  • 28
  • Excel naturally stores data in Unicode. Are you sure it is an Excel file (and not e.g. a CSV file)? – GSerg Apr 08 '19 at 09:43
  • Yes, it´s an Excel-CSV. – Banjo Apr 08 '19 at 09:45
  • 1
    Hi, does this solve the issue? https://help.surveygizmo.com/help/encode-an-excel-file-to-utf-8-or-utf-16 – sashimi Apr 08 '19 at 09:46
  • If you just have one `.csv` why don't you save it using `UTF-8` coding when you open it through Notepad? – JvdV Apr 08 '19 at 09:47
  • There is no such thing as Excel-CSV. There is CSV, which Excel can read (and often associates itself with, giving it an Excel icon). The file itself has nothing to do with Excel though. First I would try saving the file as UTF-16. If that is not an option and you want to keep UTF-8, see https://stackoverflow.com/q/6002256/11683. – GSerg Apr 08 '19 at 09:47
  • 1
    You write `save the file and open`, **save** it as what? **open** it with what program? – Ron Rosenfeld Apr 08 '19 at 09:51

0 Answers0