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