Compress Excel Files for Sharing: Step-by-Step Guide

Most people treat file compression as the last step before hitting send. That's the wrong way to think about it. The real problem usually isn't the file you're about to share — it's every decision you made while building it. By the time you're staring down a 47 MB workbook at 11 PM the night before a presentation, the damage is already done. This guide walks you through how to compress an Excel file the right way: clean it from the inside first, then choose the right format, then zip it if you still need to. In that order.

The concrete goal is getting under 25 MB: Gmail's attachment ceiling, and a threshold both Outlook and Teams respect in most configurations. If your file can't clear that bar, your recipient gets a bounce error or a frantic "can you send this another way?" message. Neither is a great look. For a broader look at keeping your workbooks organized before they reach this point, the Excel file management and sharing guide is worth reading first.

---

Why Excel Files Balloon Before You Even Add Much Data

A few culprits show up repeatedly. Embedded images pasted at full resolution and never compressed. Pivot table cache storing a full copy of the source data inside the file. Conditional formatting rules applied to entire columns rather than just the cells that need them. And the classic: the used range extending to row 1,048,576 because someone hit the spacebar in a cell they thought was empty three years ago.

The version history problem is real too. A file called Final_v3_REVISED_ACTUALLY_FINAL.xlsx that's been emailed back and forth has accumulated embedded objects, ghost formatting, and metadata that nobody put there intentionally. That's not a joke filename. I've seen it in the wild, more than once.

---

Step 1: Compress Images and Clear the Dead Weight Inside Your Workbook

Before you touch the file format or zip anything, go after the weight already inside the workbook. Two actions do the most work: compressing embedded images and clearing the pivot table cache. Neither one touches your formulas, your formatting, or your visible data.

Compress Images Directly Inside Excel

Click any image in the workbook. The Picture Format tab appears in the ribbon. Select Compress Pictures. In the dialog, uncheck "Apply only to this picture" so it runs on every image at once. Set the resolution to Email (96 ppi). Click OK.

That single step has taken files I work with from 38 MB to under 12 MB. Images pasted from PowerPoint decks or screenshots taken at 4K resolution have no business being embedded at full size in a dashboard that'll be read on a 1080p monitor. The visual difference at 96 ppi is negligible. The file size difference is not.

Conditional formatting applied to full columns is one of the quieter contributors to file bloat. If you've applied color scales or icon sets to entire columns just to preview the data, strip them before you share. A color is not a data point.

Delete Unused Cells and Clear Pivot Table Cache

1. Press Ctrl + End to jump to what Excel thinks is the last used cell. If it lands somewhere absurd (row 50,000 when your data ends at row 300), select everything below your actual data, right-click, and choose Delete. Save the file. That bloated used range is one of the more common reasons a workbook feels too large to email despite having minimal data in it.
2. For pivot tables: right-click the pivot, go to PivotTable Options, then the Data tab. Uncheck "Save source data with file." This stops Excel from embedding a full copy of your data inside the cache. You'll need to refresh the pivot when the file is opened, but you're no longer sending a hidden second dataset along for the ride.

---

Step 2: Save Your Excel File in a Smaller Format Before You Share It

Once you've cleaned the inside of the workbook, the format you save in determines how much further the file size can drop. This is where most compression guides start, which is why they miss the 60% of the work you've already done.

When to Use .xlsb (Binary Workbook Format)

Go to File → Save As → Browse, then change the file type dropdown to Excel Binary Workbook (.xlsb).

The size reduction is real. A workbook sitting at 22 MB as an .xlsx will often come in around 12–14 MB as an .xlsb, sometimes smaller, depending on what's in it. The binary format compresses the internal structure more efficiently than the XML-based .xlsx format.

.xlsb is not a universal format. Your recipient needs a version of Excel that supports it, which rules out Google Sheets and older non-Microsoft spreadsheet tools. Power Query also can't read data from .xlsb files as a source. And because the binary format doesn't surface whether a file contains a macro, some IT security filters will flag or block it. Know your recipient before you send it.

For a full breakdown of when each format makes sense, the Excel file formats guide covers the tradeoffs clearly.

When .xlsx Is Still the Right Call

If you're sending to a client, an external partner, or anyone whose setup you don't control, stick with .xlsx. Compatibility matters more than the extra megabytes. The steps in Step 1 will have already brought the size down enough in most cases.

---

Step 3: Zip the File When the Size Still Isn't Small Enough

After compressing images and saving in the right format, if the file is still pushing the limit, zipping it is your next move. Right-click the file in Windows File Explorer, select Compress to ZIP file (or Send to → Compressed (zipped) folder on older Windows builds), and attach the ZIP instead of the raw .xlsx.

ZIP compression on an .xlsx file typically gets you another 10–15% reduction: not dramatic, but enough to clear a limit. OneDrive and SharePoint both accept ZIP files, and their upload size limits are generous enough that zipping is rarely necessary for cloud sharing. It's mostly useful for email.

Your recipient has to extract the file before they can edit it. That sounds minor. It isn't, if they save the extracted version in a random folder and you end up with three copies floating around with no clear version history. If version control matters (and for anything that'll be edited and returned, it does), consider a shared OneDrive or SharePoint link instead of an attachment.

---

Common Mistakes When Compressing an Excel File to Send

The biggest one, and the one most guides skip entirely: uploading a sensitive workbook to a free online compression tool. Those tools aren't inherently malicious, but you're sending your data to a third-party server you don't control. If the file contains payroll data, client financials, or anything with personal identifiers (and many of the files I handle as a Senior Data Analyst do), that's a real exposure. The steps above handle compression entirely inside Excel and Windows. You don't need an online tool.

The second mistake is sending an .xlsb file without warning the recipient. I've done this. The email comes back twenty minutes later: "I can't open this." Check first.

The third is skipping metadata. Before any file leaves your machine, go to File → Info → Check for Issues → Inspect Document. Excel stores author names, revision history, and comments in the file properties. Stripping that before sharing is both a privacy step and a minor file size step, but mostly it's professional hygiene. It's the pre-send check that almost nobody includes in a compression workflow, and it should be the last thing you do before hitting send.

---