Solution: First open an empty excel table, click "Data" - "From Text" at the top of the page; then import the csv file, select "Delimited Symbol" in the pop-up dialog box, and select "utf" as the format -8"; Finally, check "Comma" in "Delimiter", remove the check in front of "Tab Key", and click the "OK" button.
The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2007 version, Dell G3 computer.
Open the downloaded CSV file directly with Excel. You will see garbled Chinese characters and normal numbers. The phenomenon is shown in the figure below.
Please open a blank excel file normally and position the mouse on the first row and column. The position of the mouse here will determine the subsequent csv file to be opened. The position displayed in excel is as shown in the figure below.
Click on the data in the upper menu of excel, such as the data marked in red in the screenshot of the previous step. After switching the page, click on the "Self Text" marked in red in the picture below.
In the pop-up dialog box, find the csv file that just showed garbled characters, and click the "Import" button, as shown in the figure below.
Select "Delimiter" in the dialog box that opens, and select UTF-8 in the "Original File Format" encoding, as shown in red in the screenshot below. After setting up, please click "Next".
In the current page after the jump, please check "Comma" for "Delimiter" and remove the check mark before "Tab key". See the figure below for details. Winning red configuration.
Click "Next" to preview the effect, as shown in Figure 1 below. At this time, click "Finish" to jump to the page as shown in Figure 2 below. A dialog box prompts where to place the imported data.
You can select the specified cell in the import location, or you can select "New Worksheet" to import the data and set it up After that, click "OK" to complete opening the csv file.
Related learning recommendations: excel tutorial
The above is the detailed content of What is the solution to garbled characters after opening csv with excel?. For more information, please follow other related articles on the PHP Chinese website!