Excel failed to display Japanese characters when opening csv file saved from Statistica 13.2 with UTF-8 encoding

Excel failed to display Japanese characters when opening csv file saved from Statistica 13.2 with UTF-8 encoding

book

Article ID: KB0074145

calendar_today

Updated On:

Products Versions
Spotfire Statistica 13.2

Description

This article talks about an issue that Excel failed to display Japanese characters when opening csv file saved from Statistica 13.2.

PROBLEM RECAP (13.2 installed):

1. Go to Control Panel | Regions, and change System Locale to Japanese

2. Open a Statistica spreadsheet with Japanese characters in Statistica 13.2. Note that Japanese characters are successfully displayed in Statistica.

3. In Statistica, go to "File | Save as" to save the spreadsheet to .csv file

4. Open the saved .csv file in Notepad, Japanese successfully displayed.

5. Select the saved .csv file, right click mouse to display the dropdown menu, choose "Open with" and select "Microsoft Excel" to open the .csv file in Excel. Observe that Japanese characters are failed to be displayed.

 

Issue/Introduction

Excel failed to display Japanese characters when opening csv file saved from Statistica 13.2 with UTF-8 encoding

Environment

Windows

Resolution

This issue is due to the reason that Statistica 13.2 saves CSV file with UTF-8 encoding, and Excel reads CSV file by default with ANSI (Shift jis) encoding.

To make Excel to read CSV file saved from Statistica with UTF-8 encoding and correctly display Japanese characters,

1. Open an empty Excel template, go to "Data | From Text", browse to the .csv file saved from Statistica 13.2. Click on "Import".

2. Follow the Excel "Import Text" wizard.

  • File origin: UTF-8
  • CSV file Delimited by: Comma ","

Click Next to finish importing CSV file to Excel

4. By using the "Import Text" wizard, Excel is able to read the Japanese Characters in the UTF-8 encoded CSV file.