2
1
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?
Mike
Posted 2012-02-18T14:03:30.033
Reputation: 119
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.
Gregor Ažbe
Posted 2012-02-18T14:03:30.033
Reputation: 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.
vinnief
Posted 2012-02-18T14:03:30.033
Reputation: 511
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
Posted 2012-02-18T14:03:30.033
Reputation: 2 297
Actually my Excel is saving CSV in ANSI and not UTF8 or Unicode and I do not know how can I change that. – Mike – 2012-02-18T15:09:13.887
I also checked this but with no result http://superuser.com/questions/170926/saving-a-file-in-a-csv-type-in-excel-always-removes-the-bom
– Mike – 2012-02-18T15:11:12.467
What version of excel? – Raystafarian – 2012-02-19T03:49:29.340
Microsoft Excel 2010 – Mike – 2012-02-19T19:31:28.947