Excel Repair Tools for XLS and XLSX Files: What Works

How-to basics · Updated November 19, 2026

For an XLS or XLSX workbook that will not open, first make a copy of the file, then use Excel for Microsoft 365 on Windows: select File > Open > Browse, select the copy, click the arrow beside Open, and choose Open and Repair. Excel’s built-in repair is the safest first tool to try; if it cannot restore the workbook, check backups and version history before considering third-party recovery software.

No repair method can promise to recover every worksheet, formula, or formatting detail. The right approach depends on whether the workbook is damaged, inaccessible for another reason, or simply missing because it was deleted or overwritten.

What an Excel repair tool can and cannot do

A repair tool attempts to read a damaged workbook and rebuild enough of its internal structure for Excel to open it. Depending on the damage, it may restore the workbook largely intact, remove a damaged element, or recover only some of the data. It is different from recovering an earlier version: repair works on the file you have, while a backup or version history may provide a clean copy from before the problem.

Repair is most relevant when Excel reports that the file is corrupt or unreadable, or when opening it produces an error about unreadable content. It is less likely to help with a workbook that was deleted, saved over with unwanted changes, or replaced by a zero-byte file. In those cases, look for a previous copy, cloud version history, or an organizational backup.

Even a file that opens after repair needs checking. Compare important totals, formulas, sheet names, charts, links, and formatting with a known-good copy if one exists. A workbook may look normal while a particular range, named item, or embedded object is missing.

Why XLS and XLSX files need different handling

XLS is Excel’s older binary workbook format, commonly associated with Excel 97–2003. XLSX is the newer Office Open XML format used by current versions of Excel. An XLSX file is a package of related XML and other components, including worksheet data and workbook settings. Damage to one component can affect how Excel reads the package; an XLS file has a different internal structure, so recovery software may use different methods for the two formats.

Both formats can contain useful spreadsheet content, but they are not interchangeable extensions. Changing a filename from .xls to .xlsx does not convert the workbook or fix corruption. Use Excel’s Save As command to convert a workbook that opens successfully, and choose a format that supports its features. For example, XLSX does not store VBA macros; a macro-enabled workbook normally needs the XLSM format.

Older XLS workbooks can also encounter compatibility limits when opened in modern Excel. If Excel opens the file but warns about compatibility, that is not necessarily corruption. Save a separate copy in a current format only after checking whether the workbook depends on older features or macros.

How to use Excel’s built-in Open and Repair

Use the desktop Excel app on Windows for the Open and Repair workflow. Keep the original untouched so that a failed attempt does not replace your best remaining copy.

  1. Close the workbook if it is already open, then make a duplicate in File Explorer. If possible, copy it to a local drive rather than working from a removable or unstable network location.
  2. Open Excel and select File > Open > Browse. In the file picker, locate and select the duplicate workbook; do not double-click it.
  3. Click the small arrow beside the Open button and select Open and Repair.
  4. When prompted, choose Repair first. Let Excel finish, then use Save As to save the result under a new filename. Do not overwrite the original.
  5. If Repair does not work, repeat the process on a fresh duplicate and choose Extract Data if Excel offers that option. Check any recovered values or formulas carefully before relying on them.

The wording and available choices can vary slightly by Excel build and file condition. If the workbook is on OneDrive or SharePoint, consider checking its version history before experimenting. Excel for the web does not provide the same desktop Open and Repair workflow; open a downloaded copy in desktop Excel when possible. Excel for Mac has different menus and recovery behavior, and may not show the Windows Open and Repair option. Use a duplicate and consult the recovery options available in your installed Mac version rather than assuming the Windows steps are identical.

What the repair results mean

If Excel opens the repaired workbook, inspect it before treating the repair as complete. First check that the expected sheet tabs and used ranges are present. Then compare key results, such as totals, dates, and formula outputs, with source records or a prior version. Look for blank areas, error values, missing charts, broken links, or warnings displayed when the workbook opens.

Excel may remove damaged content to make a workbook readable. That can mean losing a chart, formatting, a formula, an external connection, or another workbook feature even when the main data remains. Extract Data is a fallback for retrieving content, not a full reconstruction method: it may recover cell values and, in some cases, formulas, but the result may not retain the original layout or functionality.

If Excel cannot repair the file, avoid repeatedly saving over it or running many utilities on the only copy. Preserve the original and try a separate copy with each recovery method. A tool that reports a successful scan has not necessarily restored a usable, accurate workbook; open the output in Excel and validate it.

Check for causes that are not file corruption

