How to Resolve a Corrupted Excel File Without Losing Data

How-to basics · Updated November 21, 2026

To resolve a corrupted Excel file, first make a copy of it, then try Excel’s built-in Open and Repair command on the copy. If repair fails, look for an earlier version or recover the workbook’s data into a new file. Keep the original unchanged until you have checked the recovered workbook.

The steps below are for Microsoft Excel for Microsoft 365 on Windows. A damaged workbook may still open but show an error, missing content, or strange formatting. An error can also be caused by a file that is still syncing, an unsupported file format, or an Excel add-in, so work through the checks in order.

What You’ll Need

  • The damaged workbook and enough storage space to make a separate copy.
  • Excel for Microsoft 365 on Windows. If the workbook is in OneDrive or SharePoint, access to the account where it is stored may help you restore an earlier version.
  • Permission to open or download the file. If it belongs to someone else or is stored on a work network, you may need the owner or IT administrator to provide access.

Step-by-Step

  1. Protect the original file. Close Excel if the workbook is open. In File Explorer, find the workbook, copy it, and paste the copy into a separate folder, such as Documents. Give the copy a clear name like Budget_repair_copy.xlsx. If Windows asks whether to replace a file, choose not to overwrite the original. Do your repair attempts on the copy; some repair or save operations can remove content that Excel cannot recover.

    If the workbook is on a network drive or in a cloud folder, copy it to a local folder before repairing. A sync interruption or connection problem can look like file damage. Wait for the file to finish downloading, and avoid working on two copies at once.

  2. Check the file name and extension. Confirm that the extension matches the file type you expect. Common Excel formats include .xlsx for a standard workbook, .xlsm for a macro-enabled workbook, .xlsb for a binary workbook, and .xls for an older workbook. Do not simply rename the extension to make a file open: changing the name does not convert its format and can lead to confusing errors. If the file came from an email or website, ask the sender to confirm its format or send it again.

    Also check that the file is not unusually small compared with what you expect. A file that is zero bytes or only a few bytes may have failed to download or save. Excel cannot repair data that was never written to the file, so request another copy or look for a saved version.

  3. Run Excel’s Open and Repair command. Start Excel, then choose File > Open > Browse. In the Open dialog, select the repair copy once; do not double-click it. Select the arrow beside the Open button, then choose Open and Repair. If prompted, choose Repair first. Excel will try to restore the workbook while retaining as much of its content as possible.

    If Excel reports that it cannot repair the file, repeat those steps and choose Extract Data instead, if that option is available. This may recover values and formulas while leaving some formatting, charts, or other workbook features behind. Extract Data is a fallback, not a guarantee that every sheet or calculation will be restored.

  4. Save the recovered workbook under a new name. If Excel opens the workbook or extracts data, immediately choose File > Save As. Save it in a different folder with a new name, and choose the correct file type. For example, keep a macro-enabled workbook as .xlsm if you need its VBA macros. Do not save over the original or the only repair copy.

    If Excel warns that some features may be lost in the selected format, stop and choose a format that matches the workbook’s needs. Saving a workbook with macros as .xlsx, for example, removes its macros. If you do not know which features matter, preserve the original extension where possible.

  5. Check the recovered contents carefully. Open the newly saved file and confirm that the expected sheets appear. Check several important cells, formulas, dates, number formats, and totals. Look for missing rows or columns, blank areas, error values, and unexpected changes in charts, images, tables, pivot tables, named ranges, links, or macros. Recalculate formulas with Formulas > Calculate Now if results appear out of date.

    Do not assume that a workbook is fully restored just because it opens. Compare critical totals or records with a trusted source, such as a printed report or a separately saved export. If the workbook contains macros, only enable them if you trust the file and its source.

  6. Restore an earlier copy if repair is incomplete. For a workbook stored in OneDrive or SharePoint, open it and look for Version History from the file name or the workbook’s file information. Select a version from before the problem, inspect it, and restore it or save a separate copy. The exact location can vary with how you opened the file. If you are unsure, use the OneDrive or SharePoint website to find the file’s version history.

    If the workbook was saved only on your PC, check whether Windows has an earlier copy. In File Explorer, right-click the file or its containing folder, choose Properties, and look for the Previous Versions tab. Previous versions appear only if File History, a backup system, or another suitable restore feature was configured. Compare any available copy before replacing files.

  7. Look for unsaved or automatically recovered work. In Excel, choose File > Info > Manage Workbook > Recover Unsaved Workbooks, if that option is available. Review the listed files and open a candidate to see whether it contains the missing work. Save a useful recovery under a new name and in a normal workbook format. AutoRecover and unsaved-workbook entries may be incomplete or absent, especially if Excel did not have a chance to create them.

