Simple solution to Excel's CSV garbled problem with Notepad

  
Let's first look at the situation of garbled CSV files. When you open a CSV file, except for numbers, other texts become garbled like this one. When you don't rush to delete the file, you can actually solve it. 1. First, open the garbled CSV file through Notepad. 2. With the CSV file opened in Notepad, you will find that the text is normal, but the format is not enough. It doesn't matter, let's press the save new file in the file. 3. In the Save As window, look closely below, there is a coded drop-down menu, change the UTF-8 encoding to ANSI, and then archive. 4. Once you're done, you can re-open this CSV file with Excel! Changed the encoded CSV file, the garbled situation is solved, and the format is quite normal, you can continue to use. [Office 2013 Activation Tools /Installation Tutorial]
Copyright © Windows knowledge All Rights Reserved