No worries. Here is how you can Display CSV Files with Unicode UTF-8 Encoding in Excel.

Step 1: First, open a blank excel sheet.

Step 2: Then, go to Data > From Text to launch a Text Import Wizard.


Step 3: Select the CSV file that you want to view and click “Import”.

Step 4: Now select the file origin to pick “65001: Unicode (UTF-8)”, this will turn your CSV file into something that’s legible.

Sterp 5: Then click “Load”, it will automatically load the transformed data into the blank excel sheet.  You should be able to see all your CSV Unicode characters come back to life.