Just Published! Threat Report: Exposing Malware in Linux-Based Multi-Cloud Environments | Download Now

Carbon Black Cloud: How to correct the Garbled non-English characters in exported CSV by Excel.exe

Carbon Black Cloud: How to correct the Garbled non-English characters in exported CSV by Excel.exe

Environment

  • Carbon Black Cloud: All supported versions
  • Microsoft Excel: All supported versions

Objective

To correct the Garbled non-English characters in exported CSV by Excel.exe

Resolution

  1. Open a new document in Excel, and then select the "Data" tab.
  2. Click "Get Data (Power Query)" on the ribbon on the left hand side, and then select "From Text." Excel opens a file browsing window.
  3. Select the CSV or text file containing the non-English characters, and then click "Open." The Text Import Wizard starts automatically.
  4. Select "Delimited" as the data type, unless you are importing a fixed-width text file, in which case select "Fixed Width." Click "Next."
  5. Change the "File Origin" setting to "Unicode (UTF-8)." Check the Japanese characters in the preview pane. If they don't display in a non-English font, the characters may be saved in a different format.

Additional Notes

Steps could be a little bit different with different Excel versions, but the basic steps are the same.

Related Content


Was this article helpful? Yes No
No ratings
Article Information
Author:
Creation Date:
‎07-26-2022
Views:
104
Contributors