Open a Corrupted Excel File Online Safely

Sometimes you can open a corrupted Excel file online, but Excel for the web does not include the desktop Excel repair command and cannot reliably fix a damaged workbook. Make a copy first, try opening it in Excel for the web, and if that fails use Excel for Windows’ Open and Repair feature or another recovery route; avoid uploading sensitive files to unfamiliar repair websites.

What “corrupted” means

An Excel workbook can become damaged if saving is interrupted, a device loses power, storage fails, a download is incomplete, or a file is changed by software that does not handle its format correctly. Damage may affect the workbook’s internal structure, its worksheets, or particular elements such as formulas, charts, formatting, and macros. A file that refuses to open is not necessarily corrupted, however. A wrong extension, a password prompt, an unsupported feature, a blocked download, or a temporary browser problem can produce a similar symptom.

Modern .xlsx and .xlsm workbooks use a structured package of files, while older .xls workbooks use a different format. Excel and other spreadsheet programs may be able to read some surviving content even when parts of a workbook are damaged, but recovery is not guaranteed. Online access is useful for checking whether the workbook opens and for working with a healthy copy; it is not a substitute for a repair utility.

Try opening it with Excel for the web

Excel for the web runs in a browser and stores or edits workbooks through OneDrive or a work or school SharePoint library. To try it, first save a duplicate of the damaged file on your device. Upload that duplicate to OneDrive or the appropriate SharePoint location, then select the uploaded workbook to open it in Excel. You can also use the Microsoft 365 file picker to choose a workbook stored in a supported cloud location.

If the workbook opens, check more than whether a sheet appears on screen. Look at the sheet tabs, key totals, formulas, and important charts. Compare a few results with a known source or an older copy. Excel for the web may open a workbook while some features behave differently from desktop Excel, so a visible worksheet is not proof that every feature survived intact. Preserve the original and save recovered work under a new name rather than replacing the only copy.

If Excel for the web reports that the file cannot be opened, shows an error, or loads a blank or incomplete workbook, stop retrying on the same original. Download the uploaded copy and move on to a repair or recovery method. Repeatedly opening or resaving a file is not a dependable way to repair its internal structure.

Protect the original before recovery

Before trying repairs, keep an untouched copy. If the workbook is on a company network, an external drive, or a cloud service, copy it to a separate location rather than working directly on the only stored version. A file can be damaged further by a failed save, and a recovery attempt may produce a workbook that omits content. Keep both the original and every recovered version until you have checked the results.

Make a duplicate and give it a clear name, such as Budget-recovery-copy.xlsx.
Check the file size and extension. A zero-byte or unexpectedly tiny file may be an incomplete download, not a workbook that a repair tool can reconstruct.
If the file came from email or a website, download it again from the original source when possible.
If it is in OneDrive or SharePoint, check its version history for an earlier, healthy version before attempting a repair.

Do not rename a file to .xlsx merely to make Excel accept it. Changing the extension does not convert its internal format. If a file is password-protected or encrypted, you will generally need the password; an online viewer cannot legitimately bypass that protection.

Use Open and Repair in Excel for Windows

For a workbook that will not open online, the most direct built-in repair attempt is in the Microsoft 365 desktop app for Windows. Open Excel, choose File > Open > Browse, select the damaged workbook, and click the arrow beside the Open button. Choose Open and Repair. In the prompt, try Repair first. If Excel cannot repair the workbook, try Extract Data, which may recover values and formulas while leaving other workbook content behind.

Open and Repair is a recovery attempt, not a promise that the original workbook can be restored. The resulting file may have missing formatting, charts, links, formulas, or other objects. Save any successful result as a new workbook, close it, and reopen that saved copy to check that it remains accessible. Compare important figures against an independent source before relying on them.

The exact Open and Repair command described here is for Excel on Windows. Excel for the web does not provide that command. Excel for Mac has different recovery behavior and menus, so do not assume the Windows path appears on a Mac. If you have access to a Windows computer with desktop Excel, you can make the repair attempt there on a duplicate, then upload the recovered copy for browser access.

When Excel opens only part of the workbook

Sometimes Excel opens a workbook but reports problems, removes unreadable content, or displays incomplete sheets. Take the recovery prompt seriously and keep a separate copy before proceeding. If the workbook opens far enough to view data, copy important ranges into a new workbook or export essential sheets to a simpler format. A CSV file can preserve plain text values from one sheet, but it does not preserve multiple sheets, formulas as formulas, charts, formatting, or macros.

