CSV files can be imported into Microsoft Excel to display data in tabular Unicode (UTF-8) format.
- Open Microsoft Excel.
- Select the Data tab.
- Select the icon From Text.
- Navigate to the location of the CSV file you want to import.
- Select the file and then select Import.
The Text Import Wizard window appears.
- Under File Origin, select 65001: Unicode (UTF-8).
- Under Delimiter, select Comma.
- Select Load to finish importing your CSV data into Microsoft Excel
The data from the CSV file is displayed in a tabular format.