Opening CSV files for Special Characters

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 ( for example, Google Sheets) and re-saving the file with the right encoding before uploading the file into Excel could fix the issue.