Question
When I open a CSV file downloaded from each HENNGE One service, the text is garbled. What should I do?
Answer
The garbled text may occur because different character encodings are used in the downloaded CSV file and the software used to open the CSV file (such as Microsoft Excel).
As a solution, please refer to the following steps to see if you can open the file without garbled text.
The steps using Excel are provided as an example.
※ The display may vary depending on the OS and the version of Microsoft Excel.
※ For Email DLP history downloads, it may be necessary to open with BOM to avoid garbled text.
※ When opening with BOM, first open the target CSV file in any text editor, specify the character encoding as UTF-8 (with BOM) from [Save As], and then try the following steps.
1. Open Excel as New.
2. Click [Data] - [Data File Specification (Power Query)].
3. From the data source selection screen, select [Text / CSV].
4. The connection screen to the data source will be displayed, click [Browse], select the relevant CSV file, then click [Extract Data] - [Next].
5. The file data preview screen will be displayed, confirm that [Original File] is Unicode UTF-8, and select [Load] at the bottom right of the screen.
6. The relevant CSV file will be output, check the contents.