Open a ZIP File in Excel: Extract and Import Data

You can’t open a ZIP archive directly in Excel. First extract its contents with File Explorer, then open the included Excel workbook or import a CSV file. These steps are for Excel for Microsoft 365 on Windows; if you use a Mac or Excel for the web, see the differences below.

What You’ll Need

The ZIP file saved on your computer. If it came by email or download, make sure the download has finished.
Microsoft Excel for Microsoft 365 if you want to open or import the extracted spreadsheet data.
Permission or a password if the archive is protected. For a work file, follow your organization’s security rules.
Enough disk space to extract the archive. Extracted files can take up more room than the compressed ZIP.

Step-by-Step

Find the ZIP file. Open File Explorer with Windows key + E, then browse to the folder where the ZIP was saved, such as Downloads. A ZIP file usually has a zipper icon, and its name ends in .zip. If you are unsure which file is the archive, right-click it and choose Properties to check its file type. Do not rename the extension just to make Excel recognize it; changing the name does not extract the contents.
Extract the archive. Right-click the ZIP and select Extract All…. In the dialog, review the destination folder. Windows normally suggests a folder near the ZIP file with the archive’s name. Leave Show extracted files when complete selected if you want File Explorer to open the result automatically, then select Extract. The original ZIP remains in place; extraction creates a separate, usable copy of its contents.
Open the extracted folder and identify the file type. Look at the names and extensions inside the new folder. Common spreadsheet formats include .xlsx and .xls; comma-separated data often uses .csv. A ZIP might also contain a PDF, text file, images, or several folders. Excel cannot turn every file type into a spreadsheet, so choose the actual workbook or data file rather than the archive itself.
Open an Excel workbook if one is included. Double-click an .xlsx or .xls file to open it in Excel. If double-clicking opens another app, start Excel, select File > Open > Browse, navigate to the extracted folder, select the workbook, and choose Open. If the file is an older format, Excel may show a compatibility message; read it before saving in a newer format.
Import a CSV when the archive contains one. In Excel, select Data > Get Data > From File > From Text/CSV. Browse to the extracted CSV and select Import. Check the preview for the delimiter, encoding, and column layout, then select Load to place the data in a worksheet. This route lets you review how Excel will interpret the file before loading it.
Check the imported or opened data. Look for headings, rows, dates, decimal values, and text that begins with zero, such as postal codes or product IDs. CSV files do not store Excel formatting or formulas in the same way as a workbook, and Excel may interpret some values automatically. If columns appear in one column or numbers look different from the source, review the import settings or reopen the CSV through the import process.
Save a working copy in an Excel format. For a CSV you imported, select File > Save As, choose a destination, and select Excel Workbook (*.xlsx) as the file type. This lets you preserve formatting and workbook features in the copy. Keep the original CSV if another person or system needs the plain-text file. For an existing workbook, use File > Save As if you want a separate copy rather than overwriting the extracted original.
Keep the extracted files organized. Once you have confirmed the workbook or imported data is correct, you can move the extracted folder to a suitable location. Avoid moving or deleting it while Excel still relies on a file in that folder. You can keep the ZIP as an untouched backup or delete it only if you no longer need the original compressed download.

On a Mac: Finder can usually extract a ZIP when you double-click it; macOS Archive Utility creates an extracted folder beside the archive. Open the resulting workbook in Excel for Mac, or use Excel’s Data tab and its text/CSV import option for CSV data. The exact labels can differ slightly by Excel for Mac version. In Excel for the web: download the ZIP and extract it on your computer first; the web app does not extract a local ZIP for you. Then upload or open the extracted workbook, or upload the CSV to OneDrive and open it with Excel.

Common Mistakes

Trying to select the ZIP in Excel. A ZIP is a container, not an Excel workbook. Extract it first; changing the filename from .zip to .xlsx does not convert it and can make it harder to identify.
Opening the wrong item in the extracted folder. Archives often include read-me files, images, or a nested folder before you reach the spreadsheet. Check extensions and folder names rather than assuming the first item is the data.
Editing a CSV without checking how values were interpreted. Excel may display long numbers in scientific notation, remove leading zeros, or recognize text as dates. Inspect important identifiers and dates before saving. For data where exact text matters, use the import preview and choose appropriate column data types where available.
Saving over the only source copy. Keep the original ZIP and, when relevant, the original CSV until you have verified your Excel copy. Saving a CSV as .xlsx is useful, but it does not preserve the CSV as an unchanged source file.
Assuming extraction and workbook passwords are the same. A password may be required to extract the archive, to open a workbook, or both. These protections are separate; use the password supplied by the sender for the relevant file.

