Summary of the garbled problem in Excel opening and its solution method

Excel is also a variety of reasons for garbled characters. If you encounter Excel Open is garbled, you can find the appropriate solution from below.

1, 2003excel Open is garbled

Garbled solution Step 1:excel Open a CSV format document, there are garbled

Garbled Solution Step 2: There are garbled CSV file through Notepad way to open

Garbled Solution Step 3: With Notepad Open, open to is also a pile of garbled, click "Archive"---"Save as"

Garbled resolution Step 4: In the Pop-up Save dialog box, select the "ANSI" format

Garbled resolution Step 5: Setup is complete, save the file and open it in Excel. As you can see, the document can be displayed correctly.

2, 2007excel Open is garbled

Open garbled resolution Step 1: Open Word, click Open on the File menu

Open garbled Resolution Step 2: Select All files in the file type, locate and select the. xls file that you want to repair, and click the Open button

Open garbled resolution Step 3: After opening, if Excel has only one worksheet, it automatically loads word as a table, and if the file is made up of multiple worksheets, you can open only one worksheet at a time.

Open garbled resolution Step 4: Delete the corrupted part of the file.

Open garbled Resolution Step 5: Select the table with the mouse, in the Table menu, select "form to Text", you can choose the "," separator or other separators.

Open garbled resolution Step 6: Save as a text. txt.

Open garbled resolution Step 7: Open the text file directly in Excel and save it as an Excel file with a different name.

3, CSV file with Excel Open is garbled

CSV files exported from the Web page, opened in Excel, Chinese will be garbled. CSV file garbled problem is mainly caused by file encoding. Therefore, to solve the problem of Excel open garbled, you can start by changing the file:

First, you open a CSV file with Notepad, and you may see a long record of the data.

Then, directly to save the file just opened as TXT file, if it is a UTF-8 file, you should be able to see the saved into the editing format.

Finally, open the saved file directly with Excel. Should be able to see the correct Chinese characters.

4, Excel file corruption appears garbled

Sometimes you open a previously edited Excel workbook, but there is no way to continue editing and printing. The reason for this is that the file has been corrupted, and you can try to fix Excel garbled by using one of the following methods.

(1) Save Excel garbled file as SYLK format

If the Excel garbled file can be opened, the Excel garbled file can be converted to the SYLK format to filter out the corrupted parts of the document and then save the data.

(2) Excel garbled file converted to earlier version

If you do not save an Excel garbled file because of a startup failure, the last saved version may not be corrupted. Close the open workbook, and when asked if you want to save your changes, click No. On the File menu, click Open to double-click the workbook file.

(3) Open the Excel garbled file and fix the workbook

If an Excel garbled file cannot be opened at all by using the normal method, you can try the "Open and Repair" feature in Excel 2003 to check for and fix errors in the Excel garbled file.

Click "File"--"open". From the Look in box, locate and open the folder that contains the damaged document, and select the file you want to recover. Click the arrow next to the Open button, and then click Open and Repair.

Excel garbled problem is also not a write, because the reason for the appearance is too diverse. If the above method is still not valid, you can use the Third-party software to try to solve the Excel garbled.

Office Excel Viewer is a Microsoft Official Excel garbage Removal Repair tool, download installation finished, with Office Excel Viewer open the garbled Excel document, and then copy the cell, and paste them into a new workbook in Excel.