Repair Excel Spreadsheet

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. The same idea underpins a lot of everyday Excel work, so the few minutes spent getting it right here pay back across every sheet you build afterwards. Treat it as a pattern, not a one-off, and it stops being something you look up and starts being something you reach for. For “repair excel spreadsheet”, the reliable version is a short checking loop, not just the first command that appears to work. Run it on a deliberately small range first, watch how the affected sheet change, and only then apply the same setup to the full sheet. 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. That is what makes a layout choice that keeps the sheet readable and sortable useful in real work: repeatable, auditable, and not dependent on memory or luck.

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. The aim was to get you unstuck fast and leave you a little more capable than a copy-paste would. The answer is at the top and the detail above shows why it holds — so the next time a colleague asks, you can answer without reaching for search. The short version of “repair excel spreadsheet”: the answer is at the top of this page, and the sections above explain why each step matters, so a variation of the problem does not stump you. Try it once on a copy of a real file and the steps stick far better than re-reading them.

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