Tips

Extract to a clearly named folder. If the ZIP contains several files, placing them in a folder with the archive’s name makes it easier to distinguish the extracted contents from unrelated downloads.
Use the CSV import preview for important data. Check whether the separator is a comma, semicolon, or tab, and confirm that the preview shows the intended columns. Regional settings and the way a CSV was created can affect how separators are interpreted.
Preserve identifiers as text. Codes such as 00127 may lose their leading zeros if treated as numbers. If that information is meaningful, set the column to Text during import when the option is available, or verify it before saving.
Check what the sender intended you to open. Some ZIPs contain multiple versions of a report or a workbook plus a data file. Read any included instructions, and avoid opening unexpected executable files such as .exe files.
Protect confidential data. Avoid uploading a work or personal ZIP to an unknown online extraction site. Use your computer’s built-in extraction tool or an application approved by your organization.

Troubleshooting

There is no Extract All option. Confirm that you right-clicked a ZIP file, not a shortcut or a file inside the archive. In Windows 11, the option may be on the first context menu; if not, choose Show more options and look for the extraction command. You can also open the ZIP in File Explorer and use Extract all on the toolbar. If the file is not a ZIP, use an application that supports its actual archive format.
Windows says the ZIP is invalid or cannot be opened. The download may be incomplete or damaged. Download it again from the original trusted source, and check that the file size is plausible. If it is on a network drive or removable disk, copy it to a local folder and try again. If the sender created a nonstandard or encrypted archive, ask which extraction tool and password are required instead of trying random utilities.
The archive asks for a password. Ask the sender for the password and confirm whether it applies to the ZIP or to the spreadsheet inside it. Windows’ built-in extraction may not handle every encrypted ZIP type. If it cannot extract the archive, use a reputable archive utility approved for your computer and organization; do not send confidential contents to an online extractor.
Excel says the file format or extension is not valid. Check that you selected an extracted workbook, not the ZIP, and that the download completed. If the file has a misleading extension or the sender supplied a different format, ask for a new copy in .xlsx or .csv. Do not simply rename a ZIP or other file to .xlsx; the contents must actually be in that format.
The CSV appears in one column or has garbled characters. Close it without saving unwanted changes, then import it again with Data > Get Data > From File > From Text/CSV. Choose the delimiter that matches the source and check the preview. If accented characters are incorrect, try an appropriate file origin or encoding option in the import dialog. If the columns are already loaded into one column, use the import route again rather than relying on a double-click.
The workbook is blocked or opens in Protected View. Files downloaded from the internet may be marked as coming from an untrusted location. Only proceed if you trust the sender and expected the file. If your organization manages security settings, ask its support team before changing protection settings or enabling editing. Never enable macros merely to view a spreadsheet unless the file and its purpose are trusted.

Frequently Asked Questions

Can I open a ZIP file directly in Excel?
No. Excel opens spreadsheet formats, not ZIP archives. Extract the archive first, then open the included workbook or import a supported data file such as CSV.

What if the ZIP contains several Excel files?
Open the extracted folder and check the filenames, dates, and any included read-me file. Open the workbook that matches your task. If you are unsure which is current, ask the sender rather than combining files or choosing based on filename alone.

Can Excel open a CSV file from a ZIP?
Yes, after you extract the CSV. Use Data > Get Data > From File > From Text/CSV to preview and import it, or open it directly if the data is simple and you have checked how Excel interprets it.

Will extracting the ZIP delete or change the original?
No. The usual Windows extraction process creates a separate folder and leaves the ZIP in place. You can retain both, which is useful if you need to return to the original download.

Why does my extracted file not open in Excel?
It may not be an Excel-compatible file, the download may be incomplete, or the file may have a misleading extension. Check the extension and ask the sender for the intended format. Excel can open common workbooks and import formats such as CSV, but it cannot open every file stored in an archive.

Can I extract a ZIP in Excel for the web?
No. Extract it on your computer or with an approved file-management tool first. Then upload the extracted workbook to OneDrive or open the CSV in Excel for the web.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.