• About
• Disable UTF-8 Coding for Manual Exports
• Disable UTF-Coding for Scheduled Exports 

About

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 ]