Most of our plugins have an option to export data to CSV/Excel files, like for example the Contact Form to Email that has many CSV based reports. When importing those reports into a Excel application the character encoding may be incorrect depending of the local Excel application settings. If this happens follow these steps to correctly import the file:
- Save the exported file as a csv
- Open Excel
- Import the data using Data–>Import External Data –> Import Data
- Select the file type of “csv” and browse to your file
- In the import wizard change the File_Origin to the related language character identifier
- Change the Delimiter to comma if needed
- Select where to import to and Finish
This way the special characters should show correctly.