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

Did this answer your question?