When Microsoft Excel files (.xls, .xlw, .xlsx) are damaged or corrupted and cannot be opened, follow these steps to repair the file:
Note: Before starting the data recovery process, create a backup of the original corrupt Excel file.
- Microsoft Excel has a built-in repair function. When it finds your Excel file is corrupt, it will try to repair your file. In some cases, if the function is not started automatically, you can force Excel to repair your file manually. Take Excel 2013 as an example, the steps are:
- Click Open in the File menu.
- In the Open dialog box, choose the file, then click the arrow beside the Open button.
- Select Open and Repair, then choose a recovery method for your workbook.
- Select Repair to salvage the maximum amount of data from the corrupt file.
- If Repair fails, use Extract Data to retrieve cell data and formulas.
Recovery procedures may vary slightly between Excel versions.
- Our test reveals that method 1 mainly works when file corruption occurs at the end of the file. But tends to fail if the corruption occurs in the header or middle sections of the file.
- If method 1 fails, try additional manual repair techniques with Excel, such as writing a small VBA macro. More information can be found on the Microsoft support page: https://support.microsoft.com/en-gb/office/repair-a-corrupted-workbook-153a45f4-6cab-44b1-93ca-801ddcd4ea53
- Some free third-party tools can also open and read corrupt Excel files, including OpenOffice, LibreOffice, KingSoft Spreadsheets, and Google Sheets. If one of these tools can open your file successfully, save it as a new error-free file.
- xlsx files are actually compressed Zip files. Therefore, sometimes, if the corruption is only caused by the Zip file, try using a Zip repair tool such as DataNumen Zip Repair:
- Rename the corrupt Excel file (e.g., from myfile.xlsx to myfile.zip).
- Use DataNumen Zip Repair to fix myfile.zip and generate myfile_fixed.zip.
- Rename myfile_fixed.zip back to myfile_fixed.xlsx.
- Open myfile_fixed.xlsx in Excel.
Upon opening the repaired file in Excel, you might still encounter a few warnings. Disregard them, and Excel will attempt to open and fix the file. If the file opens successfully, save its content to a new error-free file.
- If all the above methods fail, use DataNumen Excel Repair to resolve the issue. It will scan the corrupted file and generate a new error-free file automatically.