File Cannot Open

How to Open an Excel File That Is Actually a ZIP Archive

Jason MillerJason Miller Nov 14, 2026 868 views

Question details

The user needs to identify whether a file that Excel cannot open is a ZIP archive and retrieve any workbook inside it.

How to Open an Excel File That Is Actually a ZIP Archive
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.
Before you start

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.

Solution 1Recommended

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.

1
Show the full filename

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.

2
Check and rename the file

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.

3
Extract the archive

Right-click the .zip file and select Extract All, or use a trusted ZIP utility. Choose a destination and select Extract.

4
Open a recovered workbook

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.

If no separate workbook appears: If you see only workbook internals, restore the original .xlsx extension and try opening the original file rather than the extracted XML files. If the archive cannot be extracted or the workbook still will not open, request a fresh copy from the sender.
Open recovered workbooks

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. 1. Extract the trusted archive: In Windows File Explorer, right-click the .zip file and choose Extract All, then select Extract.
  2. 2. Find the workbook: Open the extracted folder and look for a separate file ending in .xlsx or .xls.
  3. 3. Open WPS Spreadsheets: Launch WPS Office and select Open to browse for the extracted workbook.
  4. 4. Select the recovered file: Select the .xlsx or .xls file and choose Open to view it in WPS Spreadsheets.
Open a separate workbook recovered from a ZIP archiveCompatible with Microsoft Excel .xlsx and .xls formatsFamiliar spreadsheet interface for reviewing workbook contents
microsoft office alternative - wps office

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.