How to Extract Data From Corrupt MS Excel File?

Microsoft Office is consisting of many applications like Word, Excel, PowerPoint and Outlook etc. All the applications have different function which makes the work of the user easier and faster. You can install this useful software through www.office.com/setup. In this blog, you will read how to Extract Data from Corrupt Excel File.

read here also>>> How to Print Email from iCloud Mail and Block a Sender in iCloud Mail?

How Excel File Get Corrupted?

The reason for corrupt Excel file and data loss is unexpected power cut when you are editing an Excel sheet, if there are bugs in Excel installation or application, hardware failure, Virus Infection/adware Attack, if there is excess of data stored in single Excel file, and also because of damaged CSE Formulas and Excel Macros.

 Extract Data From Corrupted Excel Files:

  1. Use Open And Repair function:

In this, you have to open Microsoft Excel and then click on Office button and then select Open option. Now in the dialog box, you have to select the corrupted Excel file. After this, you should select Open option and then choose Open and Repair option. This will open Repair section of Excel. Now, you will see a dialog box in which you have to select the option of Repair or Extract Data. Here, just click on the Repair to repair process. And if you select Extract data then you have to follow the instructions to recover Excel file.

  1. Enable Auto Recover Feature:

For this, you have to open the Excel Workbook and then just click on the ‘File’ tab and then choose Options. Now in the Excel Options dialog box, you have to click on the Save. Here you have to ensure the settings are enabled.

3: Restore Corrupted Excel File From TMP File:

Go to the temp file folder location in your computer and then you have to find the Excel temp files with TMP extension.

For Windows 8/10 users:

C:\Users\\AppData\Local\Microsoft\Office\UnsavedFiles

For Windows 7 users:

C:\Users\name\AppData\Roaming\Microsoft\Excel\

After this, you have to find the temporary excel files which begin with “$” or “~” and end with “.TMP”. You just have to copy those files and save it to another place and also change the extension from .TMP to .XLS/.XLSX.

4: Recover Corrupted Excel File Through Previous Version:

For this, you have to create a new Excel file with the name of your lost Excel file. Then you have to right-click on Excel file and then choose Properties option. Now go to the older Versions, and then select the correct version and just you have to click on Restore. After this, you have to open it and save it in a new Excel workbook. Then you should re-open the file in HTML and just save it again in XLS format. At the end, open and save the file in SLK format.

 5: Enable Auto Backup Feature:

For this, you have to click on the File tab. After this, click on the ‘Save As’ option. Now you have to click on the Browse to open ‘Save As’ box. Now in the Save As dialog box, you have to click on Tools option. Then hit on the ‘General Options’. Here in the general options dialog box, you have to click on the ‘Always Create Backup’. After this, click OK button and then Save the file in the folder.

This method helps to extract data from corrupt Excel File. In case, you are still facing the issue then you can visit to the site of MS Office via office.com/setup.

Leave a Reply

Your email address will not be published. Required fields are marked *