Skip to main content
hamburger menu Created with Sketch.
PHP2Shell - PHP Vulnerability Announcement

Search the Knowledge Base

Why Garbled Characters are Displayed in the CSV File Exported from Vault?

  • Updated

Question:

A user opens the CSV file exported from Vault and finds some garbled characters displayed. Why are these garbled characters displayed?

            mceclip0.png

Answer:

The exported data may contain Chinese, Japanese, or Korean characters (CJK). These CJK characters are rendered incorrectly in Excel because Microsoft Excel™ is unable to properly display UTF-8 compliant CSV files. This is an Excel issue rather than a Vault issue. The workaround for this issue is as follows:
  1. In Excel, go to File --> New Workbook.
  2. Go to File --> Import --> CSV file. Select the CSV file exported from Vault.

    mceclip1.png

  3. Excel displays Text Import Wizard.

    mceclip2.png

  4. In the File origin field, select Unicode (UTF-8).

    mceclip3.png

  5. Select Tab and Comma checkbox.

    mceclip4.png

  6. In the dialog window that appears, click the Finish button.

    mceclip5.png

Related Documentation:

Vault Help Documentation: CSV Exports

Powered by Zendesk