Excel File Corruption: Recover Damaged Files Step by Step

Your Excel file will not open. Perhaps you see “The file is corrupt and cannot be opened”, or Excel crashes right at startup. The file contains important data — weeks or months of work.

This is the guide that saves your data. We go through eight recovery methods from the simplest to the most advanced. Most damaged files can be saved if you act correctly.

For other Excel problems, see common Excel problems or the Excel troubleshooting guide.

How Excel files become damaged

Understanding the cause helps you avoid the problem in the future.

Common causes of file corruption

1. Power failure or crash during saving Excel is writing to the file. The power goes out. The file is left half-written — corrupt.

2. Network problems The file is on a network drive. The connection drops while Excel is saving. Incomplete write.

3. Improper closing Force-closing Excel (Task Manager) while the file is open. Data does not get saved correctly in time.

4. Disk errors Bad sectors on the hard drive or SSD. Data is written incorrectly.

5. Incompatible versions A file created in Excel 365 with new functions, opened in Excel 2010. It can be damaged.

6. Viruses or malware Rare but possible. Malicious code can alter files.

7. Extremely large files Files over 50-100 MB are more prone to corruption.

Symptoms of a damaged Excel file

• “Excel has stopped working” on opening
• “The file is corrupt and cannot be opened”
• “Excel found unreadable content in [filnamn]”
• The file opens but some parts are missing (sheets, data, formulas)
• Excel asks if you want to repair the file every time you open it
• Strange characters or incorrect values

Method 1: Excel’s built-in repair function

Severity: First attempt Success rate: 60-70% Time required: 2 minutes

This is Microsoft’s official recovery tool.

Step by step

1. Open Excel (blank, not the file)
2. Go to File → Open
3. Browse to your damaged file
4. Do NOT click “Open” — instead click the small arrow on the “Open” button
5. Select Open and Repair...
6. You get two options:
   • Repair: Tries to save everything (formulas, formatting, data)
   • Extract Data: Saves only values, not formulas
7. Start with “Repair”
8. If that does not work, try “Extract Data”

What you may lose

If “Repair” works: – Usually no loss – Sometimes macros or VBA code disappear

If you have to “Extract Data”: – All formulas are replaced with values – Formatting may disappear – Charts may be missing – VBA code disappears

But the data is saved — that is the most important thing.

Method 2: Recover from AutoSave

Severity: High if AutoSave is on Success rate: 80%+ (if versions exist) Time required: 2 minutes

Excel automatically saves temporary versions.

Find AutoSave versions

Option A: From Excel 1. Open Excel (blank) 2. File → Info → Manage Workbook 3. Recover Unsaved Workbooks... 4. Browse to the file 5. Excel saves copies every 10 minutes (default)

Option B: Manually in the file system

Windows:

C:\Users\[användare]\AppData\Roaming\Microsoft\Excel\

Mac:

~/Library/Containers/com.microsoft.Excel/Data/Library/Preferences/AutoRecovery/

Check whether there are .xlsx files with names like AutoRecover_[filnamn].

Enable AutoSave for the future

1. File → Options → Save
2. Tick “Save AutoRecover information every X minutes”
3. Set 5-10 minutes
4. Tick “Keep the last autosaved version if I close without saving”

Method 3: Recover from OneDrive/SharePoint version history

Severity: High if the file is on OneDrive Success rate: 90%+ Time required: 3 minutes

If the file is stored on OneDrive or SharePoint, version history exists.

Step by step

1. Go to OneDrive.com or your SharePoint site in a browser
2. Find the file
3. Right-click → Version History
4. A list shows all saved versions with date/time
5. Select an earlier version (before the corruption)
6. Click “Restore” or “Download”

OneDrive saves versions automatically at every change (up to 500 versions).

If you do not see version history

Check that the file is actually synced to OneDrive. If it exists only locally, there is no cloud version history.

Method 4: Open in Google Sheets

Severity: Medium Success rate: 40-60% Time required: 5 minutes

