How to Clear Garbled Characters That Occurred in a CSV File

KarimHegazi · Created Jan 17, 2019 08:00:02

Procedure
•Office 20031.On the menu bar of Excel, choose Data > Import External Data > Import Data. The Select Data Source dialog box is displayed.
2.In the Select Data Source dialog box, select the CSV file. The Text Import Wizard - Step 1 of 3 dialog box is displayed. Then, select Delimited under Original data type, and select 936: Chinese Simplifed(GB2312) from the File origin drop-down list. Click Next.
The Text Import Wizard - Step 2 of 3 dialog box is displayed.

3.Select Comma under Delimiters. Click Finish.
The Import Data dialog box is displayed.

4.Click OK. The file will be normally displayed.

•Office 2007 or later1.On the menu bar of Excel, choose Data > From Text. The Import Text File dialog box is displayed.
2.In the Import Text File dialog box, select the CSV file. The Text Import Wizard - Step 1 of 3 dialog box is displayed. Then, select Delimited under Original data type, and select 936: Chinese Simplifed(GB2312) from the File origin drop-down list. Click Next.
The Text Import Wizard - Step 2 of 3 dialog box is displayed.

3.Select Comma under Delimiters. Click Finish.
The Import Data dialog box is displayed.

4.Click OK. The file will be normally displayed.

little_fish · Created Jan 18, 2019 01:04:45

Posted by KarimHegazi at 2019-01-17 08:00 Procedure•Office 20031.On the menu bar of Excel, choose Data > Import External Data > Import Data. ...

good job

How to Clear Garbled Characters That Occurred in a CSV File

How to Clear Garbled Characters That Occurred in a CSV File

Third Party’s Trade Secret

My Followers

Enterprise

Consumer

Corporate

Carriers

How to Clear Garbled Characters That Occurred in a CSV File

How to Clear Garbled Characters That Occurred in a CSV File

Third Party’s Trade Secret

My Followers