A corrupted Excel file does not mean your data is gone. Start with the Open and Repair command. It sits inside Excel, needs no internet connection, and recovers more than any third-party tool can. The dialog gives you two modes: Repair, which tries to restore everything including charts and formatting, and Extract Data, which strips the file down to values or formulas. Both are reached through the Open dialog, not by double-clicking the file. Double-clicking skips the repair step entirely and often lands you on a blank sheet or an error. Here is the process, what each mode does, and what to try when Excel's own tools hit their limit.

Why Use the Built-in Open and Repair Feature

Open and Repair is the first line of defense. It handles damaged headers, broken links, and files that closed mid-write. Because it runs inside the application, it often restores formatting, charts, and other elements that an external tool would discard.

But the command is not automatic. You must launch it from the Open dialog. If you have ever clicked a corrupted file and seen nothing but an empty sheet or a cryptic error, you skipped this step.

How to Start the Open and Repair Process

Work on a copy. Never run a repair on the only version of a file.

  1. Open Excel. A blank spreadsheet is fine.
  2. Click File in the top left.
  3. Click Open in the left sidebar.
  4. Click Browse and locate the damaged file.
  5. Select it with a single click.
  6. At the bottom right of the dialog, the Open button has a small arrow beside it. Click that arrow.
  7. Choose Open and Repair... from the dropdown.

Excel scans the file and presents two buttons. Do not dismiss the dialog yet.

The Two Repair Modes Repair Vs. Extract Data

Repair Mode

Click Repair first. This mode tries to recover cell values, formatting, formulas, charts, pivot tables, and embedded objects. It aims for a fully functional file. When the process finishes, Excel may show a log of what it changed. Read it. It tells you exactly what was sacrificed.

Extract Data Mode

If Repair fails or produces a file that still will not open, go back and choose Extract Data. This mode ignores formatting and objects. It focuses on the data alone. Excel then gives you two further choices:

  • Convert to Values: Pulls out only the cell values. Every formula is replaced with its last calculated result. Use this when you need the raw numbers and text but not the logic behind them.
  • Recover Formulas: Pulls out values and the underlying formulas. Choose this to preserve the spreadsheet's logic, even at the cost of formatting and charts.

Extract Data succeeds where Repair cannot. The trade-off is real: conditional formatting, merged cells, and embedded objects vanish.

What to Do After the Repair Completes

Excel opens the recovered file. Save it immediately with File > Save As and give it a new name. Do not overwrite the original.

Inspect every sheet. Check that formulas return expected results and no data is missing. If Excel showed a repair log, read it to understand what was removed. A file that looks intact is ready to use. If you still see empty sheets, garbled text, or gaps in the data, the built-in repair did not fully succeed.

When Excel's Repair Fails

The Open and Repair command is powerful. It is not infallible. These failures are common:

  • The file opens as a completely empty spreadsheet with no sheets.
  • Excel crashes during the repair.
  • The repair finishes but key data is missing or replaced with nonsense characters.
  • All formulas show errors, and Extract Data with Recover Formulas changes nothing.

At this point, Excel cannot recover the file on its own. The corruption runs too deep.

Rebuild the File Outside Excel

Use a dedicated repair tool that analyses the raw file structure. These tools pull out data that Excel cannot read. One option is an online service that rebuilds the file from its binary components. Upload a copy of the damaged spreadsheet and the service returns a usable version, often succeeding after Excel's own tools have given up.

Preventing Future Corruption

No method is foolproof. These habits reduce the risk:

  • Save frequently. Use Save As to create versioned backups.
  • Close Excel before shutting down your computer.
  • Avoid storing active spreadsheets on network drives or USB flash drives that can disconnect without warning.
  • Keep Excel updated. Stability fixes arrive with every release.
  • Excel's maximum sheet size is 1,048,576 rows by 16,384 columns. Stay well below those limits to avoid file bloat and corruption.

A corrupted file will happen again. Now you know the exact steps to run Open and Repair, and what to do when it fails.