Special characters in ProntoForms-generated CSV files might display incorrectly when opened in Microsoft Excel. Excel does not recognize UTF-8 encoded CSVs, and may consequently display them with the wrong encoding (ie., "Stéphane" may display as "StÃ©phane"). To ensure data with special characters is imported properly into Excel, the UTF-8 Encoded advanced option under Data in the web portal must be disabled in Export Options.
It is possible to disable UTF-8 coding for manually exported data.
In the portal under the Data & Analytics tab, select Data.
On the Data Records screen, use Search Options to choose the record(s) to export.
Note: Any records selected will export as a single file.
Once the screen lists all records to download, click CSV.
In the Export Options pop-up, choose a delivery option -- Download Now or Receive an Email.
Under Advanced Options, uncheck the box beside UTF-8 Encoded.
Click Export. The file will be automatically downloaded or emailed to when it is ready.
Note: If downloading the file, do not close the window that appears, as that will cancel the download.
It is possible to disable UTF-8 coding for data that is exported on a schedule.
- Under the Data & Analytics tab, select Scheduled Data Exports.
- Either Create a Schedule or choose to Update an existing one.
- Under Advanced Options, uncheck the box beside UTF-8 Encoded.
- Click either Create or Update to save changes.