When registrations are entered into the system that include non-ASCII characters, such as French accents, Greek characters, etc., the reports may not always open correctly in Excel.
The problem is that Excel does not correctly interpret the encoding of the file, which prevents the file from opening properly. Use the following steps to instruct Excel which encoding to use when opening the file:
NOTE: The following procedure will only work if you are able to view and change the file extension of a file (Google this topic for more info: 'how to view file extensions ').
- Original data type: change to Delimited
- File Origin: Unicode(UTF-8). This might also be named '65001: Unicode (UTF-8)'
- Click 'Next'
Step 2 of 3
- Delimiters: Make sure only the 'Comma' delimiter is checked
- Text Qualifier: Choose the " delimiter.
- Click 'Finish'
After it has opened properly, click File, Save As, and change the ‘Save as type’ to '*.xls' to convert it to normal Excel format. The file should now open properly in Excel.