How to Compress Excel File to Zip (2 Suitable Ways)

Sometimes we need to store a large amount of data in Excel. As a result, the size of the Excel file becomes bigger. If we need to share this file online, it becomes difficult. Also, when we have a large number of big files, it reduces disk storage. There is a smart solution to this problem without hampering the Excel file. That is to compress the Excel file into Zip. In this article, we will show how to compress an excel file into a zip.


2 Ways to Compress Excel File to Zip

We will show 2 ways here. One is making the parent the folder zipped that contains the Excel file, and the other way is making the Excel file itself a zipped file. Use the way that suits your cause.

Here, we will show each process of how to compress an Excel file into zip in detail.

1. Zip Folder That Contains Excel File

Follow the steps below to zip folder that contains Excel file.

📌 Steps:

  • First, we save an Excel file in the desired location of File Explorer.

  • Select the Excel file and press the right button on the mouse.
  • Choose the Send to option from the Context Menu.
  • We see another list here.
  • Choose the Compressed (zipped) folder from the list.

Zip Folder That Contains Excel File

  • Look at the existing folder of File Explorer.

We can see a new zip file added here.

Read More: How to Reduce Excel File Size Without Opening (with Easy Steps)


2. Compress Excel File to ZIP by Renaming

In this section, we will zip the Excel file by rewriting the extension name.

📌 Steps:

  • Open the folder that contains your Excel file. Find the file and click once on it.

  • If don’t see any extension name with the file name, then go to the View tab of File Explorer. Then, mark the File name extensions checkbox.

Compress Excel File to ZIP By Renaming

The file extension name will appear now.

  • Now, go to Rename option from the Home tab.

Compress Excel File to ZIP By Renaming

  • Now, change the extension name to .zip. The following window will pop up. Press Yes on the pop-up.

  • Finally, you will see that your Excel file is successfully compressed as a zipped file.

To use it again as an Excel file, just change the extension name to .xlsx.

Read More: How to Compress Excel File to Smaller Size (7 Easy Methods)


Things to Remember

  • When an Excel file is compressed into a zip, the format of the Excel file will change into .zip.
  • We can also use other third party apps like: WinRAR, 7-Zip, ES File Explorer, Bandizip, WinZip, ZArchiver, TransMac, etc.

Conclusion

In this article, we described 2 methods of how to compress an Excel file into a zip in detail. I hope this will satisfy your needs. Please have a look at our website ExcelDemy and give your suggestions in the comment box.


Alok

Alok

Hello, this is Alok. I am working as an Excel & VBA Content Developer at Exceldemy. I want to provide solutions to various Excel-based problems. I completed my study at East West University major in Telecommunications Engineering. I love traveling, reading books, playing cricket.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo