On a Windows computer, click "File > New" in Excel.That's all! Open this new CSV file using Excel - your non-English characters should be displayed properly.In the dialog window that appears - select "ANSI" from the "Encoding" field.On a Windows computer, open the CSV file using Notepad.
To resolve this issue, please do the following after saving the CSV file from your bookings export. When you export the booking data, you will find these special characters are rendered incorrectly in Excel because Microsoft Excel is unable to properly display UTF-8 compliant CSV files when they contain non-English characters. Your bookers may have used special characters when filling out the booking form (such as é, ç, ü,etc). How can I get Excel to properly display special characters in the data export?
0 kommentar(er)
