Skip to Content

Special characters in CSV File when you export to CSV and open in Excel

Symptom:

From the Java web Report, You export to CSV . The Exported file contains special/different characters in between the text

Steps:

  1. Execute the Query/Template in the Java Portal
  2. Click on Export to CSV and open the CSV file ,you see the special characters which are not recognized, different language or symbols in between the text  

Causes:

Excel automatically uses the data format ANSI to open files. The server creates the CSV file with the data format UTF-8 if it uses Unicode.

Solution:

To open the CSV file, always use the Excel import wizard and specify UTF-8 or UTF-16 as the data format.

How to do this ?

1. Open a new Instance of Excel.

2. Click on Data:

Pic 11.PNG

3. Next Select “From Text”

4. Next Select the .CSV file from file system:

Pic 12.PNG

5. Select “UTF-8” as the encoding:

Pic 13.PNG

6. Click next and select the relevant separators:

Pic 14.PNG

7. Click on Finish

Be the first to leave a comment
You must be Logged on to comment or reply to a post.