How to Open a CSV ZIP File in Excel Without Losing Data

How-to basics · Updated November 21, 2026

To open a CSV ZIP file in Excel, first extract the ZIP archive, then import the CSV it contains using Excel’s Data > From Text/CSV command. Check the delimiter and column types in the preview before loading, especially if the data includes dates, long numbers, or codes that begin with zeros.

What You’ll Need

  • A ZIP archive saved on your computer or somewhere you can download it.
  • Microsoft Excel for Microsoft 365 on Windows and permission to save an extracted copy of the CSV.
  • Enough free storage to extract the archive. If it contains several CSV files, you will need to identify which one you want to open.

Step-by-Step

  1. Find the ZIP file. In File Explorer, go to the folder where the archive was downloaded or saved. A ZIP file is a compressed container; Excel does not treat the archive itself as a worksheet or a CSV. If you are unsure which file is the archive, turn on file extensions in File Explorer using View > Show > File name extensions. The archive usually ends in .zip.
  2. Extract the archive. Right-click the ZIP file and choose Extract All…. Choose a destination folder you can find again, such as Downloads or a new folder on your desktop, and select Extract. Windows creates a regular folder containing the archive’s contents. Keep the original ZIP until you have checked that the extracted file opens correctly; extracting does not normally remove the archive.
  3. Locate the CSV inside the extracted folder. Open the new folder and look for a file ending in .csv. An archive may contain a subfolder, a readme, or several data files as well as the CSV. If there are multiple CSVs, check their names and, if needed, their file sizes or accompanying instructions. Do not select a similarly named PDF or text file by mistake.
  4. Start the import in Excel. Open Excel and either create a blank workbook or open the workbook where you want the data to go. On the ribbon, choose Data > From Text/CSV. In some Microsoft 365 layouts, this command is grouped under Data > Get Data > From File > From Text/CSV. Browse to the extracted CSV, select it, and click Import. Choose the extracted file, not the ZIP archive.
  5. Review the preview before loading. Excel displays a preview of the data. Check that each value appears in the expected column and that letters or accented characters look right. If rows are split incorrectly, use the Delimiter control to choose the separator used by the file, such as comma, semicolon, tab, or another character. A comma-separated file is common, but regional settings and the source system can produce other delimiters.
  6. Check data types for important columns. A CSV contains plain text arranged in rows and fields; it does not reliably preserve Excel formatting or instructions about whether a value is a date, number, or code. If a product ID such as 00127 must keep its zeros, select Transform Data and set that column’s data type to Text before loading. Do the same for account numbers, postal codes, or other identifiers. For dates, verify that the preview interprets day and month in the intended order.
  7. Load the data. If the preview looks correct and you do not need to change types, choose Load to place the data in a worksheet. To adjust types or inspect the data in Power Query first, choose Transform Data. After making changes in the Power Query Editor, use Home > Close & Load to send the result to Excel. The import creates worksheet data from the CSV; it does not add the original ZIP as a worksheet.
  8. Check the result and save a workbook copy. Look at the first and last rows, column headings, and any sensitive-looking fields such as dates, IDs, and large numbers. If you need to keep the imported data and Excel features together, use File > Save As and save as an Excel Workbook (.xlsx). Keep the original CSV unchanged if you may need to repeat the import or share the source file.

You can also extract the CSV and double-click it to open it in Excel, or use File > Open to select it. That is quick for simple files, but Excel may automatically guess the delimiter and convert values while opening. The import route is preferable when the data must be checked or preserved carefully.

Common Mistakes

  • Trying to open the ZIP as though it were a spreadsheet. A ZIP archive has to be extracted first. If Excel’s file picker does not show the archive, that is expected; browse to the extracted folder and choose the CSV inside it.
  • Opening the first CSV without checking the archive contents. A ZIP may include separate files for different dates, regions, or data types. Importing the wrong one can look like a successful opening while still giving you the wrong records.
  • Assuming the file must use commas. A semicolon-delimited CSV may open as one long column if Excel expects commas. Check the preview and choose the correct delimiter rather than splitting the data later by hand.
  • Allowing Excel to turn identifiers into numbers. A value such as 00452 may become 452, and formatting that cell as Text afterward will not restore the removed zeros. Set the column to Text during import or reimport from the original CSV.
  • Saving over the source CSV without understanding the format. CSV files do not store multiple worksheets, formulas, charts, or most cell formatting. Save a separate .xlsx copy if you want Excel features, and retain the CSV as the plain-text source.

