Guides
Why Is My Excel File So Large? 6 Causes and How to Reduce the Size
Updated 2026-10-13
An .xlsx file is a ZIP archive full of XML. When it balloons, the cause is rarely the data itself: something invisible is taking up the space. Spend a minute finding out what, then fix that.
First, find where the size is
- Press
Ctrl + End. Excel jumps to what it considers the last used cell. If that is far beyond your real data, say row 1,048,576, formatting has spread into empty cells (cause 1).
- Look inside the file. Copy the workbook, rename the copy from
.xlsx to .zip, open it and go into the xl folder:
- one file under
worksheets is huge: usually cause 1 or 3;
styles.xml is huge: cause 2;- the
pivotCache folder is large: cause 4;
- the
media folder is large: cause 5.
1. Formatting on empty cells
Fill colors or borders applied to entire rows and columns, or formatting dragged down to the bottom of the sheet, make Excel store every one of those empty cells.
Fix it in Excel: select the first empty row below your data, press Ctrl + Shift + ↓ to extend to the last row, right-click and Delete the rows. Do the same for extra columns with Ctrl + Shift + →. Save, close, reopen and press Ctrl + End again to confirm. Some Office editions include the Inquire add-in, whose Clean Excess Cell Formatting command does this for the whole workbook.
2. Duplicate cell styles
Copying and pasting between workbooks brings the other workbook's cell styles along. Repeat that often enough and thousands of styles pile up in styles.xml; eventually Excel shows the "Too many different cell formats" error.
Fix it in Excel: custom styles are listed under Home > Cell Styles, but they can only be deleted one at a time by right-clicking, which is impractical once there are thousands.
3. Fragmented conditional formatting and data validation
Copying, inserting and dragging rows splits a single conditional formatting rule into hundreds or thousands of pieces, each stored separately. Data validation fragments the same way.
Fix it in Excel: open Home > Conditional Formatting > Manage Rules, show rules for This Worksheet, delete the duplicates and apply one rule to the whole column. Do the same for Data > Data Validation.
4. A pivot table keeps a copy of its source data
By default a pivot table saves a full copy of its source data in the file, so the cache is as big as the source table.
Fix it in Excel: right-click the pivot table, choose PivotTable Options, open the Data tab, clear Save source data with file and tick Refresh data when opening the file.
5. High-resolution images
A phone photo or full-size screenshot is stored at its original size, however small it looks on the sheet.
Fix it in Excel: select a picture, choose Picture Format > Compress Pictures, clear Apply only to this picture and pick a lower resolution. This reduces image quality, which may show when printing.
6. Change history from legacy shared workbooks
Files that used the legacy Share Workbook feature keep a change history that grows over time. Turning sharing off deletes that history; newer versions of Excel hide the command, so add it back through Customize the Ribbon first.
Should I just save as .xlsb?
The binary .xlsb format is usually smaller and faster to open, and it keeps macros. The trade-off is compatibility: some third-party tools, online previews and importers can't read it. The hidden clutter above is still there, just stored more compactly.
One step: slim it with xlszip
Cleaning all of this by hand is slow and easy to get wrong. xlszip handles the causes above in one pass:
- removes formatting from empty rows and columns, merges duplicate styles and fragmented conditional formatting and data validation;
- drops the pivot cache's copy of the source data (when the source is in the same workbook) and sets the pivot table to refresh on open;
- clears revision history and recompresses images losslessly, without lowering their resolution;
- after every step, compares values, formulas and formatting with the original cell by cell, and backs off if anything differs, so your data and formulas stay the same.
How much smaller depends on how much of this clutter the file holds; the reduction can reach 80%. Files up to 10 MB can be processed entirely in your browser without uploading.
Not sure which cause applies? Run a free check-up first: it estimates how much slimming would save and tells you whether the problem is styles, images, pivot caches or formulas.