Getting Excel to properly show accented characters

When using addons that export to CSV such as Export Results and Reporting & Analysis, the CSV’s files are generated to be UTF-8 compliant. This is done to ensure that our users can work with the CSV’s on a variety of operating systems using a variety of programs. However, you may have run into an issue with importing the CSV into Excel if your results contains accented characters (such as é, ç, ü, etc) used in many different languages.

To resolve this, we have two different methods you can use:

Solution 1

1. Open the CSV in Notepad.
2. Click “File” and “Save As”.
3. In the new popup that displays,  select “ANSI” from the “Encoding” field.
4. Click “Save”.
5. Now, you should be able to open the file in Excel and display the characters correctly.

Solution 2

1. Open Excel
2. Click “File” and “New”
3. Click on the “Data” tab
4. Click “From Text” and select the CSV file
5. Select “Delimited”
6. For “File origin”, select “65001 : Unicode (UTF-8)”
7. Click “Next”
8. Select “Comma”
9. Click “Finish”
10. Excel should now show you the CSV file and display the characters correctly.