Skip to main content
hamburger menu Created with Sketch.
Updates were made to the Support and Services ticketing processes. Click the link below the search bar for more information.

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: Formatting in Exported Data

Powered by Zendesk