To open a CSV file correctly, first open Excel and create a blank workbook.
Select „Data“ in the ribbon.
Now click on „Get External Data“ in the ribbon.
Next click on „From Text“.
Select the file you want to open.
In the first the step in the opened window select the file origin in order for all special characters to be displayed correctly, as shown in the pictures below (for a “recipients” file the file origin is “Unicode (UTF-8)”).
False file origin:
Correct file origin:
In the second step select the delimiter for the date being separated, as shown in the pictures below (for a “recipients” file the delimiter is “Comma”)
Select “Text” as column data format for all columns and click on “Finish”.
If a window pops up, click on “OK”.