3
0
I have read several other questions on this subject but none have an answer which fixes my problem.
I have an execel file which is in russian and I need to convert it to CSV without it losing any of the special characters because at the moment it just converts them to "?"
So far after reading similar questions I have tried:
- saving to from .xlsx to .xls and then to .csv with no luck
- importing the spreadsheet into google spreadsheets and downloading as .csv with no luck
- downloading OpenOffice and trying to save it as CSV using Calc with no luck
- Changing the encoding within excel when you saveit, going into web options. with no luck
- opening it up in notpadd++ and encoding it as ANSI as well as other types with no luck.
could someone help me out here is there anything else I can try?
I think what is important here is not just that it is a
.csv
file but the program that you are using to open it.Now, Microsoft Excel usesUTF-16
encoding while most other applications that open.csv
files useUTF-8
. I have had issues previously withUTF-8
encoded.csv.
files not being treated properly in Excel (special characters) but other clients being able to handle them okay. – karancan – 2013-06-26T15:09:04.897