Extract Data From a Corrupted Excel File: Safe Methods That Work

How-to basics · Updated November 21, 2026

To extract data from a corrupted Excel file, first make a copy of it, then in Excel for Microsoft 365 on Windows choose File > Open > Browse, select the workbook, click the arrow beside Open, and choose Open and Repair. Try Repair first; if that fails, repeat the process and choose Extract Data. This may recover cell values and formulas, but it cannot guarantee that every part of the workbook will be restored.

What a corrupted Excel file means

An Excel workbook can be damaged in different ways. A power loss or application crash while saving may leave its file structure incomplete. Storage or sync errors can change or remove parts of a file. Sometimes the workbook itself is intact, but Excel cannot read a particular feature, object, or external link. The message you see does not always reveal which situation applies.

Modern Excel workbooks ending in .xlsx or .xlsm are packages containing multiple related files, including worksheet data and workbook settings. A problem in one part can prevent Excel from opening the whole workbook even when some sheet data remains readable. Older .xls files and .xlsb workbooks use different formats, so techniques intended for .xlsx packages do not apply to them in the same way.

“Extracting data” usually means recovering cell contents, not restoring the original workbook perfectly. Formulas, formatting, charts, pivot tables, macros, links, and other features may be missing or changed after recovery. Treat the recovered file as a source for salvaging information, then check it before relying on it.

Protect the original before recovery

Do not experiment on the only copy. Close Excel if it is still trying to open or save the damaged workbook, and copy the file to a local folder such as Documents. Give the copy a distinct name, and keep the original unchanged. If the file is on a network share, USB drive, or cloud-sync folder, copy it locally before attempting repair; a connection or sync interruption can complicate recovery.

  • Check that the file size is plausible. A file that is unexpectedly tiny or zero bytes may have been truncated.
  • Confirm the actual file extension. Renaming a file from .xls to .xlsx does not convert its format and may make it harder to identify.
  • If the workbook contains sensitive business or personal information, avoid uploading it to an unknown repair website.
  • Record the original file name and location so you can compare versions or return to the untouched copy.

If Excel offers to save changes while closing the damaged file, do not overwrite your original. Choose the copied file as the destination for any recovered content.

Use Excel’s Open and Repair feature

In Excel for Microsoft 365 on Windows, use this route to attempt built-in recovery:

  1. Open Excel, then select File > Open > Browse. The Browse step opens the Windows file picker.
  2. Select the damaged workbook once. Do not double-click it.
  3. Click the small arrow beside the Open button, then select Open and Repair.
  4. Choose Repair in the dialog. If Excel cannot repair the workbook, repeat the steps and choose Extract Data instead.
  5. If Excel opens a recovered workbook, inspect the sheets and save it under a new name using File > Save As.

Repair attempts to restore as much of the workbook as possible. Extract Data is a fallback aimed at retrieving available values and formulas when a full repair does not work. The precise recovery depends on what is damaged, and Excel may not recover every sheet or cell. Keep the damaged original until you have confirmed that the new file contains what you need.

Excel for Mac has different interface details and may not present the same Open and Repair option in the same way as Windows. If you do not see it, do not assume a normal open has repaired the file. Work from a copy, check for a usable previous version, and consider opening the copy with another desktop spreadsheet application. Excel for the web does not provide the Windows Open and Repair workflow; use a desktop recovery option instead.

Recover information from a workbook that opens

Sometimes Excel opens the workbook but displays a warning, omits a sheet, or shows only some content. If the data you need is visible, copy it into a new blank workbook rather than repeatedly saving over the damaged one. For a straightforward sheet, select the used cells, copy them, and paste into the new workbook. If formulas or formatting trigger problems, try Paste Special options such as Values to preserve the displayed results without bringing across the original formulas.

Check all relevant worksheets, including hidden sheets if you can access the workbook. Right-click a visible sheet tab and select Unhide to see whether hidden sheets are available. If a sheet is missing or Excel reports that it removed unreadable content, note which data or features are absent. A visible total is not proof that every underlying row was recovered.

For especially important records, compare recovered data with a trusted source, such as an exported system report, a printed statement, or another copy of the workbook. Check row counts, date ranges, key totals, and several individual records. A workbook can open successfully and still have missing or altered content.

