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.
