How to fix csv file encoding?

Question

Character encoding

Skill krakozyabry! Look:
It should be:
Маша
And what is:
Маша,,женÑкий

Answer 1

Open Excel on the "Data" tab, find the "Get external data" button, select "From text" from the drop-down list, select your csv file, and then follow the instructions that will be in the pop-up window. After all the manipulations, save as you like.

Answer 2

Open in notepad++ and convert.

Answer 3

open in open office, choose utf-8 at startup... As far as I know, in ms office there is no way to edit the encoding

Answer 4

Often this happens if you unload the database in UTF-8. If your MySql is managed by PHPMyAdmin, then just specify encoding 1251 when exporting.

Answer 5

The add-in helped me, now I open CSV in Excel only through it. There is a choice of encoding and delimiters.
https://shopstartup.ru/blog/otkryt-csv-v-excel