I have weird characters in my csv file

If you have opened a csv file and found weird characters in it, chances are you are using Excel. All of WebCollects exports are in the "UTF8" character set, which covers all international characters correctly.  Some versions of Excel have trouble opening csv files that use UTF8 format.  We can't promise that this will work (nor do we provide support for using Excel if you have an issue), however you can try this (or something similar depending on the version you are using):

  1. Save the exported file as a csv
  2. Open Excel
  3. Import the data using Data-->Import External Data --> Import Data
  4. Select the file type of "csv" and browse to your file
  5. In the import wizard change the File_Origin to "65001 UTF" (or choose correct language character identifier)
  6. Change the Delimiter to comma
  7. Select where to import to and Finish


If you can't make that work, you can force WebCollect to export all CSV files in a more limited character set, which Excel should have less trouble with. Go to:

Admin Home -> Organisation -> Edit -> Configuration tab

Change the "CSV output character set" to one of the more limited character set options and retry your export. Bear in mind that these more limited character sets, cannot cover all international characters like UTF8 can.