How to Fix Corrupt Excel Files After Unzipping and Rezipping
Question details
The user needs to repair an XLSX file that became unreadable after being extracted as a ZIP and incorrectly recompressed.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Manually editing the XML contents of an Excel workbook by renaming it to a ZIP archive and recompressing it.
- Observed behavior
- The resulting XLSX file is corrupt and cannot be opened because the root structure of the ZIP archive incorrectly includes a parent extraction folder instead of the direct XML contents.
Before making manual changes to the internal XML structure of an Excel file, ensure you have a backup copy of the original unedited file to prevent permanent data loss.
Rebuild the XLSX Archive from the Root Level
Fix the corrupted XLSX file by creating the ZIP archive directly from the internal XML files and folders rather than the parent directory.
Excel files (.xlsx) are technically ZIP archives containing a specific set of XML files. When rezipping these files, the archive must directly contain the structural XML files at its root. Compressing the outer folder creates an extra directory layer, which renders the workbook unreadable.
Navigate into the directory where you originally extracted the contents of your XLSX file.
Highlight all individual items inside the folder. You must specifically select the [Content_Types].xml file along with the _rels, docProps, and xl folders.
Right-click the highlighted files and folders, and choose your archiving tool's option to 'Compress to ZIP file' or 'Add to archive'. Make sure the archive format is set to ZIP.
Rename the newly generated .zip file, changing its extension back to .xlsx.
Double-click the renamed .xlsx file to open it in your spreadsheet software and confirm the corruption issue is resolved.
Edit and Save XLSX Files Securely with WPS Office
Avoid the need for manual XML edits and complex ZIP archive repairs. WPS Office is a highly compatible, free Microsoft Office alternative that allows you to safely edit, save, and recover XLSX files without risking file structure corruption.
- 1. Download WPS Office: Visit the official WPS Office website and download the free installation package for your operating system.
- 2. Install the application: Run the installer and follow the on-screen instructions to set up WPS Office on your computer.
- 3. Open your spreadsheets: Launch WPS Spreadsheet and safely open, edit, and save your .xlsx files with complete format compatibility.
Frequently Asked Questions
Why does my Excel file say it is corrupt after I changed it back from a ZIP file?
Excel files (.xlsx) rely on a strict internal XML structure. If you re-compress the files by zipping the parent folder instead of the files themselves, Excel cannot locate the required [Content_Types].xml file at the root level, resulting in a corruption error.
Which folders and files must be at the root of an Excel XLSX archive?
To ensure your Excel file opens correctly, the root directory of the ZIP archive must contain the [Content_Types].xml file, alongside the _rels, docProps, and xl directories.
Can I use any ZIP extraction tool to modify Excel XML files?
Yes, standard archiving tools like WinRAR, 7-Zip, or the built-in Windows ZIP extractor can unpack and re-pack XLSX files. However, you must ensure the compression method is strictly set to standard ZIP (.zip), not RAR or 7z.
