Excel works wonderfully with UTF-8. However, when you need to send a list to other people, their computer may not have Excel installed. The solution would be turning the .xls or .xlsx file into a .csv file and send to your recipients. The convenience of the .csv is that all operation systems support it without any external tool. However, the downside of this method is CSV files doesn’t work well with UTF-8 characters (Asian languages …). So, the list in your Excel file may look flawlessly but become messy in .CSV format.
So, how do you turn excel data into CSV without losing UTF-8 support?
The quick work around would be using Google Sheets. You can paste the data from your excel file to Google Sheets and then export it as .csv file. Doing so will make sure all your data, even in UTF-8 format will not lose its format.
So, hopefully the tips is useful to you. Make sure to come back for more excel tips.