up vote 0 down vote favorite
share [g+] share [fb]

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?

link|improve this question
What version of excel? – Raystafarian Feb 19 at 3:49
Microsoft Excel 2010 – mugur Feb 19 at 19:31
feedback

1 Answer

up vote 0 down vote

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.

link|improve this answer
Actually my Excel is saving CSV in ANSI and not UTF8 or Unicode and I do not know how can I change that. – mugur Feb 18 at 15:09
I also checked this but with no result superuser.com/questions/170926/… – mugur Feb 18 at 15:11
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.