Summary
When opening CSV files with special characters, it often does not display properly in Excel, even when the CSV file is saved with UTF-8 encoding.
Example:
Expected display:
IPアドレス:ポート
Actual display:
IPアドレス:ポート
Environment
Microsoft Excel
Solution
This comes down to the Editor and its support of UTF-8. Using another Editor ( i.e. Google Sheets) and re-saving the file with the right encoding before uploading the file into Excel could fix the issue.
If you prefer to use only MS Excel, it's recommended to import the CSV file into Excel instead of opening it directly as it is.
Download the CSV file from the Arcules web app
Open Microsoft Excel
Go to File > Import > select CSV File > Import
Select the CSV file that you want to open > Get Data
This will prompt the Text Import Wizard to open. Select Delimited and set File Origin to Unicode (UTF-8) > Next
Set Delimiters to Comma > Finish
Import data to a new sheet