Check formulas as well as displayed numbers. A cell may show a plausible cached result even though its formula is missing or no longer calculates correctly. Also inspect named ranges, external links, hidden sheets, and pivot tables if the workbook depends on them. A recovered file should be treated as unverified until its important calculations and records have been compared with a trusted source.

Alternatives to online opening

If Excel for the web cannot open the file, several alternatives may help, depending on what is damaged and what software you have available:

Restore an earlier cloud version: OneDrive and SharePoint can offer version history for files stored there. Select an earlier version and inspect it before deciding whether to restore it. Version availability depends on the account, library settings, and retention rules.
Try another desktop spreadsheet app: LibreOffice Calc may open some workbooks that Excel cannot, though it can also fail and may change formatting or features. Work from a duplicate and verify the output before using it.
Recover the source: If the workbook was downloaded, request a fresh copy or download it again. If it was generated by an accounting, reporting, or database system, export the data again from that system.
Ask the file owner or IT team: An earlier backup, synchronized copy, or managed retention system may be safer than a third-party repair site.

Google Sheets can import some Excel workbooks, but importing is not equivalent to repairing them. Conversion may affect formulas, formatting, macros, charts, or Excel-specific features. Use it only on a copy, and check the converted workbook against the original requirements before relying on it.

Privacy and security when using repair websites

Online repair services generally require you to upload the workbook to someone else’s server. That can expose names, payroll details, customer records, financial data, formulas, or confidential business information. A service’s marketing claims do not establish what it retains, who can access it, or how securely it handles uploaded files. Do not upload a sensitive workbook unless your organization has approved the service and you understand its data-handling terms.

Be cautious of sites that ask you to install an unknown program, disable security settings, or provide your Microsoft password. A repair tool should not need your account password to inspect a local file. For confidential or regulated data, prefer a trusted local copy, Microsoft’s built-in recovery options, an approved IT administrator, or a vendor operating under your organization’s security requirements.

How to choose the right recovery route

Choose based on the likely cause and the importance of the data. If a cloud file worked yesterday and changed today, version history is a strong first check. If a download is incomplete, download it again. If only one computer has trouble, test a duplicate on another device or in the desktop application before concluding that the file itself is damaged. If Excel explicitly reports unreadable content, try Open and Repair on Windows.

For a workbook with critical calculations, macros, or business records, prioritize a verified backup or source-system export over a quick conversion. For a non-sensitive file where only basic values matter, a separate spreadsheet application may help extract readable data. In every case, compare recovered content with a reliable source. A workbook that opens successfully can still contain missing or altered information.

Preventing future workbook damage

Keep important workbooks in a location with a suitable backup or version history, and allow uploads or synchronization to finish before shutting down a device. Avoid editing the same file simultaneously in multiple applications unless the service supports that workflow. Keep Microsoft 365 and the operating system updated, and do not interrupt a save or disconnect removable storage while Excel is writing a workbook.

For especially important files, periodically keep a separate backup and test that it opens. A synchronized folder is convenient, but synchronization alone is not always the same as an independent backup: unwanted changes or deletion can synchronize too. For shared workbooks, use clear filenames or version history rather than maintaining several ambiguous copies that may not contain the same data.

Frequently Asked Questions

Can Excel for the web repair a corrupted file?
Excel for the web can open supported workbooks, but it does not provide the desktop Windows Open and Repair command. If it cannot open the file, use a copy with desktop Excel or another recovery option.

Is it safe to upload a damaged workbook to a free repair website?
It depends on the workbook and the provider, but uploading can expose all data stored in the file. Avoid third-party services for confidential information unless they are approved and their data practices meet your requirements.

Can Google Sheets open a corrupted Excel workbook?
It may import a workbook that Excel for the web cannot open, but it is not a guaranteed repair method. Conversion can change Excel-specific features, so use a duplicate and verify the recovered data.

Will changing .xls to .xlsx fix the workbook?
No. Renaming changes the filename extension, not the file’s internal format. Use the application’s Save As or conversion feature on a workbook that can be opened instead.

What if Open and Repair does not work?
Try Extract Data, check cloud version history or backups, obtain a fresh source copy, or ask an IT administrator. If another application can read the file, save a separate recovered copy and verify its contents.

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.