When exporting data from our system to a CSV file, you might notice that special characters like macrons do not display correctly when the file is opened directly in Excel. This is due to Excel's default character encoding settings, which may not automatically recognize the file's UTF-8 encoding.
To ensure that these characters display correctly in Excel, please follow these steps to import your CSV file:
-
Open Excel and start with a blank workbook.
-
Go to the Data tab in the Excel ribbon.
-
Click on Get Data → From Text/CSV.
-
In the file browser that appears, select the CSV file you exported from our system and click Import.
-
In the import window:
-
Set File Origin to 65001: Unicode (UTF-8).
-
Set Delimiter to Comma.
-
-
Click Load to import the data.
Following these steps will ensure that all special characters, including macrons, are displayed correctly in Excel.