If the text in your reports contain any special characters, like accents, Excel does not automatically display them. To correct this, follow these simple steps:
On a Windows computer:
- Open the CSV file using Notepad.
- Click "File > Save As".
- In the dialog window that appears - select "ANSI" from the "Encoding" field (right next to the Save button). Then click "Save".
- That's all! Open this new CSV file using Excel - your non-English characters should be displayed properly.
On a Mac computer use the "Numbers" application instead of Excel.