When I open the CSV file in Excel, the characters become garbled.

When opening CSV files containing Japanese text in Excel, the characters may appear garbled. This is often caused by a mismatch between the character encoding used when creating the CSV file and the character encoding applied when opening it in Excel.


Examples:

  • The CSV file is created in UTF-8 encoding.
  • Excel is attempting to open in Shift-JIS encoding.
  • Due to the mismatch in the above character encoding, garbled text appears in Excel.


If this issue occurs, please try the following methods.


  1. First, do not double-click the CSV file to open it.
  2. Launch Excel.
  3. Click the Data tab.
  4. Click From Text/CSV.
  5. Select the CSV file and click Import.
  6. A preview window will appear.
    Change File Origin (upper-right corner) to 65001: Unicode (UTF-8).
  7. Verify that the text is displayed correctly,
    select the appropriate Delimiter,
    and click Load.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article