Display Accented Characters in ProntoForms-Generated CSV files

Related Links

 

 

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.  


    data_page.png

  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.

     
    CSV.png

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


    Download_Now.png

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

    UTF8.png

  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.

    Scheduled_Data_Exports.png

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

    create.png

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

    Scheduled_Data_Exports_Advance.png

  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

Comments