Special Character problems when exporting tickets to a CSV file and opening in Excel


We faced a problem: special caracthers like ç, ã, ó, õ used in Portuguese language. When exporting this tickets throught "Administration / Import and Export / Export to CSV" or using "Reports / Summary / Excel Button" words with these special characters like ç, ã, ó, õ are not exported correctly to csv files.


Excel has known issues when opening UTF8 csv files, when opening the CSV file through a double click in Windows Explorer. If you import the data using the menu "Data / Import CSV file" the wizard recognizes UTF8 encoding correctly UTF8 and the file should be imported correctly.

You can also try to open the CSV file 
with some other spreadsheet application, e.g. OpenOffice, Google Sheets, Office365 etc.
Creation date: 6/22/2023 4:58 AM      Updated: 6/22/2023 4:58 AM
Errors and solutions for Jitbit Helpdesk ticketing system