How to Open a Corrupted Excel File Online and Recover Data

To try opening a corrupted Excel file online, first save an untouched copy, upload a duplicate to OneDrive, and open it in Excel for the web. If that fails, check OneDrive version history or try importing a copy into Google Sheets. These options may let you access or salvage data, but they cannot guarantee that a damaged workbook will be repaired.

What You’ll Need

The original workbook file, such as an .xlsx or .xls file. If it is still open on another computer, save a copy there before trying recovery.
A stable internet connection and a Microsoft account with access to OneDrive and Excel for the web. A Google account is useful if you want to try the Google Sheets import option.
Enough cloud storage for a second copy of the workbook. Keep the original unchanged until you have checked any recovered file.
If the workbook contains private, customer, financial, health, or business information, use only an account or service approved for that data. Avoid uploading sensitive files to unfamiliar repair websites.

Step-by-Step

Make a separate working copy. In File Explorer on Windows, right-click the workbook and choose Copy, then right-click in a different folder and choose Paste. Rename the copy so you can tell it apart from the original. If the workbook is already in OneDrive, download a copy or use Save a copy if Excel can still open it. Do not overwrite the only copy with a version that may have lost data. If the file is zero bytes or much smaller than expected, the download or sync may have stopped before the workbook was fully saved; get a fresh copy from its source before trying repair.
Check whether the problem is the file or its location. Confirm that the filename ends in a format Excel supports, such as .xlsx, .xls, or .xlsm, and that the extension has not been accidentally changed. If the file came from email, a shared folder, or a browser download, save it locally before uploading it again. A network interruption, incomplete sync, or blocked download can look like corruption. If the file is password-protected, have the correct password ready; an online viewer cannot bypass encryption.
Upload the copy to OneDrive. Sign in to OneDrive in a browser, open the folder where you want to keep the test file, and choose Upload, then Files. Select the duplicate workbook and wait for the upload to finish. Check that the file appears in the folder with a plausible size. Do not close the browser while an upload is still in progress, especially for a large workbook.
Open it in Excel for the web. Select the uploaded file in OneDrive. If a prompt asks how to open it, choose Excel for the web or Open in browser. Give the workbook time to load. If it opens, immediately use File > Save As > Save a copy, give the copy a new name, and save it to OneDrive. This preserves a separate version before you edit or download anything. Menu wording can vary slightly by account, but the goal is to create a new copy rather than replace the source.
Check the contents, not just the opening message. Browse the sheets and inspect key rows, columns, formulas, charts, and dates. Look for blank sheets, missing ranges, error messages, or values that appear truncated. If Excel for the web shows a recovery notice, read it before accepting changes. Test important formulas in a few cells and compare totals with a known copy or report if one exists. A workbook can open while still having missing or altered content.
Try OneDrive version history if the workbook was stored there before. In OneDrive, find the workbook, open its menu (often shown as three dots), and select Version history. Review the dates and sizes of earlier versions. If a version from before the problem is available, download it first or restore it only after making a copy of the current file. Restoring an earlier version may replace the current OneDrive version, so do not treat the restore command as a harmless preview.
Try Google Sheets with another copy if Excel for the web cannot open it. Sign in to Google Sheets, start a blank spreadsheet, and choose File > Import > Upload. Select the duplicate workbook and follow the import prompts. Choose an option that creates a new spreadsheet rather than replacing an existing one. If the import works, check whether the data you need is present, then use File > Download to export an Excel format if appropriate. Sheets may change or omit Excel-specific formatting, formulas, macros, charts, or other workbook features, so treat this as a way to inspect or extract data, not as a guaranteed repair.
Consider an online repair service only for a non-sensitive copy. If the official cloud options fail, some third-party sites offer workbook repair. Before uploading, check the provider’s privacy policy, retention and deletion terms, file-size limits, supported formats, and whether it charges for recovery. Do not upload confidential material unless your organization has approved the service. Download any recovered file to a new folder, scan it using your usual security software, and inspect it before using it. Never provide your Microsoft or Google password to a repair website.
Keep the best result separate and verify it. Save the recovered or imported file under a new name and keep the original and working copy until the result has been checked. Reopen the downloaded file in Excel if available. Confirm sheet names, important values, formulas, named ranges, and any macros or links you rely on. If the data is incomplete, do not continue editing that copy as though it were intact; try another recovery route or use a known-good earlier version.

Common Mistakes