Google Sheets can sometimes open files that Excel cannot handle.

Step by step

1. Go to drive.google.com
2. Click “New” → “File upload”
3. Select your damaged Excel file
4. Upload
5. Right-click the file → “Open with” → “Google Sheets”
6. If it opens: File → Download → Microsoft Excel (.xlsx)
7. You now have a working Excel file

Limitations

• Some Excel functions are not supported by Google Sheets
• VBA code disappears
• Advanced formatting may be simplified
• But data and basic formulas are often preserved

Method 5: Copy to a new workbook

Severity: Low-medium Success rate: 30-50% Time required: 10 minutes

If the file opens but behaves strangely.

Step by step

1. Open the damaged file (if possible)
2. Create a new workbook (Ctrl+N)
3. In the damaged file: right-click a sheet tab → Move or Copy...
4. Select the new workbook as the destination
5. Tick “Create a copy”
6. Click OK
7. Repeat for all sheets
8. Save the new workbook under a new name

Alternative: Copy content manually

If sheets cannot be moved: 1. Select all content (Ctrl+A) 2. Copy (Ctrl+C) 3. In a new workbook: Paste Special → Values (to avoid copying the corruption) 4. Rebuild formulas and formatting

Time-consuming but safe.

Method 6: Open with OpenOffice or LibreOffice

Severity: Medium Success rate: 40-50% Time required: 10 minutes

Free alternatives to Excel can sometimes open damaged files.

Step by step

1. Download LibreOffice (free): libreoffice.org
2. Install
3. Open LibreOffice Calc
4. File → Open
5. Select your damaged .xlsx file
6. If it opens: File → Save As → Select “Microsoft Excel 2007-2019 (.xlsx)”
7. Open the new file in Excel

Why it may work

LibreOffice and OpenOffice use different algorithms to read Excel files. What is corrupt for Excel may be readable for them.

Method 7: Change the file extension and extract XML

Severity: Advanced Success rate: 20-40% Time required: 20 minutes

.xlsx files are compressed ZIP archives with XML files inside.

Step by step

1. Make a copy of the file
2. Rename the file from .xlsx to .zip
3. Right-click → “Extract All”
4. You get a folder with subfolders:
   • xl/worksheets/ — Contains the sheets (sheet1.xml, etc.)
   • xl/sharedStrings.xml — Text data
   • xl/workbook.xml — Workbook structure
5. Open the XML files in a text editor (Notepad++)
6. Check whether the data is there (it can often be read)
7. If a sheet is damaged, remove it:
   • Delete xl/worksheets/sheetX.xml
   • Edit xl/workbook.xml and remove the reference to the sheet
8. Zip all files and folders together again
9. Rename the file from .zip to .xlsx
10. Try to open it in Excel

Warning

Requires technical understanding. If you do it wrong, the file can become more damaged.

Method 8: Professional recovery tools

Severity: Critical Success rate: 60-90% (depending on the tool) Time required: 1-2 hours Cost: SEK 500-1,500

When nothing else works.

Commercial tools

1. Stellar Repair for Excel – Website: stellarinfo.com – Cost: ~SEK 1,000 – Success rate: 70-80% – Can recover formulas, charts, images

2. Recovery Toolbox for Excel – Website: recoverytoolbox.com – Cost: ~SEK 500 – Success rate: 60-70% – Simple interface

3. Kernel for Excel Repair – Website: nucleustechnologies.com – Cost: ~SEK 1,200 – Success rate: 70-80% – Batch recovery of multiple files

Advantages

• Specialised algorithms
• Can recover more than Excel’s built-in tools
• Support if problems arise

Disadvantages

• Costs money
• No guarantee of 100% recovery
• Can take a long time for large files

Alternative: Excel Department

If the file contains business-critical data we can help: – Manual analysis of the file structure – Advanced recovery techniques – Reconstruction of formulas and logic – Data validation after recovery

Call 010-264 20 20 or email info@exceldepartment.se.

Preventive measures

Better to prevent than to recover.

1. Enable AutoSave

