If you are looking for software to use, go to Huajun Software Park! software release

Solution to garbled CSV files in Excel 2010

author: Date: 2022-04-28

Excel 2010
excel 2010-2010 official full version

Office software Storage: 4.62M Time: 2021-03-25

Software introduction: excel 2010 is one of the important office components of office 2010 launched by Microsoft. Excel 2010 has more ways to analyze and improve...

Download now

First, open the garbled CSV file with Notepad. You can see that the garbled characters are no longer garbled, but the format is missing. Then execute Save as a new file, change the encoding of UTF-8 to ANSI in the dialog box, and open it with Excel again after saving. You can see that the CSV is no longer garbled.

Steps

Excel2010

Excel2010

​​ 1. First, open the CSV file with garbled characters through Notepad.

Excel2010

Excel2010

​​ 2. Open the CSV file with Notepad. You will find that the text is normal, but the format is no longer sufficient. It doesn’t matter. Let’s click Save as a new file in the file.

Excel2010

Excel2010

Related articles