When your Microsoft Excel .xls, .xlw and .xlsx files are damaged or corrupted due to various reasons and you cannot open them successfully with Excel, you can use the following steps to repair the corrupt file:
Note: Before starting a data recovery procedure, you need to make a backup of your original corrupt Excel file. This is the most important step that many will forget.
- First of all, Microsoft Excel has a built-in repair function. When it detects there are corruptions in your Excel file, it will start File Recovery mode and try to repair the file for you. In some cases, if the File Recovery mode is not start automatically, then you can force Excel to repair your file manually. Take Excel 2013 as an example, the steps are:
- On the File menu, click Open.
- In the Open dialog box, select the file you want to open, and click the arrow next to the Open button.
- Click Open and Repair, and then choose which method you want to use to recover your workbook.
- Choose Repair option if you want to recover as much data as possible from the corrupt file.
- If Repair does not work, then use Extract Data to try to extract cell values and formulas from the file.
The recovery procedures are little different for different versions of Excel.
Based on our test, method 1 mainly works for the cases when corruptions occur in the tail of the file. But will not work when corruptions occur in the header or middle of the file.
- If method 1 fails, there are still several methods to repair your Excel file manually with Excel, including writing a small VBA macro, you can find more detailed information at https://support.microsoft.com/en-gb/office/repair-a-corrupted-workbook-153a45f4-6cab-44b1-93ca-801ddcd4ea53
- There are also free tools from third-parties that can open and read Microsoft Excel files, for example,
- OpenOffice at http://www.openoffice.org. This is a very famous open source project that is designed to support Office file formats, including Excel files. The software can run under Windows.
- LibReOffice at https://www.libreoffice.org/. Another free office suite.
- KingSoft Spreadsheets at https://www.wps.com/. This is a free Windows tool that can open Excel files.
- Google Sheets at https://www.google.com/sheets/about/ can also open Excel file online.
Sometimes when Excel fails to open your file, these tools may be able to open it successfully. If that is the case, then after the Excel file is opened, you can just save it as a new file which will be error-free.
- For xlsx files, they are actually a group of files compressed in Zip file format. Therefore, sometimes, if the corruption is only caused by the Zip file, then you can use Zip repair tools such as DataNumen Zip Repair to repair the file, as follows:
- Assuming the corrupt Excel file is a.xlsx, then you need to rename it to a.zip
- Using DataNumen Zip Repair to repair a.zip and generated a fixed file a_fixed.zip.
- Rename a_fixed.zip back to a_fixed.xlsx
- Using Excel to open a_fixed.xlsx.
There may still be some warnings when opening the fixed file in Excel, just let ignore it and Excel will try to open and repair the fixed file. If the file can be opened successfully, then you can just save the contents into another error-free file.
- If all above methods fail, then you need to use DataNumen Excel Repair to solve the problem. It will scan the corrupted file and generate a new error-free file for you automatically.