Repair an Excel Workbook with a Sheet1.xml Error
Question details
The user needs to recover an Excel workbook with an XML error in sheet1.xml.

- 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.
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.
Use Excel Open and Repair to Recover the Workbook
Try Excel's built-in recovery option before editing the workbook's XML.
In Excel, select File > Open > Browse and locate the copied workbook.
Select the workbook, click the arrow beside the Open button, and choose Open and Repair.
Choose Repair. If Excel cannot repair the workbook, repeat the process and choose Extract Data to recover available values and formulas.
Review the recovered worksheets, then use File > Save As to save the result under a new name.

Inspect and Correct the Sheet1.xml File
Use this advanced method if Open and Repair fails and the reported XML location can be identified.
Restore a Previous Workbook Version
Use an earlier copy if the workbook cannot be repaired or recovered content is incomplete.
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.

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 < 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.




