2

I have an application where I upload some content in CSV format, however the main document where I have my data is an Excel document.

I use Save As » CSV in order to make a CSV file, but it is not going to save the cyrillic values, instead the text looks like question marks (the system does not let me paste a lot of question marks here).

How do I export it correctly?

slhck
  • 235,242
Mike
  • 131

3 Answers3

1

Excel does not support Unicode encoding when saving as CSV. You can copy your table to a program that does (e.g. Google Sheets) and then export it to CSV in that program.

Glorfindel
  • 4,158
Gregor Ažbe
  • 111
1

In this question, you will find Excel indeed does not preserve unicode characters when saving as csv. Their solution is to save as unicode tab separated text

To save with Unicode encoding in Excel,

Save as, choose text, then next to the save button, you see "tools" menu. Choose web options, then encoding tab, then select the encoding you like. I would suggest to save everything in UTF8, but that is your choice. Note this is in Excel 2007 or above.

Community
  • 1
vinnief
  • 598
  • 5
  • 11
0

do you use correct encoding? I use Libreoffice Calc and there you have to specify output encoding for the CSV or DBF file (and there should be something similar also in Excel). I used this also with some Japanese datasets and it looked OK. I assume that you should use UTF-8 in your case.

Juhele
  • 2,388