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.
-
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.
Disable UTF-8 Coding for Scheduled Exports
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.
Comments
0 comments
Please sign in to leave a comment.