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?
Best Answer
This is a well known issue with saving CSV files in excel, and I do not believe it is possible to solve directly. However an addon such as this one (includes source) can be used to get around the issue.