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
- Open a new document in Excel, and then select the "Data" tab.
- Click "Get Data (Power Query)" on the ribbon on the left hand side, and then select "From Text." Excel opens a file browsing window.
- Select the CSV or text file containing the non-English characters, and then click "Open." The Text Import Wizard starts automatically.
- Select "Delimited" as the data type, unless you are importing a fixed-width text file, in which case select "Fixed Width." Click "Next."
- 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