First, go to Data > From Text to launch a Text Import Wizard. But there is a solution you can use to make Excel decode the Unicode CSV file correctly. Is it possible to force Excel recognize UTF-8 CSV, ) from the drop-down list that appears next to File origin. Now at the bottom you will see encoding it set to ANSI change it to UTF-8 and save the file as new file and then your done. One easy way to change excel ANSI encoding to UTF-8 is the open the.csv file in notepad then select File > Save As.
csv file that uses UTF-8 character encoding, Choose the file type that best describes your data - Delimited or Fixed Width.