Ask a Question

Solution ID : SO9712

Last Modified : 06/21/2018

Certificate information with international characters do not display properly with Microsoft Excel

Problem

When a certificate report is generated using UTF-8 encoding, you may experience the following behavior:

The .csv (Comma Separated Values) does not display international characters properly

Cause

This problem occurs due to Microsoft Excel automatically imports .csv files with the ASCII character set.

Solution

To resolve this problem, perform the following steps:

  1. Launch Microsoft Excel
  2. Click File > Open
  3. Change "Files of type" to Text Files (*.prn; *.txt; *.csv)
  4. Browse to the report .csv file, click Open
  5. Ensure the following are selected (they should be selected by default).
    • Delimited
    • File origin: 65001 : Unicode (UTF-8)
  1. Click Next
  2. Check the box next to Comma
  3. Click Finish

The file will now be imported and the characters will be displayed properly. If the problem persists, try opening the report using Notepad.

Note: artf51321 (for Processing Center) and artf51322 (for Enterprise Service Centers) have been created requesting additional file formats, at least Excel, for Managed PKI Control Center reports.