Display Accented Characters in ProntoForms-Generated CSV files

Related Links




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


Disable UTF-8 Coding for Manual Exports

It is possible to disable UTF-8 coding for manually exported data.

  1. In the portal under the Data & Analytics tab, select Data.  


  2. 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. 

  3. Once the screen lists all records to download, click CSV.


  4.  In the Export Options pop-up, choose a delivery option -- Download Now or Receive an Email. 


  5. Under Advanced Options, uncheck the box beside UTF-8 Encoded. 


  6. 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.

[ top ]

Disable UTF-8 Coding for Scheduled Exports

It is possible to disable UTF-8 coding for data that is exported on a schedule.

  1. Under the Data & Analytics tab, select Scheduled Data Exports.


  2. Either Create a Schedule or choose to Update an existing one. 


  3. Under Advanced Options, uncheck the box beside UTF-8 Encoded. 


  4. Click either Create or Update to save changes.  

[ top ]


Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request