An error when opening a workbook does not always mean its contents are damaged. Confirm that the file is fully downloaded, that you have permission to read it, and that another person or process is not still editing it. A network interruption or incomplete copy can leave a file that Excel cannot read even if the source workbook is fine.

  • Wrong extension: A file renamed to .xlsx without being converted may trigger a format or extension warning. Restore the original extension if known, or ask the sender to provide a fresh export.
  • Access or security block: Check the file’s location and permissions. If Windows marks a downloaded file as blocked, review its properties and your organization’s security guidance before allowing it.
  • Password protection: A password prompt is not proof of corruption. Repair tools do not legitimately bypass workbook encryption; use the correct password or contact the file owner.
  • Excel or add-in issue: If many unrelated workbooks fail, investigate the Office installation or an add-in rather than treating every file as damaged. Updating or repairing Office may address an application problem, but it will not reconstruct missing workbook data.
  • Incomplete file: Compare file size with the sender’s copy or download it again. A file that is unusually small or empty may not contain enough data for a repair utility to recover.

Backups and other recovery options

Before paying for software, search for another copy. If the workbook was stored in OneDrive or SharePoint, use its version history to review and restore an earlier version. In Excel for Microsoft 365 on Windows, the File > Info area may also show version or workbook management options depending on how and where the file was saved.

If Excel closed unexpectedly before a workbook was saved, check Excel’s document recovery pane when the app starts. On Windows, you can also look under File > Info > Manage Workbook for the Recover Unsaved Workbooks option when available. AutoRecover and unsaved-file recovery are not substitutes for a saved backup: they depend on the app’s settings, timing, and whether recovery data was retained.

Other options include asking the sender to resend the workbook, restoring a copy from a company backup, or opening a duplicate in another spreadsheet application that supports the file format. LibreOffice Calc, for example, can open many XLS and XLSX files, but conversion or saving in another application can change features or formatting. Use it as a way to inspect a copy, not as a guarantee that every Excel-specific feature will survive.

Choosing third-party repair software

Consider a commercial repair tool only if Excel’s built-in option and available backups do not solve the problem. Look for clear support for the exact format and operating system, an explanation of what the scan can recover, and a preview that lets you inspect recoverable content before payment. A preview is useful evidence, but it is not proof that the final workbook will be complete.

Pricing and licensing vary by vendor and can change, so compare current terms rather than relying on a quoted price from an old review. Check whether payment covers one file, a period of use, or a subscription, and whether refunds are available. Avoid tools that make absolute recovery promises or pressure you to upload confidential data without explaining how it is stored and handled.

For a workbook containing customer details, payroll, health information, financial records, or trade secrets, prefer an offline process or a provider approved by your organization. Uploading a file to a website gives another party access to its contents. Read the privacy terms, confirm that you are authorized to share the workbook, and remove sensitive data only if doing so will not undermine the repair.

Preventing future workbook loss

The most reliable protection is more than one recoverable copy. Save important workbooks in a location with managed version history or regular backups, and periodically verify that the backup can actually be opened. For critical files, keep a separate dated copy before major edits or format conversions.

  • Use a clear naming pattern for milestone copies, such as a project name and date, while keeping one authoritative working file.
  • Wait for cloud synchronization to finish before shutting down or disconnecting from the network.
  • Keep the original format when it is needed for macros or older software, and save conversions as separate files.
  • For shared workbooks, coordinate edits and avoid interrupting uploads or closing the app during a save.

AutoSave can help with supported files stored in OneDrive or SharePoint, but it is not a complete backup strategy. Version history and organizational backup policies matter because synchronization can also propagate unwanted changes or deletions.

Frequently Asked Questions

Is there a free Excel repair tool for XLS and XLSX?

Excel’s built-in Open and Repair feature is included with the desktop app and is a sensible first attempt. It may not restore every damaged workbook. Backups and cloud version history are other no-cost options when available; many third-party tools charge for saving recovered files.

Can I repair an Excel file online?

Some websites offer online repair, but uploading a workbook shares its contents with that service. Avoid this for confidential information unless your organization approves the provider and its data practices. Excel for the web does not replace the desktop Open and Repair workflow.

Will changing XLS to XLSX fix a corrupted file?

No. Changing the extension only changes the filename, not the workbook’s internal format or damaged data. If Excel can open the workbook, use Save As to create a properly converted copy; if it cannot, try repair or locate an earlier version.

Can a repair tool recover a deleted or overwritten workbook?

Usually, a repair tool needs an existing file to inspect. For a deleted or overwritten workbook, check the Recycle Bin, cloud version history, AutoRecover or unsaved-workbook options, and your organization’s backups. Stop saving new data to the affected drive if you plan to seek file-system recovery.

Why does Excel say the file format or extension is not valid?

The file may be incomplete, damaged, incorrectly renamed, or not actually an Excel workbook. Download or request it again, verify the extension with the sender, and try Open and Repair on a duplicate if it is a genuine XLS or XLSX 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.