Handling Non-English Characters in CSV Downloads
Posted by , Last modified by on 24 May 2012 06:23 AM

The NetExam System allows Administrators to download Reports in CSV format. During these downloads, Non-English characters would not be supported.

In order to overcome this problem, the following steps could be utilized: (Screenshots and instructions are based on Microsoft Excel 2007 format)

    1. First, download the CSV and save it in your PC.


    1. Next, Open a new Microsoft Excel worksheet


  1. Select the Data tab and click on the From Text tab


    1. A window will open allowing you to select the file, select the CSV file that you downloaded and saved, and click the Import button


  1. In the next pop-up, from the File Origin field select "65001 : Unicode (UTF-8)", and click Next


  1. In the next window, under Delimiters, uncheck Tab and check Comma, and click Next


    1. Without making any changes in the final window, click on the Finish button


  1. You will be prompted with another pop-up as shown in the screenshot below. Make sure Existing Worksheet is selected and press OK.


  1. Finally, save this file as xlxs  and you will be able to see the characters.
(1 vote(s))
Not helpful

Comments (0)