Look for a previous or unsaved version

A backup or earlier version may be more complete than a repair attempt. If the workbook was stored in OneDrive or SharePoint, use its Version History to review and restore an earlier saved version. In many Microsoft 365 setups, you can find this from the file name or through File > Info > Version History in Excel. The exact controls can depend on how the file is stored and your organization’s settings. Save or download a prior version separately rather than replacing the damaged copy immediately.

If Excel closed unexpectedly before the latest changes were saved, check its recovery options. In Excel for Windows, select File > Open > Recent and look for Recover Unsaved Workbooks near the bottom of the page. AutoRecover may have a temporary copy, but it is not a substitute for a deliberate backup and may not include the most recent edits. Also check Windows File History, a company backup system, or another service where the file may have been copied.

When comparing versions, pay attention to the time of the last save and whether the recovered file contains recent records. A clean older workbook can be useful, but it may not include the changes that matter most.

Advanced option: inspect an .xlsx copy

An .xlsx file is a package of structured components, so a technically confident user may be able to inspect a copy with a ZIP utility. This is not a first-line fix: it requires care, and manually changing the package can make it unusable. Do not simply rename the only workbook or edit its internal files.

On a duplicate of an .xlsx file, a ZIP utility may be able to list package contents. Worksheet data is represented in XML, and text values may be stored separately in a shared-strings file. Understanding which worksheet corresponds to a visible tab can require following workbook relationships, so the XML is not always a clean table that can be copied directly. An .xlsm file also contains macro-related components, and .xlsb is a binary workbook format rather than the same kind of ZIP package.

If a workbook is valuable and package-level recovery is beyond your comfort level, ask your organization’s IT staff or a reputable data-recovery specialist. Provide a copy and explain what you need recovered. Avoid making multiple repair attempts on a failing storage device if other important files may also be at risk.

Recovery tools, privacy, and common pitfalls

Third-party repair programs vary in capabilities, cost, and privacy practices. Before using one, check whether it supports the workbook’s format, whether it processes files locally or uploads them, and whether it offers a preview before payment. A website’s claim that it can repair any workbook is not a guarantee. Do not upload payroll, customer, health, or confidential company data unless your organization permits that service and its handling terms are acceptable.

  • Changing the extension: Renaming .xlsx to .xls or the reverse does not repair or convert the contents.
  • Saving over the original: Excel or another program may replace the best available recovery source with an incomplete version.
  • Trusting appearance alone: Formatting can look normal even if rows, formulas, links, or hidden sheets are missing.
  • Repeatedly retrying on failing media: If the drive is disconnecting or reporting errors, prioritize a safe copy or professional help rather than repeated writes.

After recovering the data, save a fresh workbook in a suitable format, reopen it, and verify important sheets and totals. If the original was macro-enabled, do not assume that a recovered .xlsx file retains macros; .xlsx does not store VBA macros. Preserve the original .xlsm copy and confirm macro content separately before changing formats.

Frequently Asked Questions

Can I recover data from an Excel file that will not open?
Often it is worth trying Open and Repair, then Extract Data, on a copy of the file. A backup, cloud version history, or AutoRecover copy may work better. Recovery is not guaranteed, especially if the file is empty, severely truncated, or stored on failing media.

Will Extract Data recover formulas and formatting?
Excel’s Extract Data option may recover available values and formulas, but the result can be incomplete. Formatting and workbook features such as charts, macros, pivot tables, and links may not be preserved. Check the recovered workbook rather than assuming it matches the original.

Is it safe to use an online Excel repair site?
It depends on the service and the sensitivity of the workbook. Uploading gives the service access to the file, so do not use an unknown site for confidential information. Review your organization’s policies and the service’s privacy and deletion terms first.

Can I recover an Excel file after closing without saving?
Possibly. In Windows Excel, check File > Open > Recent > Recover Unsaved Workbooks and look for an AutoRecover copy. The available copy may be older or missing recent edits, so compare it with other backups.

Does changing .xlsx to .xls fix corruption?
No. An extension labels a file type; changing it does not convert or repair the workbook’s internal structure. Use Excel’s recovery options or a genuine earlier copy instead.

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.