Corrupt Excel File Recovery

“corrupt excel file recovery” comes up constantly, so this page leads with the exact answer, and only then explains the detail. Everything works in Excel on Windows and Mac and maps almost one-to-one to Google Sheets. Copy the answer above and get back to work, or read on to turn a one-off fix into something you never have to look up again.

Exact answer

In Excel: open Excel and check File ▸ Info ▸ Manage Workbook ▸ Recover Unsaved Workbooks, then save any recovered copy immediately under a normal file name.

Annotated stepsExcel
1

Reopen Excel before creating many new temporary workbooks.

2

Go to File ▸ Info ▸ Manage Workbook ▸ Recover Unsaved Workbooks.

3

Open the newest relevant file and verify the contents.

4

Use Save As immediately, then enable AutoSave or shorten the AutoRecover interval.

Ctrl+CthenCtrl+Shift+V+Cthen+Ctrl+VPaste values · WindowsMac

What this does

Excel recovery depends on AutoRecover and whether Excel had time to save a temporary copy. Unsaved workbook recovery looks for files Excel captured before a crash or accidental close. It is not the same as opening a deleted file from the Recycle Bin or restoring a previous version from OneDrive, SharePoint or File History. Keep the inputs visible and clearly labelled and the whole thing stays auditable — anyone who opens the file later, including you, can see at a glance exactly what feeds the result and change one assumption without hunting through the formula. Treat “corrupt excel file recovery” as a small repeatable workflow rather than a one-off click you hope to remember next time. Use a small test block before the live file, so any surprise in the affected cells shows up while it is still harmless. 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 turns a data step that keeps your analysis trustworthy into a method you can reuse, explain, and defend when the workbook leaves your screen.

A worked example

Excel crashes while Book1 has not been saved. Reopen Excel, go to File ▸ Info ▸ Manage Workbook ▸ Recover Unsaved Workbooks and look for a timestamped copy. Open it, inspect the latest changes, then Save As Payroll-Q2.xlsx so it becomes a normal workbook. Recovery content matters because users arrive stressed and need the exact path first, then a realistic explanation of what AutoRecover can and cannot do. One habit worth forming early: name the cells that hold your inputs, so the formula reads in plain language instead of a string of cell addresses. A reviewer — or you in three months — can then follow the logic without decoding what B7 and D2 were supposed to mean, which is most of what makes a sheet maintainable.

In Google Sheets

Everything above works in Google Sheets too. Excel and Sheets share the formula syntax used here; only the surrounding menus are arranged differently. That portability is deliberate — learn it once and it follows you between the two tools and across Windows and Mac. Nothing on this page is behind a login: the tool runs entirely in your browser, the formula is shown in full with one-click copy, and the steps work the same on Windows and Mac. That is the whole promise here — the exact answer, a way to prove it on your own numbers, and just enough context to make it stick. If you take one thing from this page on “corrupt excel file recovery”, make it the habit rather than the keystrokes: set the problem up with labelled inputs, reference those cells, and let Excel do the recomputing. Bookmark the page for the syntax, but do the example once in a blank sheet and check it against the tool above — five minutes of hands-on practice fixes the method in memory far better than re-reading, and it surfaces the small snags while they are still harmless. After that the technique is genuinely yours: faster than searching for it again, and reliable enough to drop into work that other people depend on.

Common mistakes

  • Continuing to work for hours before checking recovery, which can overwrite temporary files.
  • Assuming AutoRecover is a backup system; it is a crash-recovery helper.
  • Recovering the wrong timestamped copy and losing later edits.
  • Forgetting cloud version history when the file was stored in OneDrive or SharePoint.

Frequently asked questions

Where are unsaved Excel files recovered?

Use File ▸ Info ▸ Manage Workbook ▸ Recover Unsaved Workbooks.

Can Excel recover every unsaved file?

No. Recovery only works when AutoRecover captured a temporary copy.

What should I do after opening a recovered file?

Save it immediately with a normal name and location.

Other ways people ask this

This is also commonly searched as “excel corrupt file recovery xlsx online” and “how to recovery excel corrupt file”. They describe the identical operation, so you are in the right place no matter how you phrased it.

Platform & version notes

  • Some variants pin a specific edition (the web version). The method above is stable across recent Excel releases — older versions only differ in where a ribbon icon sits, not in what the steps achieve.

Does this still work in older versions?

It does. The approach has been stable across recent Excel releases; only the ribbon icons have shifted cosmetically, so the steps above still apply.

Why do people search for this in so many different ways?

Because the same task has many names. “excel corrupt file recovery xlsx online”, “how to recovery excel corrupt file” all point at the one operation explained on this page, which is why they all lead here.