ThisCalculator

Everyday

Recover Corrupt Excel File Free: 6 Methods That Work

Updated · Standard formula, shown below

Recover Corrupt Excel File Free: 6 Methods That Work

Yes, you can recover a corrupt Excel file for free using built-in Excel tools, file recovery features, and manual repair methods. This article explains six reliable free methods, how they work, and when each is your best option, so you can get your data back without paying for recovery software.

Why Excel Files Become Corrupt

Excel files usually corrupt because of sudden power loss, system crashes, or forced shutdowns while the file is open. Other causes include saving over a file on a failing drive, syncing issues with cloud storage, or transferring the file over an unstable network. Sometimes the corruption is minor—a few bytes of data are wrong—and Excel can still open it with a warning. Other times the file won’t open at all, or it opens but shows garbled content, missing formulas, or a message like “Excel cannot open the file because the file format or file extension is not valid.”

Method 1: Use Excel’s Built-in Open and Repair

This is the first thing to try. Excel has a repair tool that attempts to fix the file when you open it manually.

  1. Open Excel (not the file).
  2. Go to File > Open > Browse.
  3. Select the corrupt file, but don’t double-click it.
  4. Click the small arrow next to the Open button and choose Open and Repair.
  5. In the dialog that appears, click Repair to try to fix the file, or Extract Data if Repair fails.

Repair attempts to restore the workbook to a usable state, while Extract Data pulls values and formulas from the file without formatting. Both are free and built into Excel for Windows and Mac. If this fails, move to the next method.

Method 2: Recover Unsaved Workbooks

If the corruption happened because Excel crashed and the file was never saved, you can often recover a temporary copy that Excel keeps automatically.

  • In Excel, go to File > Info > Manage Workbook (or Manage Document on Mac).
  • Click Recover Unsaved Workbooks.
  • Look for a file with the same name and a .xlsb or .xlsx extension in the dialog that opens.
  • Open it and immediately save it with a new name.

This works only if you had AutoSave or AutoRecover enabled before the crash. By default, Excel saves a copy every 10 minutes, so you might lose up to 10 minutes of work. You can check your AutoRecover settings in File > Options > Save.

Method 3: Check the Temp Folder and File History

Excel also stores temporary files that may contain a good copy of your data.

  • On Windows, press Win + R, type %temp%, and press Enter. Look for files with names like ~$filename.xlsx or Excel8.0.
  • If you have File History or a previous version of the file, right-click the file in File Explorer, choose Properties, and go to the Previous Versions tab. Select an older version and click Restore.
  • On a Mac, check Time Machine if you have it set up, or look in ~/Library/Containers/com.microsoft.Excel/Data/Library/Application Support/Microsoft/Office/Office 2011 AutoRecovery (the path varies by macOS version).

These methods are free but depend on your system’s backup settings. If you don’t have a previous version, move on.

Method 4: Convert the File Format

Sometimes Excel can read the data if you change the file format. This works when the corruption is in the file’s internal structure, not the data itself.

  1. Open a blank Excel workbook.
  2. Go to Data > Get Data > From File > From Workbook (or From Text/CSV if you have a .csv).
  3. Select the corrupt file. Excel will try to read the data as a data source.
  4. In the Navigator window, select the sheet you want and click Load.

You can also try opening the file in a text editor like Notepad (Windows) or TextEdit (Mac). If you see readable text, copy it and paste it into Excel. This is messy but can save raw data. Another option is to open the file in Google Sheets—it often tolerates corruption that Excel won’t.

Method 5: Use a Third-Party Free Recovery Tool

If the built-in methods fail, you can try a free third-party tool. Some reputable options include:

  • Spreadsheet Repair by Spreadsheet1—free for files up to a certain size.
  • DataNumen Excel Repair—has a free trial that recovers a limited number of records.
  • SysTools Excel Recovery—free trial, but you need to pay for full recovery.

These tools scan the file’s binary data and attempt to reconstruct the workbook. They are more powerful than Excel’s built-in repair but often have limitations in the free version. Always download from the official website and scan the file with antivirus software before running it. No free tool can guarantee 100% recovery, especially if the file is severely damaged.

Method 6: Prevent Future Corruption

Once you recover your file, take steps to avoid this happening again:

  • Enable AutoSave if you use OneDrive or SharePoint.
  • Set AutoRecover to save every 5 minutes instead of 10.
  • Always close Excel properly—don’t just shut down your computer.
  • Keep backups: use File History (Windows), Time Machine (Mac), or a cloud service like OneDrive, Google Drive, or Dropbox.
  • If you often work on large files, save them in .xlsb format, which is more robust than .xlsx.

Frequently Asked Questions

Can I recover a corrupt Excel file if I don’t have Excel?

Yes. You can try opening it in Google Sheets, LibreOffice Calc, or a free online viewer. These programs are often more tolerant of minor corruption. You can also use the third-party tools mentioned above, which don’t require Excel.

Why does Excel say “file is corrupt and cannot be opened”?

This message appears when the file’s internal structure is damaged beyond what Excel can read. It can happen after a crash, a bad save, or a download that was interrupted. The methods above—especially Open and Repair and converting the format—often still work.

Will I lose formatting if I use Open and Repair?

Sometimes. Open and Repair tries to keep formatting, but if it can’t, it will extract the data without formatting. The Extract Data option always loses formatting, so you may need to reapply styles afterward.

Is it safe to use free recovery tools?

Most reputable tools are safe, but you should always download from the official website and run a virus scan. Avoid tools that ask for payment upfront or that require you to upload your file to a random website—that’s a privacy risk.

Can I recover a file that was overwritten by a corrupt version?

If you have File History or a previous version enabled, yes. Otherwise, it’s very difficult without paid recovery software. The best defense is to keep automatic backups on a separate drive or cloud service.

Related

Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.