There is no legitimate universal “free full version” of Excel repair software that can guarantee recovery of every damaged workbook. If you have Excel for Microsoft 365 on Windows, try its built-in Open and Repair command first; it costs nothing extra and may recover a file, though badly damaged data can be lost.
What “free full version” usually means
Searches for free full-version repair software often lead to two different things: Excel’s own recovery features, or third-party utilities that claim to fix damaged spreadsheets. Excel’s built-in repair option is included with the desktop application, but it is not a separate product and cannot fix every file. A third-party program described as free may only scan a workbook, show a preview, or require payment before saving recovered data. Read the terms and limitations before installing anything.
Be especially wary of downloads advertised as cracked, activated, or unlocked full versions. These may violate software terms and can expose your computer or files to malware. A repair utility also needs access to the workbook, which may contain confidential payroll, customer, or business information. Avoid uploading sensitive workbooks to an unfamiliar online service.
It helps to separate three different tasks: repairing a damaged workbook, finding an earlier or unsaved copy, and repairing the Excel application itself. A tool that fixes the Office installation does not necessarily restore a workbook, and a workbook repair cannot bring back content that was never saved or has been overwritten.
Why Excel workbooks become damaged
A workbook can become unreadable or behave unexpectedly for several reasons. A computer may shut down while Excel is saving, a drive may develop errors, or a sync or network connection may fail during a transfer. Files can also be truncated when a download is interrupted or copied from a failing USB drive. Sometimes the workbook opens but has missing sheets, broken formatting, or formulas that no longer calculate as expected.
An error message does not always mean the file itself is corrupt. Excel may be unable to open a file because it has an extension that does not match its actual format, because access is blocked, or because the file is stored somewhere temporarily unavailable. If the workbook came from email or the web, save it locally and check that the filename and extension are what you expect. Do not rename a file to a different extension as a repair method; changing .xlsx to .xls, for example, does not convert its contents.
Try Excel’s Open and Repair command
On Excel for Microsoft 365 on Windows, work on a copy so the original remains unchanged. In File Explorer, copy the workbook to another folder or give the copy a distinct name. Then use these steps:
- Open Excel and select File > Open > Browse.
- In the file picker, select the workbook that you copied. Do not double-click it.
- Select the arrow beside the Open button, then choose Open and Repair.
- Choose Repair when prompted. If Excel cannot repair the workbook, try Extract Data if that option is offered.
Repair attempts to recover as much of the workbook as Excel can. Extract Data is a fallback for retrieving available values or formulas when a normal repair fails; it may not preserve the original layout, charts, formatting, or every feature. Check the result carefully, including sheets that are hidden, formulas, named ranges, charts, and totals that matter to your work. Save a recovered workbook under a new name rather than overwriting the source.
The same command is not available in the same way in every Excel edition. Excel for the web and Excel for Mac may not show the Windows Open and Repair option. If you are using a different edition, first make a copy and try the recovery options available there, or use a Windows desktop copy of Excel if one is available. Menu names can vary between versions.
Look for an earlier or unsaved copy
When repair does not help, recovery may be possible from a separate copy rather than from the damaged file. If the workbook was stored on OneDrive or SharePoint, check its version history. In the Microsoft 365 desktop app, open File > Info and look for Version History when it is available. You can also find version history through the file’s menu on OneDrive or SharePoint. Restore or download an earlier version to a different filename so you can compare it with the current workbook.
If Excel closed unexpectedly before you saved a new workbook, on Windows try File > Info > Manage Workbook > Recover Unsaved Workbooks. The list may be empty, and unsaved recovery depends on what Excel retained; it is not a guaranteed archive. For an existing workbook, AutoRecover or AutoSave may help, but their availability and behavior depend on settings and where the file is stored.
Other possible sources include a backup made by your organization, a copy attached to an email, or a previous file saved to another folder. Windows’ previous-version recovery depends on whether File History, backup software, or another suitable backup was configured. On a Mac, Time Machine may contain an earlier copy if it was set up and had backed up the file. These are recovery sources, not repair programs, and they work only when a usable earlier copy exists.
Free tools and their limitations
Some third-party spreadsheet-repair products offer a no-cost download or a free scan. That does not necessarily mean the complete recovery and saving process is free. Before using one, check exactly what the free tier allows: opening a preview, repairing a limited number of files, exporting a workbook, or saving without restrictions are different features. Confirm the current price and terms on the developer’s own website; offers and product limits can change.
Be cautious about relying on claims such as “100% recovery” or “repairs any Excel file.” No tool can promise that all workbook content will survive every kind of corruption. A damaged workbook may have lost data at the file level, and a repair program cannot reliably recreate information that is no longer present. A scan result that lists recoverable sheets also does not prove that formulas, macros, links, or formatting will be intact after export.
For non-sensitive files, a reputable desktop utility may be worth considering after built-in recovery and backups have been checked. For confidential files, prefer a local program with clear privacy terms, or consult your organization’s IT team. If a vendor asks you to upload a workbook, find out how the file is transmitted, stored, and deleted before sending it.
How to choose a repair option
Choose based on what is wrong and what the workbook contains, rather than on the biggest recovery claim. A simple file that contains a few tables is different from a workbook with macros, external links, data connections, pivot tables, or complicated formatting. The more specialized the file, the more important it is to preserve the original and verify recovered content against another source.
- Check the source: If a cloud version or backup exists, compare it before installing a repair tool.
- Check the free limit: Confirm whether recovered files can actually be saved without paying.
- Check compatibility: Make sure the utility supports the file type, such as .xlsx, .xls, or .xlsm, and your version of Windows.
- Check privacy: Understand whether the repair runs locally or sends workbook data to a server.
- Check the output: Keep the original and verify formulas, totals, sheets, and any macros or links that are important.
Do not pay for a tool before confirming that it can handle your file and that the recovered output is useful. If a workbook contains business-critical records and there is no valid backup, consider asking IT or a data-recovery professional before repeated experiments on the only copy.
Workbook repair is not Office repair
If Excel itself is crashing or failing to open many healthy workbooks, the problem may be the Office installation rather than one spreadsheet. On Windows, you can try repairing Microsoft 365 from Settings > Apps > Installed apps: select Microsoft 365, choose Modify, then select Quick Repair or Online Repair if those options appear. The exact labels can differ by Windows and Office installation. Online Repair may require an internet connection and can take longer.
This process repairs Office components; it is not a substitute for recovering a damaged workbook, and it does not guarantee recovery of unsaved changes. Keep a separate copy of the spreadsheet before troubleshooting. If only one file fails while other workbooks open normally, focus first on that file’s backups and Excel’s workbook-repair options.
Free alternatives and when they help
If Excel cannot open the file, you can try opening a copy in another spreadsheet application, such as LibreOffice Calc. This may help if the issue is a compatibility problem rather than serious corruption. It is not a guaranteed repair, and saving the workbook from a different program can change formatting, formulas, macros, or other Excel-specific features. Keep the original and compare the result before relying on it.
For a file stored in a cloud service, downloading a fresh copy can rule out a partial local download. If it is on a network drive, ask whether a backup or earlier server version exists. When a workbook opens but only some cells or formulas are wrong, restoring a known-good copy or rebuilding the affected section from source data may be safer than using a broad repair tool.
Preventing future workbook loss
Repair is a last resort; a separate, current copy is usually the most dependable recovery option. Save important workbooks to a location covered by a backup policy, and check that the backup is actually completing. For shared workbooks, use OneDrive or SharePoint version history where appropriate, but do not treat sync as the only backup: deletions or unwanted changes can also sync.
- Keep a separate backup before major edits, migrations, or format conversions.
- Use a stable power source and avoid disconnecting removable storage while Excel is saving.
- Close Excel normally and wait for file transfers or cloud sync to finish.
- For workbooks with macros, use a macro-enabled format such as .xlsm when required, and retain a clean copy.
After any recovery, test the workbook before using it for decisions or sharing it. Compare key figures with source records, check formulas and links, and make sure the correct sheets are present. A workbook that opens successfully may still have missing or altered content.
Frequently Asked Questions
Is there a completely free Excel repair tool?
Excel’s built-in Open and Repair feature is included with the Windows desktop app and is the best first free option. Third-party tools may restrict saving or recovery in their free editions, so check the terms before relying on them.
Can Excel repair a corrupted file without losing data?
Sometimes, but there is no guarantee. Try Repair on a copy first. If it fails, Extract Data may retrieve some values or formulas, usually with less of the workbook’s original structure preserved.
Can I repair an Excel file online for free?
Some services offer online recovery, but uploading a workbook can expose its contents to another provider. Avoid this for sensitive data unless you have reviewed and accepted the service’s privacy and retention terms.
Why does Open and Repair not appear in Excel?
The Windows desktop version has the Open and Repair command; Excel for the web and Mac may not provide the same option. Check which Excel edition you are using, and try a backup or version history if the command is unavailable.
Will repairing Office fix my damaged spreadsheet?
Not necessarily. Office repair addresses problems with the Excel application, while workbook repair addresses a particular file. If only one spreadsheet is affected, look for a backup and use workbook recovery options first.
Related
- Excel Number Format Color Codes and Custom Formats
- Excel Number Format Brackets for Negative Numbers Explained
- Excel Number Format for Millions: Codes and Examples
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Go From Double to Single Space in Microsoft WordTo change double-spaced text to single spacing in Microsoft Word, select the text—or press Ctrl+A on Windows or…
- Debt Snowball Spreadsheet in Google Sheets: How to Make OneYes—you can make a debt snowball spreadsheet in Google Sheets by listing each debt, sorting by balance from…
- Google Sheets COUNTIF by Text Length: Formulas & TipsTo count entries that are exactly five characters long in Google Sheets, use =SUMPRODUCT(--(LEN(A2:A100)=5)), assuming the values are…
- How to Make Two Numbered Columns in Microsoft WordTo make two numbered columns in Word, choose Layout > Columns > Two, then start or select one…
- How to Add a Timestamp in Google Sheets AutomaticallyTo add a fixed timestamp in Google Sheets, select a cell and press Ctrl+Alt+Shift+; on Windows or ChromeOS;…
- How to Insert a Green Checkbox in ExcelTo add a clickable checkbox in Microsoft Excel for Microsoft 365 on Windows, select the target cell or…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.