B

Bawitools

Excel Compressor

• 100% local, no file uploads

Upload your Excel

Drag and drop or click to select

📄 📊 .xlsx · max. 500 MB
WHAT IS OPTIMIZEDRecompress the ZIP container without modifying data or formulas.

COMPRESSION MODE

Safe

5–25%
Only recompress the ZIP. Preserves absolutely everything: videos, macros, transitions, animations.

Balanced

25–55%
Recompress ZIP + optimize images to 85% quality.

Maximum

45–75%
Images at 70% quality with reduced resolution.

RESULT

The compressed file will appear here

Select or drag a file to start
Excel compression guide

Compressing Excel: why a spreadsheet ends up so heavy

Phantom used ranges, formatting applied to whole columns, and images: the three real causes of an .xlsx file's size

An .xlsx file is, just like a .docx, a ZIP with XML inside: one file per sheet, plus a shared string table, the styles and any embedded element. Numeric data is extraordinarily compact — thousands of rows of numbers take up very little. When a spreadsheet weighs tens of megabytes, it is almost never because of the data.

Cause 1: the phantom used range

This is the most frequent cause and the most baffling. Excel remembers the last cell ever touched in each sheet, even if it is empty today. If at some point someone pasted data down to row 100,000, applied a fill colour to an enormous range, or deleted content without removing the rows, Excel still treats that range as part of the sheet and stores its formatting information.
The symptom is unmistakable: press Ctrl + End and the cursor jumps to a distant, empty cell far below or to the right of where your real data ends. A file with 200 rows of data can take several megabytes for that reason alone.

Cause 2: formatting applied to whole columns or rows

Clicking a column header and applying formatting is convenient, but it tells Excel that over a million cells carry that style. Multiplied across several columns and several different formats — borders, colours, number formats, conditional formatting — the style table grows enormously.
Conditional formatting is especially costly when applied to open-ended ranges, because on top of being stored it has to be evaluated: it is common for the sheet not only to weigh more but to scroll sluggishly.

Cause 3: images, charts and embedded objects

ElementTypical weightRoom to reduce
Inserted images and logosHigh: stored at original resolutionVery high
Native Excel chartsLow: they are vector-basedNone, and none needed
Embedded objects from other applicationsCan be enormousHigh, if they are not needed
Numeric data and formulasVery lowNone
Styles and conditional formattingCan balloonHigh, by bounding the ranges
Just as in Word, inserted images keep their original resolution even when they appear small on the sheet. A company logo repeated across several sheets, stored at camera size, can on its own be the bulk of the file.

Compressing your spreadsheet step by step

Check the used range

Open the file and press Ctrl + End. If the cursor jumps far from your data, clean that phantom range in Excel first: it is usually the biggest contributor to the size.

Upload your .xlsx file

Drag it onto the drop zone or click to select it. It is processed inside your browser.

Pick the compression level

It affects embedded images; the data stays intact.

Open and verify

Check that sheets, formulas and charts are as you expected before discarding the original.

No. Compression acts on images and embedded elements, not on cell content. Values, formulas, cross-sheet references and pivot tables stay intact and keep calculating as before.

Most likely it drags a phantom used range: Excel still counts as part of the sheet some cells that were touched at some point and are empty today. Press Ctrl + End; if the cursor jumps far away, that is your problem.

Select the first genuinely empty row after your data, extend the selection to the end with Ctrl + Shift + End, and delete those entire rows — clearing the contents is not enough. Repeat with the columns, then save and close the file so Excel recalculates the range.

Native Excel charts do not: they are stored as vector descriptions and take very little. What does weigh are inserted images and embedded objects from other applications.

Yes. The result is a standard .xlsx, perfectly editable in Excel, Google Sheets or LibreOffice Calc.

Yes: the file is never uploaded to any server. All processing happens in your browser, so a sheet with customer records or financial information never leaves your machine.

Free

No sign-up

100% local compression

Your spreadsheets are never uploaded to a server

Comments

Log in to leave a comment