Common Mistakes

  • Repairing the only copy. Repair can discard unrecoverable content, and saving changes can make the original harder to compare or restore. Keep a pristine copy and create a separate working copy.
  • Renaming the extension as a repair. Changing .xlsx to .xls or .xlsm does not convert the workbook. Use Save As in Excel to save to another format when conversion is appropriate.
  • Saving over an earlier version too soon. A repaired file may open while still missing content. Save with a new name, verify it, and only replace a working file after you have a dependable backup.
  • Trusting an online repair service with sensitive data. Uploading a workbook can expose personal, business, or financial information. Prefer Excel or an approved company support channel, and check your organization’s data rules before sending a file elsewhere.
  • Assuming every warning means corruption. A blocked download, syncing conflict, password prompt, unsupported format, or unavailable network location can prevent a workbook from opening without the file itself being damaged. Read the exact message and check access and file format before trying more invasive recovery.

Tips

  • Keep multiple backups. Store important workbooks in a location with version history or a regular backup, and periodically make a separate copy. A backup on the same failing drive may not help if that drive becomes unavailable.
  • Use a simple test to isolate the cause. Try opening another known-good workbook in Excel. If other files work, the issue is more likely specific to this file. If several files fail, investigate Excel, the storage location, or an add-in rather than repeatedly repairing each workbook.
  • Use a local copy for large or network-based files. Let a cloud download or network transfer finish before opening the file. A partial transfer can create errors that disappear when you obtain a complete copy.
  • Keep recovered versions clearly labeled. Names such as sales_recovered_2026-11-03.xlsx make it easier to distinguish a recovery attempt from the original. Retain both until you have confirmed the important data.
  • Be cautious with third-party tools and macros. Avoid running unfamiliar repair utilities or enabling macros in a workbook from an untrusted source. If the file is business-critical, ask your IT team to review the recovery options before sharing or changing it.

Troubleshooting

Open and Repair is missing or Excel will not start. Confirm that you opened Excel first and used File > Open > Browse, rather than opening the workbook directly from File Explorer. If Excel itself is failing, try starting it in safe mode: press Windows key + R, type excel /safe, and press Enter. Safe mode can help identify an add-in or startup problem; it does not repair damaged workbook data. If Excel opens in safe mode, investigate add-ins before returning to normal use.

Excel says the file format or extension is not valid. Ask the sender to confirm the intended format and send a fresh copy. Check whether the download completed and whether the file is actually an Excel workbook rather than a renamed PDF, CSV, or other file. Do not enable a format override or rename extensions at random. If you can open it in another trusted application, save an exported copy only if the data and features you need are preserved.

Repair opens the workbook but sheets or objects are missing. Try Extract Data on another copy, and check Version History, Previous Versions, and Recover Unsaved Workbooks for a more complete source. If only specific values are missing, compare the workbook with an independent report or request the source data again. Excel cannot reliably reconstruct content that is absent from the file and every backup.

The file is on OneDrive, SharePoint, or a network drive and keeps failing. Check that you have a stable connection and permission to access it. Download or copy a fresh local copy, wait until any sync activity finishes, and retry. If multiple users have edited the workbook, ask whether another person has a usable copy or whether a sync conflict created separate versions. Do not delete conflict copies until you have compared them.

You use Excel for Mac or Excel for the web. The Windows Open and Repair dialog described above may not be available in the same form on Mac, and menu names can differ by Excel build. Make a copy first, then check for a version history or use Excel for Microsoft 365 on Windows to run that repair command if available. Excel for the web does not offer the same desktop Open and Repair process; use it to inspect a cloud-stored file or check version history, then open a downloaded copy in the desktop app.

Frequently Asked Questions

Can Excel repair a corrupted file automatically?

Excel can attempt repair when you use Open and Repair, but success depends on what is damaged. It may open the file with missing content, so save a separate copy and verify important sheets, formulas, and objects.

Will Open and Repair delete my data?

It may omit content it cannot recover, and later saving can preserve those omissions. That is why you should run it on a copy and keep the original unchanged. Compare any restored data with a reliable source.

What is the difference between Repair and Extract Data?

Repair tries to restore the workbook as a workbook. Extract Data is a fallback that may recover values and formulas when normal repair fails, but formatting and other features may not survive.

Can I recover a file that Excel will not open at all?

Try Open and Repair on a copy, then check version history, Windows Previous Versions, and Excel’s unsaved-workbook recovery. If the file is empty, incomplete, or lacks a usable backup, Excel may not be able to recover its missing contents.

Should I change .xlsx to .xls or .xlsm?

No. Renaming changes only the filename, not the internal file format. If you need a different format, open the workbook and use File > Save As, choosing the format that preserves the features you need.

Is it safe to upload a damaged workbook to a repair website?

Not necessarily. A workbook can contain confidential information, and uploading it shares that data with another service. Use an organization-approved tool or support channel, and check privacy and security requirements before sending a file.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.