Why does a CSV file when opened in Excel display strange text for Russian and Chinese language? How can I fix this?

[RosaG]

MOID SP	Display Name In Flight
HUT-GB	Three
HUT-AT	Three
IT3-IT	Three
MEG-RU	МегаФон

<tbody>
</tbody>

 

[RedBeard]

Import them as unicode.
In the Text Import Wizard - select Delimited, and from the File origin drop-down list, select 65001: Unicode (UTF-8) (or the appropriate language character identifier for your particular environment).
In the Preview box, make sure that your unicode text displays properly, and then click Next.