You cannot open a ZIP archive directly in Excel. First extract the archive in Windows File Explorer, then open an Excel workbook inside it or import a contained CSV or text file. The steps below cover both situations and explain what to do if the ZIP contains several files, is password-protected, or will not extract.
What You’ll Need
- A ZIP file saved on your computer or somewhere you can download it.
- Excel for Microsoft 365 on Windows, if you plan to open or import the extracted data.
- Enough free storage space to extract the archive. If it is encrypted, you will also need its password.
You do not need to rename the ZIP file or change its extension. Extracting it creates a regular folder containing the files you can then use in Excel.
Step-by-Step
- Find the ZIP file. Open File Explorer with Windows+E, then browse to the folder where the archive was downloaded or saved. ZIP files commonly have a .zip ending and a zipped-folder icon. If you cannot find the file, check your Downloads folder or use the File Explorer search box to search for its name.
- Extract the archive. Right-click the ZIP file and select Extract All. In the window that appears, check the destination folder. Windows normally suggests a new folder with the same name as the ZIP file beside the archive. You can select Browse to choose another location. Select Extract to unpack the contents.
- Open the extracted folder. If Windows displays an option to show the extracted files when the process finishes, leave it selected to go straight to the new folder. Otherwise, open the destination you chose and then open the folder created for the extracted contents. Do not try to select the ZIP file from Excel’s Open dialog as if it were a workbook.
- Check which file you need. Look at the filenames and extensions. An .xlsx or .xls file is an Excel workbook; a .csv file is comma-separated data; and a .txt file is plain text. The archive may also contain documents, images, subfolders, or a second ZIP file. Excel cannot turn those items into spreadsheet data just because they are in an archive.
- Open an Excel workbook, if one is included. Double-click the extracted .xlsx or .xls file, or open Excel and select File > Open > Browse, locate the extracted file, and select Open. If Windows asks which app to use, choose Excel. If the file came from someone you trust, review any security warning before enabling editing; do not enable macros or other active content unless you know it is safe and required.
- Import a CSV or text file when you want more control. In Excel, open a blank workbook and select Data > From Text/CSV in the Get & Transform Data area. Browse to the extracted .csv or .txt file and select Import. Excel displays a preview. Check that the delimiter, such as comma or tab, separates the columns correctly, and review the data preview before proceeding.
- Choose how Excel handles the imported data. In the preview window, select Load to bring the data into a worksheet, or select Transform Data to open Power Query and review or adjust it first. In Power Query, check column types before loading. For example, set an ID or postal-code column to Text if leading zeros must be preserved. When ready, select Close & Load.
- Save a working copy. After confirming the data looks right, use File > Save As to save a copy as an Excel workbook (.xlsx). This keeps your working sheet separate from the original extracted file. Keep the ZIP and extracted originals until you have checked that the workbook contains the data you need.
If the ZIP contains multiple spreadsheets, open each one you need from the extracted folder. If the goal is to combine several CSV files rather than simply open one, first make sure their columns have compatible headings and formats. Excel’s folder-based import tools can combine files, but that is a separate task from opening one archive and may require extra checking.
Common Mistakes
- Trying to open the ZIP in Excel. A ZIP is a compressed container, not an Excel workbook. Extract it in File Explorer first. Changing .zip to .xlsx does not convert its contents and can make the file harder to identify.
- Opening the wrong item. An archive can hold several files, including readme documents or old copies. Check the file extension and, if filenames are unclear, compare the dates and sizes before opening a candidate.
- Assuming every spreadsheet-looking file is an Excel workbook. CSV files contain text values separated by delimiters; they do not retain Excel formatting, formulas, or multiple worksheets. Import one when you need to inspect or control how Excel interprets its columns.
- Accepting automatic data conversion without checking. Excel may interpret values such as 00124 as the number 124, or read date-like text as a date. Check identifiers, account numbers, postal codes, and dates in the preview or after loading.
- Extracting into a crowded or confusing location. Files may be difficult to find if they are mixed with unrelated downloads. Use the suggested named folder or choose a clear destination, and avoid extracting over another folder with similarly named files.
- Ignoring an unexpected security prompt. A ZIP can contain unsafe files as well as useful data. Do not open an unfamiliar executable or enable macros just to view a spreadsheet. If you did not expect the archive, confirm its source first.
Tips
- Keep the original ZIP. The archive is a compact backup of the files as received. If an extracted copy is edited or deleted, you can extract the original again.
- Use a dedicated folder for each archive. This makes it easier to identify which files came together and reduces the chance of opening a similarly named file from an earlier download.
- Use the import preview for CSV files. The preview can reveal a wrong delimiter or garbled characters before data reaches the sheet. If text displays incorrectly, check the file origin or encoding option in the import workflow and preview the result again.
- Preserve important text values. Set columns such as product codes, postal codes, and long identifiers to Text during import when their exact characters matter. Formatting a number as text after Excel has removed leading zeros will not restore the zeros automatically.
- Use Excel for the web only after extraction. Excel for the web does not open a ZIP archive as a workbook. Extract it on your computer first, then upload or save the individual supported workbook to OneDrive and open it in the browser.
- On a Mac, extract before opening Excel. Double-clicking a ZIP in Finder normally uses macOS Archive Utility to create an extracted folder. Open the resulting workbook in Excel for Mac, or import a text file using Excel’s Data tab; exact ribbon labels can vary slightly by release.
Troubleshooting
Extract All is missing or does not work: Confirm that the selected item is actually a ZIP file and that the download has finished. A partially downloaded archive may have the right name but be incomplete. Try downloading it again, then right-click the new copy and choose Extract All. If the file is in a location where you lack permission, copy it to a folder you can access, such as Documents, and extract it there.
Windows reports that the archive is invalid or damaged: The file may be incomplete, corrupted, or not really a ZIP despite its filename. Download it again from the original source. If the source offers a checksum or another archive format, follow its instructions. Do not simply rename the extension; that does not repair the archive. If the file is important, ask the sender to create and send a fresh archive.
The ZIP asks for a password: Enter the password supplied by the sender or download provider. Windows’ built-in extraction may not support every encryption method used by ZIP files. If a correct password still fails, ask the sender which encryption method they used and whether they can provide a compatible archive. If you use another extraction utility, get it from its official source and avoid uploading confidential files to an unknown online unzip service.
The extracted folder appears empty: Check whether the archive contains another folder or a nested ZIP file. Open the folders and inspect their contents. Also check whether File Explorer is hiding file extensions or whether the expected file was not included in the download. If there is a nested archive, extract that one separately.
The CSV appears in one column or with strange characters: Re-import it using Data > From Text/CSV. In the preview, choose the delimiter that matches the file, such as comma, semicolon, or tab. If accented characters are wrong, try a different file origin or encoding option and verify the preview before selecting Load. If the source uses a regional delimiter, a comma may not be the correct choice.
Excel says the file format or extension is not valid: Make sure you selected the extracted workbook, not the ZIP, and check that the download is complete. If the extension says .xlsx but the file is actually a CSV or another format, return to the sender or source for a correctly labeled file. Avoid changing an extension as a substitute for converting the file.
Frequently Asked Questions
Can Excel open a ZIP file directly?
No. Excel opens workbook formats such as .xlsx and .xls, not ZIP archives. Extract the archive first, then open a workbook or import a supported data file from the extracted folder.
How do I open a ZIP file on a Mac for Excel?
In Finder, double-click the ZIP file to extract it with Archive Utility. Then open the extracted .xlsx or .xls file in Excel for Mac. For a CSV or text file, use Excel’s import options so you can check the delimiter and data types.
Can I open a ZIP file in Excel for the web?
Not as an archive. Extract the ZIP on your computer, then upload the individual workbook to OneDrive and open that workbook in Excel for the web. CSV import and editing options can differ from the desktop app.
What if the ZIP contains several Excel files?
Extract the archive, then open each workbook you need from the resulting folder. If you need to combine their data, check that the sheets have compatible columns and use an appropriate import or consolidation process; extracting alone does not merge them.
Will extracting a ZIP change or delete the original?
Normally, no. Extraction creates a separate folder and leaves the ZIP file in place. You can keep the archive as a backup and delete it later if you no longer need it and have confirmed the extracted files are complete.
Why are the leading zeros missing after importing?
Excel may have treated a code as a number. Re-import the source file and set that column to Text in the preview or Power Query before loading. If you have only the altered workbook, recover the original values from the ZIP or source file where possible.
Related
- How to Open a CSV File in Excel Without Losing Data
- How to Open a Text File in Excel Without Losing Data
- How to Open an AIS JSON File in Excel
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Split a Cell in Google Sheets Into Two CellsTo split text in Google Sheets, select the cell or range, choose Data > Split text to columns,…
- Excel Insert Row Shortcut: Steps for Windows and MacTo insert a row in Excel for Microsoft 365 on Windows, select the row where the new one…
- CSV File vs Excel File: Key Differences and UsesA CSV file stores rows and columns of plain text, while an Excel file can store a formatted…
- Yes/No Dropdown in Google Sheets: Add One in MinutesTo add a Yes/No dropdown in Google Sheets, select the cell or cells, choose Insert > Dropdown, enter…
- Excel Data Validation: Can You Select Multiple Items?No. In Excel for Microsoft 365, a data-validation drop-down list lets you choose one item for a cell…
- Excel: Insert a Checkbox Without the Developer TabYes. In current Microsoft 365 versions of Excel, select the cell or range where you want checkboxes, then…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.