Troubleshooting Accented Character Display in CSV Reports
Opening a CSV export report using Microsoft® Excel can cause accented characters (Unicode characters) to display incorrectly. Characters like
ü may not appear correctly.
This error is due to a limitation of Microsoft Excel's handling of these characters and filetypes.
Using a different application can resolve the issue.
To do this, open the file in a different program such as a text editor (for example, Notepad, EditPad, or Sublime) or another spreadsheet program (for example, Apple Numbers).
You can change the character encoding while importing the
.csv file to resolve this issue.
To do this:
- In Microsoft Excel, click New in the File menu.
- Select the Data tab.
- Click From Text and select the CSV file.
- Select Delimited.
- For File Origin, select 65001 : Unicode (UTF-8).
- Click Next.
- Select Comma.
- Click Finish.
Excel will import the CSV contents and display the characters correctly.
You can use a different program to change the character encoding for the file.
To do this:
- Open the
.csvfile in Notepad.
- In the File menu, click Save As.
- In the new window that displays, select ANSI for Encoding.
- Click Save.
- Open the file in Microsoft Excel. The characters should now display correctly.