Recognizing UTF-8 CSV files as default in Excel
From my application I am exporting some data to CSV files, as a default recognition option for multilingual app the CSV is exported in UTF-8 format.
But when I open this file with MS Excel instead of the cyrillic or the greek letters it is showing some symbols like Г–/Г¶.
When opening the same file with notepad, every thing is loaded correctly, but it is difficult to check and do data manipulation in notepad, hence I want to load this file to MS-Excel. but it is not getting loaded there properly.
Is there any method by which we can load correct data of UTF-8 multilingual CSV to MS-Excel.
Please share exact steps.