PSG Reports - Forms Exports: How to make Special Characters load properly in a CSV file

How to make special characters load properly in a CSV file

If you're using MS Office Excel, which doesn't allow UTF-8 character encoding (Special/Non-English characters such as a tilde) to display properly in CSV files, then you can get around this by doing the following steps:

  1. Open Microsoft Excel.
  2. Click on the Data menu bar option.
    MS_Data.png

  3. Click on the From Text icon.
    MS_Data_From_Text.png

  4. Select your saved file and choose Import.

  5. Under File Origin, select 65001: Unicode (UTF-8) for the file Origin.
    MS_DATA_From-Text_Import_File-Origin.png

  6. Select Transform Data at the bottom.
    MS_Data_From-Text_Import_File-Origin_Transform-Data.png

This will cause all of the UTF-8 character encoding--Special characters--to display wherever they are present.  When saving the file afterward, you will need to select an Excel Workbook format and not a CSV format.

 

 

Top

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.