File Corruption & Recovery

Repair an Excel Workbook with a Sheet1.xml Error

Steve KSteve K Nov 18, 2026 870 views

Question details

The user needs to recover an Excel workbook with an XML error in sheet1.xml.

Repair an Excel Workbook with a Sheet1.xml Error
Product
Microsoft Excel
Device & OS
not provided
Scenario
Opening an Excel workbook that contains a malformed worksheet XML file.
Observed behavior
Excel reports that it replaced the sheet1.xml part because an attribute value contains an invalid less-than character.
Before you start

Make a copy of the workbook and work on that copy. Note the XML error location if Excel provides one, and confirm that the file is an .xlsx workbook before inspecting its contents as a ZIP archive.

Solution 1Recommended

Use Excel Open and Repair to Recover the Workbook

Try Excel's built-in recovery option before editing the workbook's XML.

1
Browse for the workbook

In Excel, select File > Open > Browse and locate the copied workbook.

2
Choose Open and Repair

Select the workbook, click the arrow beside the Open button, and choose Open and Repair.

3
Repair or extract data

Choose Repair. If Excel cannot repair the workbook, repeat the process and choose Extract Data to recover available values and formulas.

4
Check and save the result

Review the recovered worksheets, then use File > Save As to save the result under a new name.

Use Excel Open and Repair to Recover the Workbook
Check recovered content: Repair or data extraction may remove some content or formatting. Compare the result with a previous version if one is available.
Free Microsoft Office alternative

Work with Recovered Excel Files in WPS Spreadsheets

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open a valid or recovered workbook in WPS Spreadsheets to continue working with your files; it does not repair Excel's specific XML error.

Open and edit compatible Excel .xlsx and .xls workbooksReview recovered worksheet data in WPS SpreadsheetsUse a familiar spreadsheet interface for an easier transition from ExcelAccess a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

What does the sheet1.xml error mean?

The XML file for a worksheet contains content that does not follow XML syntax. In this case, Excel reports a less-than character inside an attribute value, where a literal < is not allowed.

Where is Open and Repair in Excel?

Go to File > Open > Browse, select the workbook, click the arrow beside Open, and choose Open and Repair.

Will Open and Repair preserve all my workbook data?

Not necessarily. Excel may remove damaged content, and Extract Data focuses on available values and formulas. Review the recovered workbook and compare it with an earlier version if possible.

Can I replace every less-than character in sheet1.xml?

No. Less-than characters also mark XML tags. Only replace a literal < with &lt; when it is meant to be data inside an attribute value, or correct the specific malformed syntax.

What if I cannot repair sheet1.xml?

Check the file's Version history in OneDrive or SharePoint, if available, and restore or download an earlier version. You can also try Excel's Extract Data option through Open and Repair.