Restore Corrupted Excel File on Windows & Mac
If your Excel file won’t open or shows garbled content, you can often restore it using Excel’s built-in repair tools, or by recovering an earlier version from autosave or backup. This article walks you through the most reliable methods on both Windows and Mac, from quick fixes to more advanced recovery techniques.
Why Excel Files Become Corrupted
Corruption usually happens when the file’s internal structure is damaged, making it unreadable by Excel. Common causes include:
- Sudden power loss or system crash while the file is open
- Forcibly quitting Excel or shutting down the computer without saving
- Saving to a network drive or USB stick that gets disconnected mid-write
- File transfer errors (e.g., interrupted download, copy-paste over a flaky connection)
- Antivirus or cloud-sync software locking the file while Excel writes to it
- Opening a file created by an older or incompatible version of Excel
Sometimes the file itself is fine, but Excel can’t read it because of a temporary glitch or a damaged add-in. In that case, the file may open normally after restarting Excel or your computer.
First Steps: Try the Built-In Repair
Excel has a repair feature that attempts to rebuild the file. On Windows, open Excel, go to File > Open, select the corrupted file, click the arrow next to the Open button, and choose Open and Repair. You’ll see two options: Repair (try to recover as much as possible) and Extract Data (if Repair fails, this pulls out values and formulas without formatting). On Mac, the same option is available: in the Open dialog, select the file, then click the small arrow next to the Open button and choose Open and Repair.
If the file opens but shows gibberish, try the Extract Data option first, as it often recovers the raw data even when the structure is broken.
Recover Unsaved or Earlier Versions
If you didn’t save the file before it corrupted, Excel might have an autosaved version. On Windows, go to File > Info > Manage Workbook and look for Recover Unsaved Workbooks. This opens a folder with files that Excel autosaved (usually every 10 minutes). On Mac, go to File > Revert To > Browse All Versions to see Time Machine backups or autosaved versions.
For files that were saved but then corrupted, check if you have a previous version from File History (Windows) or Time Machine (Mac). Right-click the file in File Explorer (Windows) or Finder (Mac) and look for Restore previous versions or Enter Time Machine.
Check the Recycle Bin and Trash
If you accidentally deleted the file or it was replaced by a corrupted version, check the Recycle Bin (Windows) or Trash (Mac). If the file is there, right-click and choose Restore. If you emptied the bin, you might still be able to recover it with a third-party file recovery tool, but that’s less reliable and should be done quickly before the disk space is overwritten.
Use a File Recovery Tool (When Excel Can’t Help)
If Excel’s repair fails and you don’t have a backup, you can try a dedicated Excel repair or file recovery program. These tools scan the file’s raw data and attempt to reconstruct it. Some are free, others are paid. When choosing one, look for:
- Support for your Excel version (e.g., .xlsx, .xls, .xlsm)
- Ability to recover formulas, formatting, and embedded objects
- Positive user reviews on independent sites
- A trial version that lets you see recovered data before paying
Be cautious with free tools that bundle adware or require you to upload the file to a website. Uploading a sensitive file to an unknown server is a security risk.
How to Prevent Future Corruption
Once you’ve recovered your data, take steps to avoid the same problem:
- Save frequently (Ctrl+S / Cmd+S)
- Turn on AutoSave (if using Microsoft 365) so changes are saved to OneDrive or SharePoint
- Set Excel’s autosave interval to a shorter time (File > Options > Save, set “Save AutoRecover information every� to 5 minutes)
- Keep backups: use File History (Windows) or Time Machine (Mac), or manually copy important files to an external drive
- Always eject USB drives safely before removing them
- Avoid saving directly to a network drive that drops connection
- Close Excel properly, not by killing the process
Frequently Asked Questions
What if the file is too large to repair?
Large files (hundreds of MB) can be harder to repair because they may have more complex internal structures. Try opening the file in Excel Online (via OneDrive or SharePoint) – it sometimes reads files that desktop Excel can’t. If that fails, use a third-party tool designed for large files, or try importing the data into a new workbook via the “From Text/CSV� or “From XML� data import options, if you can export the raw content.
Can I recover a corrupted file from a USB drive?
Yes, but first copy the file to your computer’s hard drive before attempting repair. Working directly from a USB drive can cause additional read errors. If the USB drive itself is damaged, use a data recovery tool on the drive, but note that physical damage may require professional services.
Does Excel have a command-line repair option?
No official command-line repair exists for Excel. The Open and Repair dialog is the only built-in repair method. However, you can use the /f switch when starting Excel to try to repair a file: type excel.exe /f "path\to\file.xlsx" in the Run dialog (Windows). This is not widely documented and may not work in all versions, so the GUI method is safer.
Why do my files keep corrupting?
Recurring corruption often points to a systemic issue: a failing hard drive, a faulty USB port, insufficient RAM (Excel crashes), or a problematic add-in. Check your disk health with tools like CHKDSK (Windows) or First Aid (Mac). Disable add-ins temporarily to see if they cause crashes. Also, ensure you’re using the latest Office updates.
Is it safe to use online Excel repair websites?
It depends. Some reputable sites offer repair services, but you’re uploading your file to a third-party server. For sensitive data, this is risky. If you must use an online service, read the privacy policy and consider using a disposable file (e.g., a copy with dummy data) to test the service first. Local tools are generally safer.
Related
Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.