Build the best contact forms in your WordPress website.
The Contact Form to Email that has many CSV based reports, an option to export data to CSV/Excel files. If you experience problems with the character encoding of the exported files, here is the info of how to fix it.
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
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.
Feedback about these features will be welcome, feel free to open a support ticket for any question.