EXCEL2010 Open CSV file garbled solution

Excel2010 Open CSV file garbled solution

First of the garbled CSV file with Notepad to open, you can see not garbled, but no format. Then execute the Save as a new file, in the dialog box to change the UTF-8 encoding to ANSI, archive after the Excel open again, this is to see the CSV is not garbled.

Steps

Excel2010

1. First of all, there will be garbled CSV file through Notepad to open the way.

Excel2010

2. Use Notepad to open the CSV file, you will find that the text is normal, but the format is not enough, it does not matter, let us press the file to save the new file.

3. In the new File window, look carefully below, there is a coded pull-down menu, please change the UTF-8 encoding to ANSI, and then archive.

Excel2010

4. After you have finished, you can open this CSV file again with Excel! The encoded CSV files have been changed, and the format is quite normal and can be used again.