How to Reduce Excel File Size (Without Losing Data)

How to Compress an Excel File Online (4 Steps)

1. Open the free Excel Compressor and drop in one or more .xlsx or .xlsm workbooks — batch is fine. Everything runs locally; the file is never uploaded.
2. The tool scans the workbook, removes the calcChain cache and printer settings, and recompresses embedded images automatically.
3. Check the size report — before and after, with the percentage saved.
4. Download the compressed file.

Excel rebuilds the calcChain on the next open — deleting it costs nothing. Printer settings are per-sheet leftovers from whoever last hit Ctrl+P. Neither is “your data”, which is why removing them cannot lose anything you would miss.

• Compress Excel FilesThe free online tool used in the steps above.

Why Excel Files Get So Large

An .xlsx is a ZIP archive of XML parts, and the parts that bloat it are rarely the parts holding your data:

• calcChain.xml — a cached list of formula calculation order, rebuilt automatically by Excel on the next open. Pure dead weight in transit.
• Printer settings — every sheet can store its own print configuration, which is pointless when the file is shared digitally.
• Uncompressed images — pictures are embedded at their original resolution even when displayed cell-sized; a phone photo can outweigh a million rows of data.
• Redundant styles — years of copy-pasting duplicate cell formats into the stylesheet XML.
• Real data growth — the only kind of size that compression cannot touch, because the bytes are the payload.

Manual Slim-Down Inside Excel

• Save as .xlsx (not .xls) — the modern format compresses structurally; .xls does not.
• Compress pictures: select any image → Picture Format → Compress Pictures → untick “Apply only to this picture” → pick a resolution (150 ppi is fine for on-screen).
• Delete unused sheets, and clear “empty-looking” ranges that actually carry formatting far beyond the data (Ctrl+End shows where Excel thinks the used range ends).
• Remove what the file no longer needs: VBA macros, comments, and tracked metadata all add parts to the archive.
• As a last resort for report-style data: convert formulas to values, or export a CSV — a fraction of the size, at the cost of everything but raw values.

Two manual “tips” to avoid: deleting rows/columns you do need (obviously) and zipping the .xlsx for sharing — that shrinks the email attachment, not the file, and the bloat comes straight back on unzip.

What the Compressor Does and Does Not Touch

If the size report shows images dominating, the recompression does the heavy lifting. If the workbook is still heavy after compression, the remaining weight is real data or macros — and the macro remover is the honest next step for .xlsm files whose VBA nobody uses anymore. Sharing a file outside the company is also the moment to think about what else it carries: author names, file paths, and comment threads.

• Remove Macros from ExcelTurn a macro-heavy .xlsm into a lean, safe .xlsx.
• Remove Metadata from ExcelStrip author info and file history before sharing.