How can I export excel to CSV file with UTF-8 encoding?
If I export with default excel encoding I get some artifacts like wrong letters - eg I have some Polish characters like: ó, ź, ą, ę, ł etc.
When I export to csv all those characters get wrong encoding.
3,Pozna? 4,Warszawa 5,Kraków 7,Rzeszów 8,Wroc?aw
First row should be: 3, Poznań
But instead I get: 3,Pozna?
How to solve this problem?
Entire data after export should looks like this:
3,Poznań 4,Warszawa 5,Kraków 7,Rzeszów 8,Wrocław
I use Microsoft Office Excel 2013