Repair Corrupt Excel File

What this does

Excel's built-in Open and Repair is the first and usually the only tool worth reaching for. It offers two passes: Repair rebuilds the workbook structure and keeps formulas where it can, and Extract Data pulls values (optionally converting formulas to their last calculated results) out of a file too damaged to rebuild. When both fail there are two more routes that cost nothing: opening the workbook in a different application (Google Sheets, LibreOffice and Numbers each have their own parser and sometimes read a file Excel rejects), and — for .xlsx files, which are ZIP archives — renaming a copy to .zip and extracting it to recover the embedded worksheet XML and any images. "The file format is not valid" is usually not corruption at all but a mismatched extension: a .xls file renamed .xlsx, or an HTML export saved with a spreadsheet extension. Before you run it on a workbook other people depend on, try it on a copy or a few rows first. Undo only reaches back through the current session, so a quick trial run is the cheapest way to see exactly what will change before the file is saved and shared. The difference between a quick fix and a sheet you can trust is the extra minute you spend validating “repair corrupt excel file”. Start on a copy or a tiny sample, keep the affected cells visible, and compare the result with the tool above before you touch the real workbook. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. The point is a data step that keeps your analysis trustworthy, but the practical win is that someone else can open the file and understand what happened without asking you.

A worked example

A 40 MB workbook that closed during a save now refuses to open. File ▸ Open ▸ Browse ▸ select it ▸ arrow beside Open ▸ Open and Repair ▸ Repair. Excel reports it removed a damaged chart and opens the rest with formulas intact. Save immediately under a NEW name, so the original stays available if the repair turned out to be partial. A damaged workbook is recoverable far more often than it looks, and the free routes work often enough that paying for a recovery tool should be the last step rather than the first. When the result is not what you expected, undo straight away rather than repairing it by hand — undo restores the sheet exactly, while manual fixes tend to leave small inconsistencies behind that surface later.

In Google Sheets

This is a command rather than a formula, so there is no syntax to carry over. Google Sheets arranges its commands in menus across the top instead of a ribbon, names some of them differently and does not have every Excel command — look for the equivalent in the Sheets menus or its help before assuming the steps match. Nothing on this page is behind a login or a download: the exact answer is at the top, and the detail below it is there for when you need it. That is the whole promise here — the answer first, and just enough context to make it stick. Treat “repair corrupt excel file” as a routine rather than a one-off. Once you know which setting or command controls it, the same few steps handle every workbook where it comes up in Excel, and you can explain them to a colleague in a sentence.

Common mistakes

• Repairing in place, so a partial repair destroys the only copy you had.
• Paying for a recovery tool before trying Open and Repair, another application, and the ZIP route — all free.
• Assuming "file format is not valid" means corruption when the extension simply does not match the real format.
• Ignoring the cause: a workbook that corrupts repeatedly usually points at a flaky network share, an add-in, or saving over SMB with a dropping connection.
• Overlooking AutoRecover, which often holds a version only minutes older than the damaged file.

Frequently asked questions