To extract a ZIP file in Excel, you do not use Excel itself—you use Windows File Explorer or macOS Finder to unzip the folder, then open the contained .xlsx file in Excel. Right-click the ZIP file, choose Extract All (Windows) or double-click it (Mac), and then open the extracted workbook.
Why Excel Can’t Open ZIP Files Directly
Excel is a spreadsheet application, not a file compression utility. A ZIP file is a container that holds one or more files compressed together. Excel expects to open a workbook file (like .xlsx, .xlsm, or .xls), not a compressed archive. When you double-click a ZIP file, your operating system handles the decompression, not Excel. If you try to open a ZIP directly from Excel’s File > Open dialog, Excel will either show an error or open a blank workbook because it doesn’t recognize the format.
How to Extract a ZIP File on Windows
- Locate the ZIP file in File Explorer.
- Right-click the file and select Extract All from the context menu.
- Choose a destination folder (or accept the default, which is the same folder as the ZIP file).
- Click Extract. The unzipped files appear in the destination folder.
- Open the extracted .xlsx file by double-clicking it—Excel launches and loads the workbook.
If you prefer, you can also open the ZIP like a folder: double-click it, then drag the .xlsx file out to your desktop or another folder. This works because Windows treats ZIP files as compressed folders.
How to Extract a ZIP File on Mac
- Double-click the ZIP file in Finder. The Archive Utility automatically decompresses it into a folder with the same name.
- Open the resulting folder.
- Double-click the .xlsx file inside to open it in Excel.
If double-clicking doesn’t work (for example, if you’ve changed default apps), right-click the ZIP and choose Open With > Archive Utility.
What’s Inside an Excel ZIP File?
An .xlsx file is itself a ZIP archive. If you rename a copy of an .xlsx file to .zip and extract it, you’ll see a folder structure containing XML files. That structure includes:
- xl/ – the main workbook data, sheets, styles, and shared strings
- docProps/ – document properties like title and author
- _rels/ – relationship files that link parts together
- [Content_Types].xml – declares the content types of each part
This is why you can sometimes repair a corrupted Excel file by extracting its contents and editing the XML—but that’s an advanced technique and should be done on a copy, not the original.
How to Extract a ZIP File Using Excel VBA
If you need to automate extraction, you can use VBA with the Shell object or the built-in CopyHere method. Here’s a simple macro that extracts a ZIP file to a specified folder:
Sub ExtractZip()
Dim zipPath As String
Dim destFolder As String
Dim fso As Object
' Set paths – change these to your actual file and folder
zipPath = "C:\Users\YourName\Downloads\MyWorkbook.zip"
destFolder = "C:\Users\YourName\Downloads\MyWorkbookExtracted"
' Create the destination folder if it doesn't exist
Set fso = CreateObject("Scripting.FileSystemObject")
If Not fso.FolderExists(destFolder) Then
fso.CreateFolder destFolder
End If
' Use Shell to copy the ZIP contents to the destination
Shell "powershell.exe -Command Expand-Archive -Path '" & zipPath & "' -DestinationPath '" & destFolder & "'", vbHide
MsgBox "Extraction started. Check the destination folder."
End Sub
This uses PowerShell’s Expand-Archive command, which is available on Windows 10 and later. Always save a copy of your workbook before running any VBA macro, as macros cannot be undone with Ctrl+Z.
Common Problems and Fixes
- “The file format or file extension is not valid” – This usually means the file is not actually a ZIP but has a .zip extension, or the ZIP is corrupted. Try opening the ZIP with a dedicated tool like 7-Zip to see if it’s readable.
- ZIP file is password-protected – Excel cannot open password-protected ZIPs. You’ll need to enter the password when extracting (Windows asks for it in the Extract All dialog). If you don’t have the password, you can’t extract.
- Extracted .xlsx still won’t open – The workbook itself may be corrupt. Try Excel’s built-in repair: File > Open > select the file > click the arrow next to Open > choose Open and Repair.
- ZIP contains multiple files – Extract all, then open the one with .xlsx extension. Ignore any .xml or .rels files unless you’re troubleshooting.
Alternatives to Manual Extraction
If you receive a ZIP file regularly, you don’t have to manually extract each time. You can:
- Use a third-party tool like 7-Zip (free) or WinRAR to extract with more options (e.g., extract to a specific folder, handle multi-volume archives).
- Change Windows default behavior to always show ZIP files as folders—this is already the default, but if you’ve installed other software, you can reset it in Settings > Apps > Default apps.
- Use Power Query to import data from a CSV inside a ZIP without extracting: In Excel, go to Data > Get Data > From File > From Text/CSV, then navigate to the ZIP file—Power Query can read files inside a ZIP if you select the ZIP and then the specific file. This works for CSV, but not for .xlsx directly.
Frequently Asked Questions
Can I open a ZIP file directly in Excel?
No. Excel does not have a built-in ZIP extractor. You must extract the ZIP using your operating system or a third-party tool before opening the workbook inside.
Why does my Excel file download as a ZIP?
Some websites or email systems compress .xlsx files into ZIP to reduce size or to bundle multiple files. The file you downloaded is probably a ZIP containing the actual Excel file. Extract it to find the .xlsx.
How do I extract a ZIP file without WinZip?
Windows and macOS both have built-in ZIP extraction. On Windows, right-click > Extract All. On Mac, double-click. No extra software is needed.
What if the ZIP file is corrupted?
Try extracting with 7-Zip, which often recovers more data than the built-in extractor. If that fails, the ZIP may be incomplete—re-download it from the source.
Is it safe to extract a ZIP from an unknown sender?
Be cautious. ZIP files can contain malware. Only extract ZIPs from trusted sources. If you must open one, scan it with your antivirus first, and consider extracting to a temporary folder.
Can I create a ZIP file from Excel?
Excel doesn’t create ZIPs, but you can use VBA to call a compression utility, or simply save your workbook and then right-click the file in File Explorer > Send to > Compressed (zipped) folder.
Related
- Excel Undo Encrypt with Password? How to Remove It
- Excel Truck Group Jobs: Pay, Hiring & Reviews
- Excel Transpose Table: Switch Rows and Columns
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Median in Google Sheets: Formula and Median IfIn Google Sheets, calculate a median with =MEDIAN(B2:B7). For a “median if” calculation—finding the median only for rows…
- Excel and Access: Key Differences and When to Use EachExcel is a spreadsheet for calculations, analysis, and flexible work with data; Access is a database program for…
- Excel Data Validation Lists From Tables, ExplainedYes. In Excel for Microsoft 365 on Windows, turn the source range into a table, create a workbook-level…
- Power Query Editor: How to Split Text into Multiple ColumnsIn Excel for Microsoft 365 on Windows, select the column in Power Query Editor, then choose Home >…
- Enum in Programming: Meaning, Uses, and ExamplesAn enum in programming is a type that defines a named set of related values, such as the…
- Budget and Expense Tracking Excel Template: How to Use ItA budget and expense tracking Excel template is a workbook that compares planned spending with recorded transactions, usually…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.