Special Character problems in Excel when exporting tickets to CSV

There is an issue with exporting tickets that contain special characters like ç, ã, ó, and õ, which are commonly used in some languages. When these tickets are exported via "Administration / Import and Export / Export to CSV" or through the "Reports / Summary / Excel Button," the special characters do not display correctly in Excel.

Reason

This problem arises because Excel has difficulty displaying CSV files encoded in UTF-8 when opened directly by double-clicking them in Windows Explorer. To ensure that special characters are displayed properly, it is recommended to import the CSV file into Excel, which will allow it to correctly recognize the UTF-8 encoding.

Workaround

To import the CSV file into Excel, follow these steps:

1. Open Excel.
2. Navigate to the "Data" tab at the top of the window.
3. In the "Get & Transform Data" group, click on "From Text/CSV."
4. Select the CSV file and click "Import."
5. The import wizard should automatically recognize the UTF-8 encoding and import the file correctly.

If issues persist or if a different approach is preferred, consider using other spreadsheet applications that handle UTF-8 encoding more effectively, such as OpenOffice, Google Sheets, or Office 365.

This guidance should help resolve the issue with special characters in exported CSV files. For any additional questions or further assistance, please don't hesitate to reach out.