Rohini Mathur
Rohini Mathur

Reputation: 441

Ukranian character changing to question mark when save from .xlsx to .txt

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

Answers (2)

Denis Baciu
Denis Baciu

Reputation: 169

you have to use UTF-8 format when you save in .csv or .txtenter image description here

Upvotes: 1

Pankaj Jaju
Pankaj Jaju

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

enter image description here

Upvotes: 1

Related Questions