How to Fix Corrupted Excel File in Excel - Practical Guide

Learn multiple methods to recover corrupted Excel files and restore lost data. You'll discover built-in repair tools, recovery options, and alternative formats to salvage your spreadsheets. This skill prevents data loss and minimizes downtime when files become unreadable or crash unexpectedly.

Why This Matters

Corrupted files can halt productivity and risk permanent data loss in professional environments. Knowing repair techniques ensures business continuity and protects critical financial or project data.

Prerequisites

•Basic Excel knowledge and file management skills
•Access to the corrupted Excel file (.xlsx, .xls, or .csv)
•Excel 2016 or newer installed on your computer

Step-by-Step Instructions

Open Excel in Safe Mode

Launch Excel and hold Ctrl while opening to bypass add-ins. Press File > Open and locate your corrupted file to attempt basic recovery.

Use Open and Repair Tool

In Excel, go to File > Open > Browse, select the corrupted file, click the arrow next to Open button, then select 'Open and Repair' to let Excel attempt automatic recovery.

Convert File Format

Right-click the corrupted .xlsx file, select 'Open with' > 'Notepad', save as .txt, then reopen in Excel and use Text Import Wizard to recover data into a new workbook.

Check File Properties and Permissions

Right-click the file > Properties and verify it's not marked as 'Read-only'. Uncheck the read-only box if needed, click Apply, then attempt to open the file again.

Recover from Auto-Save or Backup

Go to File > Info > Manage Versions (or Recent) and look for auto-saved versions. Select the most recent version and click 'Restore' to recover the last saved state.

Alternative Methods

Use Online Excel Recovery Services

Upload your corrupted file to reputable online recovery tools that specialize in Excel repair. These services can recover data from severely damaged files in minutes.

Import Data via CSV Format

Change the file extension from .xlsx to .csv and open it with Excel's Text Import Wizard. This method often bypasses corruption in spreadsheet-specific features.

Restore from Cloud Backup (OneDrive/SharePoint)

If your file was synced to OneDrive or SharePoint, go to the file location and click 'Version history' to restore a previous, uncorrupted version.

Tips & Tricks

✓Always save backups in multiple locations to prevent permanent data loss from corruption.
✓Enable Auto-Recovery in File > Options > Save to automatically save versions every few minutes.
✓Avoid storing Excel files on external drives or network locations prone to connection interruptions.
✓Use antivirus software regularly to prevent malware from corrupting your files.

Pro Tips

★Use version control systems like OneDrive or Google Sheets to maintain automatic daily snapshots of your critical workbooks.
★Check the file's modified date and size before opening suspicious files—corruption often alters file size dramatically.
★Create a 'recovery folder' for corrupted files and test recovery methods in isolation to avoid overwriting originals.

Troubleshooting

File opens in 'Protected View' but shows no data

Click 'Enable Editing' at the top of the spreadsheet. If data still doesn't appear, use Open and Repair tool or convert to CSV format.

Repair tool runs but returns empty workbook

The file is severely corrupted; try third-party recovery software or online recovery services that can reconstruct data from corrupted file headers.

File size is 0 KB and won't open

The file header is corrupted beyond recovery through standard methods; restore from backup, cloud sync history, or use professional data recovery software.

Specific sheets are missing after repair

Use the Open and Repair tool again but select 'Create a workbook with recovered data' option to preserve all accessible sheets.

Frequently Asked Questions

Can I recover data from a completely corrupted Excel file?

Yes, in most cases. Use the Open and Repair tool first, then try format conversion (XLSX to CSV) or professional recovery software. Even severely damaged files often retain some recoverable data in their binary structure. Cloud backup recovery is also an option if the file was synced.

How do I prevent Excel file corruption?

Enable Auto-Recovery in File > Options > Save (set to auto-save every 1-5 minutes), use cloud storage (OneDrive/SharePoint), avoid force-shutting down Excel, and maintain regular backups. Store files on reliable drives and use antivirus protection.

What's the difference between Open and Repair versus format conversion?

Open and Repair uses Excel's built-in algorithms to fix internal file structure and usually preserves formatting. Format conversion (XLSX to CSV) extracts raw data but loses formatting, formulas, and sheet structure—use it only when repair fails.

Is my file corrupted if it shows #VALUE! or #REF! errors?

Not necessarily—these formula errors indicate broken references or incorrect data types, not file corruption. Check the formulas and source data first. True corruption prevents the file from opening or displays structural errors.

Can antivirus software cause Excel file corruption?

Rarely, but possible if the antivirus aggressively scans files during saving or if it quarantines necessary components. Disable real-time scanning temporarily when working with large files, or add Excel to the antivirus whitelist.