To put an Excel workbook in a ZIP file on Windows, open File Explorer, right-click the workbook, and choose Send to > Compressed (zipped) folder; on a Mac, use Finder’s File > Compress command. This creates a ZIP archive containing the workbook—it does not change the workbook into a different Excel format, and Excel itself has no general Save As ZIP command.
What it means to convert an Excel file to ZIP
People use “convert Excel to ZIP” to mean a few different things. Most often, they want to package a workbook in a .zip archive so it is easier to upload, send, or keep together with related files. The Excel file remains an .xlsx, .xlsm, or other workbook inside the archive. A recipient extracts the ZIP first, then opens the workbook in Excel.
There is an important technical wrinkle: the modern .xlsx format is already a ZIP-based package. It contains separate parts, such as XML files describing worksheets and workbook settings, and may include images or other content. An .xlsm workbook uses a similar package structure and can include a VBA project. So zipping an .xlsx usually adds an outer archive around a file that already uses compression. It can still be useful for packaging, but it may not make the workbook much smaller.
Older .xls workbooks and .xlsb binary workbooks are not the same kind of ZIP package as .xlsx. You can still put them inside a ZIP archive, but their internal file formats differ. In every case, creating a ZIP is packaging or compression, not converting workbook data to a new spreadsheet format.
Create a ZIP file in Windows
In Microsoft 365 on Windows, use File Explorer rather than an Excel ribbon command. The built-in Windows ZIP feature is sufficient for ordinary archives and does not require an extra app.
- Save the workbook in Excel and close it if you can. Closing helps ensure the archive contains the latest saved version and avoids copying a file while Excel is still writing changes.
- Open File Explorer and find the workbook. To include several items, select them together. You can also select a folder if you want the ZIP to preserve that folder and its contents.
- Right-click the selection and choose Send to > Compressed (zipped) folder. In some Windows 11 context menus, you may need to select Show more options to see Send to.
- Type a name for the new ZIP file and press Enter. Keep the .zip extension. The archive is normally created alongside the selected file or folder.
- Double-click the ZIP to inspect its contents, or right-click it and choose Extract All when you want to unpack it.
Windows 11 may also show a Compress to ZIP file option in its newer context menu. That creates the same general type of archive. Menu wording can vary with Windows versions and updates, but the File Explorer Send to route remains a familiar option.
Create a ZIP file on a Mac or from Excel for the web
On macOS, save the workbook, locate it in Finder, then control-click or right-click it and choose Compress. Finder creates a .zip file in the same location, generally with a name based on the selected item. If you select multiple items, Finder can put them together in one archive. Excel for Mac does not use the Windows File Explorer steps.
Excel for the web also does not provide a command to package a workbook as a ZIP. Download or sync the workbook to a device first, then use that device’s file manager to create the archive. For example, download the file and use File Explorer on Windows or Finder on a Mac. If the workbook is stored in OneDrive or SharePoint, make sure you are zipping the current downloaded or synced copy rather than an older local version.
Choose what to put in the archive
A ZIP can contain one workbook, multiple workbooks, or a workbook plus supporting files. Choose the contents based on what the recipient needs, not just on which files happen to be nearby.
- One workbook: Select the .xlsx, .xlsm, or other workbook directly. This is usually the simplest option when a website or recipient specifically asks for a ZIP.
- A workbook and its supporting files: Put them in a clearly named folder first, then zip the folder. This keeps linked documents, instructions, or source data together and makes the archive easier to understand.
- Several workbooks: Select only the intended files and create one archive. Check that the filenames are distinct enough to identify each workbook after extraction.
- A folder that contains extra material: Review it before zipping. An archive can accidentally include drafts, temporary files, or confidential documents that were not meant to be shared.
Some upload forms require the workbook to be at the top level of the ZIP, while others accept a folder inside it. Check the destination’s instructions. A correctly made archive can still be rejected if it has an unexpected folder structure or contains extra files.
Will a ZIP make an Excel workbook smaller?
Sometimes, but do not assume it will. Since .xlsx and .xlsm files already use ZIP-style compression internally, wrapping one in another ZIP often produces only a small reduction, no meaningful change, or occasionally a slightly larger file because the outer archive also has overhead. Results depend on what the workbook contains.
Text-heavy data may compress differently from photographs, and pictures may already be stored in compressed image formats. A workbook with many images or embedded objects might not shrink much. To find out, compare the original workbook’s size with the ZIP’s size in File Explorer or Finder. The ZIP can still be worthwhile even if its size barely changes: it can package multiple files together and may satisfy a service that only accepts .zip uploads.
If the main goal is a smaller workbook rather than a ZIP, consider whether the workbook contains unnecessarily large images, duplicate data, or unused content. Excel’s picture compression options can reduce image size, but the result may lower image quality. Make a copy before changing workbook content, and verify that formulas, links, macros, and important visuals still work.
ZIP archive versus changing the Excel format
Use Excel’s Save As or Save a Copy options when you actually need to change a workbook’s format—for example, saving a copy as .xlsx, .xlsm, .xlsb, or .csv. Those formats have different capabilities. A CSV stores plain tabular text for a sheet and does not preserve workbook features such as formatting, formulas as formulas, or multiple worksheets in the same way a native workbook does. A ZIP, by contrast, can contain the original workbook without changing its format.
Renaming a file extension is not a reliable conversion method. Changing a filename from .xlsx to .zip may let a knowledgeable user inspect the package structure, because .xlsx is ZIP-based, but it does not turn the workbook into a different spreadsheet format. Renaming it back incorrectly, editing or deleting internal package parts, or extracting and recompressing the contents carelessly can make the workbook fail to open. If your goal is simply to share the file, create a separate ZIP through the operating system instead of renaming the workbook.
Common problems and how to avoid them
- The recipient cannot open the workbook: They may be trying to open the .zip directly in Excel. Ask them to extract the archive first, then open the workbook inside it.
- The ZIP appears to contain an old version: Save the workbook before creating the archive. If it is stored in a cloud folder, check that syncing has completed and that you selected the current copy.
- The archive is not smaller: That is normal for many .xlsx files because they already use compression. ZIP the file to meet packaging or upload needs, not as a guaranteed way to reduce its size.
- The upload service rejects the archive: Check its allowed file types, maximum upload size, and required folder layout. Some services want a workbook itself, not a ZIP, even if the file is smaller.
- The workbook contains macros: Keep an .xlsm workbook as .xlsm inside the ZIP if its VBA macros must be retained. Saving it as .xlsx removes macro content; zipping an .xlsm does not.
- The ZIP name looks like the workbook name: Confirm the extension at the end is .zip, not .xlsx.zip or a renamed workbook. File extensions may be hidden in File Explorer, so check the file’s properties if you are unsure.
Safety and sharing considerations
A ZIP archive is a container, not a security guarantee. Windows’ built-in compressed-folder feature and Finder’s Compress command do not by themselves make a workbook private or password-protected. If the contents are sensitive, use an approved secure file-sharing method or an archive tool and process that your organization permits. If you encrypt an archive, send its password through a separate channel rather than in the same message as the file.
Before sharing, inspect the archive contents and consider what the workbook reveals. A spreadsheet can contain hidden worksheets, comments, personal information, external links, or macros even when those details are not visible in the current sheet. Review the workbook itself before distributing it. Also treat ZIP files from unknown sources cautiously: extracting an archive does not make its contents safe, and a workbook with macros should only be enabled when its source is trusted.
Frequently Asked Questions
Can Excel save a workbook directly as a ZIP file?
No. Excel saves workbooks in spreadsheet formats such as .xlsx and .xlsm, but it does not offer a general Save As ZIP format. Save the workbook normally, then use File Explorer, Finder, or another trusted archive tool to create a ZIP containing it.
Can I just change .xlsx to .zip?
An .xlsx file is internally a ZIP-based package, so changing a copy’s extension can expose its package contents to compatible archive software. That is mainly useful for inspection, not for normal sharing or format conversion. Create a separate ZIP archive instead, and do not edit internal files unless you understand the package structure.
Does zipping an Excel file remove formulas or formatting?
Creating an archive does not alter the workbook inside it. Once extracted, the workbook should retain its saved content, including formulas and formatting. Problems are more likely if the workbook itself was edited, converted to another format, or damaged during handling.
Can I put an Excel macro workbook in a ZIP?
Yes. Put the .xlsm file in the archive as it is. Extracting the ZIP leaves an .xlsm workbook that can contain its macros. Do not save it as .xlsx if you need to preserve VBA, because .xlsx does not store VBA macros.
How do I open an Excel file inside a ZIP?
First extract the ZIP, usually with Extract All on Windows or by double-clicking it in Finder. Then open the resulting .xlsx or .xlsm file in Excel. Some systems let you preview archive contents, but extracting first is the clearest way to work with the workbook.
Which method should you use?
For a routine Windows task, use File Explorer’s Compressed (zipped) folder command; on a Mac, use Finder’s Compress command. Those approaches preserve the workbook as a workbook and produce a ZIP that is easy to share or upload. Use Excel’s save-format options only when the recipient needs a different spreadsheet format, and use an approved encryption method when confidentiality—not just packaging—is the requirement. Checking the archive’s contents and testing that the workbook opens after extraction are simple final checks before you send it.
Related
- Can You Password Protect an Excel File? How It Works
- Can You Merge Excel Spreadsheets? Methods That Work
- Can You Merge Two Excel Spreadsheets? Methods Explained
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Text to Columns: Split Cell Text at Line BreaksTo split cell text wherever it contains an in-cell return, use Data > Text to Columns, choose Delimited,…
- PowerPoint Text Transitions: Add and Control AnimationsTo make text appear, move, or fade in PowerPoint, select its text box and choose an effect from…
- Can You Play Split Fiction on Mac?No, Split Fiction does not have a native macOS version, so you cannot install and run it directly…
- Excel Next Sheet Shortcut for Windows, Mac and WebIn Excel for Microsoft 365 on Windows, press Ctrl+Page Down to move to the next worksheet in the…
- How to Properly Archive Emails in Microsoft OutlookTo archive email in Outlook, select the message and choose Archive on the toolbar; Outlook moves it to…
- Blocking a Sender in Outlook: Steps and What to KnowTo block a sender in Outlook, select one of their messages and choose Block or Block Sender from…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.