Uploading the only copy is risky. A repair attempt, conversion, or mistaken restore can replace useful content. Always preserve an unchanged original and work from a duplicate.

Assuming that opening means repairing. Excel for the web may display a workbook or let you save a copy without restoring every damaged part. Check actual values and formulas before relying on it.

Changing the file extension to force it open. Renaming a damaged file from .xlsx to .xls does not convert its contents and can make diagnosis harder. Use an import or save-as feature when changing formats.

Using the first repair website in search results. A workbook can contain sensitive data, embedded files, links, and hidden sheets. Uploading it shares that information with the provider, and a privacy claim is not a substitute for your organization’s approval.

Ignoring conversion differences. Google Sheets can be helpful for viewing data, but it may not preserve Excel macros, some formulas, formatting, pivot tables, or other advanced features. Do not use a converted file as a replacement until you have compared it with the original requirements.

Tips

Keep recovery attempts organized: label files Original, Test, and Recovered, and note which method produced each one.
If the workbook is in OneDrive, SharePoint, or another managed service, check version history before trying a third-party repair tool. An earlier saved version is often the cleanest recovery route.
For a large file, use a reliable connection and wait for upload completion. Avoid repeatedly refreshing the page while the workbook is opening or saving.
If Excel for the web opens the workbook, save a separate copy before making changes. Then verify important calculations and compare a few totals against a trusted source.
If you can access Excel for Microsoft 365 on Windows, its desktop repair command may be worth trying on another copy: choose File > Open > Browse, select the file, select the arrow beside Open, and choose Open and Repair. This is a desktop option, not a feature in Excel for the web.
For future protection, keep AutoSave on when appropriate, save important workbooks to a service with version history, and make periodic backups. Version history helps only when a usable earlier version was actually saved.

Troubleshooting

OneDrive says the file cannot be previewed or opened. Confirm that the upload finished and that the file is not empty. Try a different browser or a private browsing window, then upload a fresh duplicate. If the workbook is very large or uses unsupported features, Excel for the web may not be able to load it; try the Windows desktop repair option or an earlier version instead.

Excel for the web reports that the workbook is damaged. Do not keep retrying on the only copy. Check version history, then try Google Sheets with a duplicate if the information is not sensitive and conversion is acceptable. If you need the workbook’s full Excel features, use the Windows desktop Open and Repair route or contact your organization’s IT team.

The file asks for a password or says access is restricted. This is not necessarily corruption. Use the workbook password or ask the owner to grant access. A repair service cannot legitimately remove encryption, and you should not send passwords or account credentials to one.

The workbook opens, but sheets or formulas are missing. Compare it with an earlier OneDrive version or another backup. Check whether you opened the correct file and whether the missing content was on a hidden sheet. If the file came through Google Sheets, some Excel features may not have transferred; return to the untouched Excel copy for another recovery method.

An online repair service returns an error or asks for payment. Check its stated size and format limits before uploading again. Do not pay until you understand what the fee covers and whether you can preview the result. If the workbook is confidential, stop and use an approved IT or Microsoft support channel rather than trying another unknown site.

The recovered workbook triggers a security warning. Keep it separate and do not enable macros or external content just to see whether it opens. Ask your IT administrator to review it if it came from an unknown source or contains business data. A repair result should be treated as an untrusted file until checked.

Frequently Asked Questions

Can I repair a corrupted Excel file entirely online?
Sometimes you can open it, retrieve an earlier version, or recover some data online. Excel for the web does not provide the Windows desktop Open and Repair command, and no online method can guarantee recovery.

Is Excel for the web free to use for this?
Excel for the web is available through a Microsoft account, although available storage and organization features depend on the account. You need to sign in and upload the workbook to OneDrive to open it there.

Can Google Sheets fix a corrupted Excel workbook?
It may be able to import a copy that Excel for the web will not open, which can help you retrieve visible data. It is not a dedicated repair tool, and conversion can change or discard Excel features.

Will an online repair website keep my workbook private?
That depends on the provider’s handling and retention practices. Read its privacy and deletion terms, and do not upload confidential files unless the service is approved for that information.

What if the workbook is password-protected?
Use the correct password to open it. Password protection is different from corruption, and neither Excel for the web nor a repair service should be expected to bypass encryption.

When should I stop trying online recovery?
Stop if the file contains sensitive information and a service is not approved, if repeated attempts risk overwriting the only copy, or if the recovered data is incomplete. Preserve the file and ask your IT team or a qualified data-recovery professional about the next step.

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.