How to Open an Excel File That Is Actually a ZIP Archive
Question details
The user needs to identify whether a file that Excel cannot open is a ZIP archive and retrieve any workbook inside it.

- Product
- Microsoft Excel and Excel for the web
- Device & OS
- not provided
- Scenario
- An Excel file has a suspicious or incomplete filename and may be an archive containing a workbook.
- Observed behavior
- The file cannot be opened in Excel or Excel for the web.
Proceed only if the file came from a trusted source, and check its full filename and extension before changing it. An .xlsx workbook is itself ZIP-based, so ZIP-format contents do not necessarily mean it is an archive containing a separate workbook.
Check the extension and extract a trusted archive
Use this approach when the file may be a ZIP archive containing a separate Excel workbook.
Renaming a file changes its extension, not its contents. If extraction reveals folders such as xl and _rels and a file named [Content_Types].xml, those may be the internal contents of an .xlsx workbook rather than a separate workbook to open.
On Windows, open File Explorer and enable View > Show > File name extensions. On older Windows versions, use the File name extensions checkbox on the View tab.
Inspect the full filename. If the trusted file is believed to be a ZIP archive and has no usable extension, right-click it, select Rename, and add .zip to the end. Confirm the extension-change warning if prompted.
Right-click the .zip file and select Extract All, or use a trusted ZIP utility. Choose a destination and select Extract.
Look in the extracted folder for a separate .xlsx or .xls file. Open it in Excel using File > Open, or upload it to Excel for the web.
Open a recovered Excel workbook in WPS Spreadsheets
After extracting a trusted archive with your operating system or a ZIP utility, use WPS Spreadsheets to open the recovered workbook.
- 1. Extract the trusted archive: In Windows File Explorer, right-click the .zip file and choose Extract All, then select Extract.
- 2. Find the workbook: Open the extracted folder and look for a separate file ending in .xlsx or .xls.
- 3. Open WPS Spreadsheets: Launch WPS Office and select Open to browse for the extracted workbook.
- 4. Select the recovered file: Select the .xlsx or .xls file and choose Open to view it in WPS Spreadsheets.

Frequently Asked Questions
Why does an .xlsx file contain ZIP-format data?
An .xlsx workbook is a ZIP-based package containing XML files and other resources. Seeing ZIP contents alone does not mean it contains a separate workbook.
Will adding .zip fix a damaged Excel file?
No. Renaming changes the extension but does not repair or convert the contents. If extraction fails or the recovered workbook will not open, ask the sender for a fresh copy.
What if the extracted folder contains an xl folder but no .xlsx file?
The archive may be the internal package of an .xlsx workbook. Restore the original file's .xlsx extension and try opening that file; do not try to open the extracted XML files as a workbook.
Can I open the recovered workbook in Excel for the web?
If extraction produces a separate supported workbook, upload that workbook to OneDrive and open it in Excel for the web. Uploading the outer ZIP archive will not open the workbook.