Tips

  • Use a dedicated extraction folder. If you download similar archives often, create a folder for each download or date. This makes it easier to tell which extracted CSV belongs to which ZIP and reduces the chance of importing an older file with the same name.
  • Check file size before assuming an extraction failed. A large archive can take time to extract. The extracted CSV may be much larger than the ZIP because compression reduces the archive’s size. Wait for extraction to finish before importing.
  • Keep identifiers as text. IDs, postal codes, and tracking numbers may contain only digits but are not quantities. Text preserves leading zeros and avoids scientific notation for long values. In Power Query, set only the relevant columns to Text; amounts and dates should retain appropriate data types.
  • Use the preview to diagnose encoding. If accented letters or symbols appear as question marks or odd characters, check the file origin or encoding option in the import preview. Try UTF-8 when the source system says it exported UTF-8, then confirm the preview before loading. Do not choose an encoding at random if the original system documents a specific one.
  • Keep a clean source and a working copy. The extracted CSV can be imported again if you make a mistake. Save analysis and formatting in an .xlsx workbook rather than overwriting the CSV, and keep the ZIP if it is the only original download.
  • On a Mac, extract before opening Excel. Double-clicking a ZIP in Finder normally expands it using Archive Utility. Then open Excel and use the available text/CSV import option in the Data tab if it appears in your Microsoft 365 build. Otherwise, open the extracted CSV through File > Open and inspect the result. Excel for the web also needs the CSV extracted first; upload or open the extracted file rather than expecting Excel to read the ZIP as a workbook.

Troubleshooting

The file will not open or Excel says the format is not supported. Confirm that you extracted the archive and selected the file with the .csv extension. If the extracted item still has a .zip extension, extract it again. If the file is not actually a CSV, check the archive’s instructions or ask the sender for the correct export.

Everything appears in a single column. Reimport the source file using Data > From Text/CSV. In the preview, choose the delimiter that separates the fields. A semicolon or tab may be correct even if the file is named CSV. Avoid using Find and Replace on the worksheet to insert column breaks, because that can alter values that legitimately contain the same character.

Values look garbled or symbols are wrong. Return to the import dialog and check the file origin or encoding setting. UTF-8 is common, but the correct choice depends on how the CSV was created. If the preview is still unreadable, ask the sender to confirm the export encoding or provide a UTF-8 copy instead of repeatedly changing settings after loading.

Zeros disappeared, long numbers changed, or dates are reversed. Changing a cell’s display format after import cannot reliably recover information Excel already converted. Start a new import from the extracted CSV. Use Transform Data to set codes and long identifiers to Text before loading, and check date interpretation in the preview. For dates with an ambiguous day/month order, use the source system’s regional convention rather than guessing.

The ZIP extracts but contains no obvious CSV. Look through any subfolders and check for file extensions that may be hidden. Some services put the data in a nested ZIP, which must be extracted separately. If the archive has no CSV or a file cannot be opened, it may be incomplete or damaged; download it again, or ask the sender to create a fresh archive.

Excel becomes slow or runs out of memory. Large CSVs can take time to preview and load. Close unrelated workbooks and applications, and import only the file you need. If the data is too large for a worksheet, ask the source owner for a smaller export or use an appropriate database or data-analysis tool; splitting a file manually can introduce missing or duplicated rows.

Frequently Asked Questions

Can Excel open a ZIP file directly?
Not as a normal worksheet. Extract the ZIP first, then open or import the CSV inside it. If the archive contains several files, choose the correct CSV rather than the archive itself.

Should I double-click the CSV or import it from the Data tab?
Double-clicking is convenient for a quick look at a straightforward file. Use Data > From Text/CSV when you need to verify the delimiter, encoding, dates, or text columns before Excel converts the data.

Will the CSV keep my Excel formatting and formulas?
No. CSV is a plain-text data format and generally stores one table, not workbook formatting, formulas, or multiple sheets. Save an .xlsx copy after importing if you need to work with Excel features.

What if the ZIP contains several CSV files?
Open the extracted folders and compare file names and any included notes. Import each CSV separately if you need more than one; Excel’s standard text/CSV import selects a file rather than automatically combining every CSV in the archive.

Can I open a CSV ZIP file in Excel for the web?
Extract the ZIP on your computer first. Then upload or open the extracted CSV in Excel for the web. For more control over data types and import settings, use the desktop Excel app if the web interface does not offer the options you need.

Related

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.