Reputation: 441
I have received an .xlsx
file with ukranian characters in one of the fields, but when i try to convert to .csv
or .txt
the ukranian characters are changing to question marks. Why is this happening?
.xlsx
:
'UAH', 'Колодки тормозные дисковые, комплект' UNION ALL
'UAH', 'Колодки тормозные' UNION ALL
'UAH', 'Колодки тормозные дисковые, комплект' UNION ALL
'UAH', 'Автозапчасть' UNION ALL
'EUR', 'This Is Test' UNION ALL
'EUR', 'This Is Test' UNION ALL
'EUR', 'This Is Test' UNION ALL
'USD', 'This Is Another Test' UNION ALL
'USD', 'This Is Another Test' UNION ALL
'USD', 'This Is Another Test'
when saved as .csv
or .txt
CURR DESCC
UAH ??????? ????????? ????????, ????????
UAH ??????? ?????????
UAH ??????? ????????? ????????, ????????
UAH ????????????
EUR This Is Test
EUR This Is Test
EUR This Is Test
USD This Is Another Test
USD This Is Another Test
USD This Is Another Test
Upvotes: 1
Views: 613
Reputation: 5471
Save it as Unicode Text (*.txt). You can then change the name to .csv
PS: I tested this on Office 2010 and it works
Upvotes: 1