Free ToolNo signup · No upload · Instant

Reduce Excel File Size

Upload a large Excel file and reduce its size instantly. Choose between compress-only (preserves all formatting) or strip-formatting (maximum reduction). Your file never leaves your browser.

Drop your Excel file here

or click to browse — .xlsx, .xls, .xlsm, .xlsb

100% private — your file never leaves your browser

How to Reduce Excel File Size

Step 1

Upload your file

Drag and drop your .xlsx or .xlsm file. The tool shows its current size before any changes are made.

Step 2

Choose reduction mode

Select "Compress only" to shrink the file without any data changes, or "Strip formatting" to remove all colours, fonts, and borders for maximum reduction.

Step 3

Download the smaller file

The tool shows the new file size and the percentage saved. Click download to save the reduced file.

Why Excel Files Get Large

Excel files can grow unexpectedly large for several reasons — most of which have nothing to do with the actual amount of data:

  • Formatting applied to entire columns or rows: Selecting an entire column and applying a colour or font creates formatting entries for all 1,048,576 cells in that column, even if only 100 have data. This alone can add several megabytes to the file.
  • Conditional formatting on large ranges: Complex conditional formatting rules across large ranges add significant overhead and can slow calculation as well as increasing file size.
  • Hidden sheets with large datasets: Sheets you cannot see can still contain thousands of rows. Use the Spreadsheet Auditor to reveal hidden sheets before reducing.
  • Embedded images and charts: Images are stored uncompressed inside the .xlsx ZIP container. Each chart also stores its underlying data in a separate XML file.
  • Macro code (.xlsm): VBA macro code stored in vbaProject.bin can add significant size. If you no longer need the macros, use the Excel Macro Remover to strip them and convert to .xlsx.
  • Poor default compression: Some Excel versions save .xlsx files with minimal ZIP compression. Re-saving with maximum compression can reduce size by 30–50% instantly.

Microsoft documents the official Excel file size reduction techniques including clearing excess formatting and removing unused styles.

Frequently Asked Questions

How much can it reduce my file size?

It depends on how the original file was saved. Files saved by Excel with default settings typically compress 20–50% with the compress-only option. Files with heavy formatting (many colours, conditional formatting, custom fonts) can reduce 40–80% with the strip-formatting option.

Will my data be changed?

No data is changed. The compress-only mode re-saves the exact same workbook with better ZIP compression. The strip-formatting mode removes visual formatting (colours, fonts, borders) but keeps every value, formula, and sheet.

Are my files uploaded to a server?

No. Everything runs in your browser using JavaScript. Your file never leaves your device.

Why is my Excel file so large?

Common causes: excessive formatting applied across entire columns or rows, hidden sheets with large data, conditional formatting on large ranges, embedded images and charts, and poor default compression. Some Excel versions save .xlsx files with minimal ZIP compression — re-saving with maximum compression can reduce the size by 30–50% with no other changes.

Will formulas still work after reducing?

In compress-only mode, yes — nothing changes except the compression level. In strip-formatting mode, all cell values and formula text are preserved, but conditional formatting rules and cell colour/font formatting are removed.

How Much Will It Actually Reduce? Typical Benchmarks

File type / situationCompress onlyStrip formatting
Plain data, no formatting15–35% reduction15–35% (no formatting to strip)
Report with colour coding and fonts25–50% reduction40–75% reduction
File with formatting on entire columns30–55% reduction60–85% reduction
File saved by an older Excel version30–60% reduction (re-compression is biggest win)50–80% reduction
File with embedded images or charts5–15% reduction (images limit gains)5–15% reduction (images are not removed)

Results vary by file. The tool shows the exact before/after sizes so you know the real saving before committing to the download.

Email and Cloud Attachment Size Limits

Knowing the limits helps you decide how much reduction you actually need:

  • Microsoft Outlook (Exchange): Default send limit is 20–25 MB depending on server configuration. Many corporate IT policies set this lower (10 MB). Files above the limit are blocked and returned with a bounce message.
  • Gmail: 25 MB send limit per message. Attachments above 25 MB are automatically converted to Google Drive links — the recipient gets a link, not the file.
  • Microsoft Teams: 250 MB file upload limit (per file). Team channel file storage uses SharePoint capacity.
  • Slack: Free plan: 5 GB total workspace storage. Pro and above: 10 GB per member, with single-file upload limits up to 1 GB.
  • WhatsApp: 2 GB per file (but not commonly used for spreadsheet sharing).

If your Excel file is above 15 MB, it is likely to have delivery issues with standard corporate email. Use Compress only first — if that doesn't bring it under the threshold, try Strip formatting, or remove images and unnecessary sheets manually in Excel first.

Related Excel Tools