How to Fix Corrupt Excel Files in Windows 10 and Recover Lost Data?

Microsoft Excel is a handy app that is used for various tasks, including data entry, data management, accounting, financial analysis, charting & graphing, financial modeling, and more. It is an all-in-one application that handles almost anything that you need. This application is used for years to organize data easily. Spreadsheets can be created effortlessly using built-in templates of Microsoft Excel. You can carry out critical calculations, insert charts and graphs, share your workbook, and more, thus saving time and energy.

When everything works according to our choice, we don’t care about anything; it’s human nature, and it will continue. The same goes here. Problems start when something goes wrong or does not work as we expect.

Let it be anything, and we should focus on recovering the data from a corrupt excel file. If you cannot open an Excel Spreadsheet in which important data is stored, this gearupwindows post will help you recover. Microsoft Excel comes with a built-in feature that lets you recover corrupt files. That means you don’t need a third-party freeware tool to recover them—all you need to open the Excel file in recovery mode. Let’s see how you can perform these tasks on a Windows 10 PC?

Also Read: Microsoft Excel Option is Missing from the Right Click Context Menu; how to fix it?

There are at least two methods through which you can recover the data from a corrupt excel file.

Method 1: Fix Corrupt Excel Files in Windows 10 and Recover Data

Step 1. Create a new Microsoft Excel Workbook by performing right-click on free space on the desktop and selecting New and then Microsoft Excel Worksheet. Double-click on the newly created Excel Workbook to open it.

 

Step 2. Once a blank Excel file is opened, click on the File tab.

 

Step 3. On the Backstage View, click Open.

Step 4. Click the Browse option.

Step 5. On the pop-up window that appears, locate and select the corrupt excel file and then click on the Tools drop-down menu. In the drop-down menu that appears, select the “Open and Repair” option.

 

Step 6. After executing the above step, a new dialog box will appear. Here, you will see three options: Repair, Extract Data, and Cancel. Click on the first option, Repair.

Step 7. After a few moments depending upon the Excel file size, you will see a prompt saying that “Excel was able to open the file by repairing or removing the unreadable content.” Click the Close button. Now, your corrupt Excel file is repaired and opened with the data.

Method 2: Fix Corrupt Excel Files in Windows 10 and Recover Data

Step 1. Create a new Microsoft Excel Workbook by performing right-click on free space on the desktop and selecting New and then Microsoft Excel Worksheet. Double-click on the newly created Excel Workbook to open it.

Step 2. Once a blank Excel file is opened, click on the File tab.

Step 3. On the Backstage View, click Open.

Step 4. Click the Browse option.

Step 5. On the pop-up window that appears, locate and select the corrupt excel file and then click on the Tools drop-down menu. In the drop-down menu that appears, select the “Open and Repair” option.

Step 6. After executing the above step, a new dialog box will appear. Here, you will see three options: Repair, Extract Data, and Cancel. Next, click on the second option, Extract Data.

Step 7. Clicking on the Extract Data option, a new dialog box will appear. Here, you will see two options: Convert to Values and Recover Formulas. Click on the first option, Convert to Values.

Step 8. A new window will appear and confirm that Excel was able to open the file by repairing or removing the unreadable content.

Step 9. Click the Close button. Now you are ready to save the Excel file with recovered data.

Leave a Reply