File → Options → Save → Tick “Save AutoRecover information every 5 minutes”.

2. Use cloud storage with version history

OneDrive, SharePoint, Google Drive — all save versions automatically.

3. Regular backup

Automatic backup rule: – Daily backup of active files – Weekly backup of projects – Monthly backup of archives

Use backup software or sync to an external drive.

4. Save manually often

Press Ctrl+S often — especially after important changes.

5. Avoid network drives for active editing

Work locally on the computer. Sync to the network drive when you are done.

6. Use .xlsx instead of .xls

Newer formats are more stable. .xls (Excel 2003) is more prone to corruption.

7. Keep Excel updated

Microsoft releases bug fixes regularly. Update via Windows Update.

8. Split large files

Files over 50 MB are more fragile. Split into smaller files or use Power Query to link data.

What you may lose during recovery

Depending on the method and the extent of the damage:

Summary: Your recovery plan

Immediately (within 5 minutes): 1. ✓ Try Excel’s “Open and Repair” 2. ✓ Check AutoSave versions 3. ✓ Check OneDrive/SharePoint version history

If the above does not work (10-20 minutes): 4. ✓ Try opening in Google Sheets 5. ✓ Copy content to a new workbook 6. ✓ Try opening in LibreOffice

If it still does not work (1-2 hours): 7. ✓ Extract XML manually 8. ✓ Use a commercial recovery tool 9. ✓ Contact professional help (Excel Department)

Preventive (one-off work): 10. ✓ Enable AutoSave (5 minutes each) 11. ✓ Use cloud storage with version history 12. ✓ Set up an automatic backup routine

Related content

• Excel troubleshooting guide — Systematic problem solving
• Common Excel problems — Quick solutions
• Slow Excel performance — Optimise files
• Excel help and support — Professional help
• VBA troubleshooting — Macro problems

Excel Department Slottsbacken 8, Stockholm Telephone: +46-10-264-20-20 / 010-264 20 20 Email: info@exceldepartment.se

Schema Markup

{
  "@context": "https://schema.org",
  "@type": "HowTo",
  "name": "Återställ skadade Excel-filer: 8 metoder",
  "description": "Komplett guide för att återställa skadade och korrupta Excel-filer. Från inbyggda verktyg till professionella lösningar.",
  "image": "https://www.exceldepartment.com/images/excel-filkorruption-aterstallning.jpg",
  "totalTime": "PT30M",
  "step": [
    {
      "@type": "HowToStep",
      "name": "Använd Excels reparationsfunktion",
      "text": "Öppna Excel, gå till Arkiv → Öppna, välj fil, klicka pilen på Öppna-knappen, välj Öppna och reparera. Försök Reparera först, sedan Extrahera data om det inte fungerar.",
      "url": "https://www.exceldepartment.com/excel-filkorruption-aterstallning/#metod-1-excels-inbyggda-reparationsfunktion"
    },
    {
      "@type": "HowToStep",
      "name": "Återställ från AutoSave",
      "text": "Gå till Arkiv → Information → Hantera arbetsbok → Återställ osparade arbetsböcker. Excel sparar versioner var 10:e minut om AutoSave är aktiverat.",
      "url": "https://www.exceldepartment.com/excel-filkorruption-aterstallning/#metod-2-återställ-från-autosave"
    },
    {
      "@type": "HowToStep",
      "name": "Använd OneDrive-versionshistorik",
      "text": "Om filen är på OneDrive: Gå till OneDrive.com, högerklicka på filen, välj Versionshistorik. Återställ en tidigare version före korruptionen.",
      "url": "https://www.exceldepartment.com/excel-filkorruption-aterstallning/#metod-3-återställ-från-onedrivesharepoint-versionshistorik"
    }
  ],
  "author": {
    "@type": "Person",
    "name": "Lukas Lilja"
  },
  "publisher": {
    "@type": "Organization",
    "name": "Excel Department"
  },
  "datePublished": "2026-01-30",
  "inLanguage": "sv-SE"
}