Compress Excel
Take the weight out of an Excel file with photos or logos, data untouched.
Add to favourites
Create a free account to save your favourite tools and have them on any device.
Advertisement
Make an Excel workbook smaller when it contains photos, logos or screenshots: we recompress them, and the data, formulas and formatting stay exactly the same. A word of honesty first: if your file is heavy because of the number of rows rather than images, this tool won’t shrink it. Below we explain what to do in that case.
How to compress an Excel file
- Select your Excel workbooks, .xlsx or .xls (up to 3 at a time).
- Click “Compress Excel” and wait a few seconds.
- Download the compressed workbook or, for several, the ZIP with all of them.
Advertisement
When it works and when it doesn’t
An .xlsx file is already a compressed package: the data is stored compactly, and compressing it again changes next to nothing (we tested a workbook with 60,000 rows and the result weighs the same). Where there is room is in the images: product sheets with photos, quotes with a high-resolution logo, inventories with screenshots. That’s what we reduce:
- Photos larger than 2,560 pixels on the longer side are scaled down to that size and saved as JPG at quality 80, without hidden data such as GPS location.
- PNG images are scaled down if they are larger than that, losslessly.
- Cells, formulas, pivot tables, charts and conditional formatting are not touched.
If the workbook doesn’t get smaller, you get the original back.
Advertisement
If your Excel file is heavy because of its data
These are the usual causes and how to fix them in Excel itself:
- Save it in binary format: in File › Save As, pick the “Excel Binary Workbook (*.xlsb)” type. It keeps formulas, formatting and macros, and large workbooks are often considerably smaller. Bear in mind that some programs other than Excel can’t open it.
- Pivot tables: each one keeps a copy of its source data. In PivotTable Options › Data, untick “Save source data with file”; the data is rebuilt when you refresh the table.
- Formatting applied to whole rows or columns: if the sheet was ever formatted down to row one million, Excel stores all those cells. Delete the empty rows and columns you don’t need and save again.
Older .xls files
Excel 97-2003 workbooks (.xls) are first saved as .xlsx with LibreOffice, which usually makes them smaller already. Check your macros: the .xlsx format doesn’t keep them.
Limitations
- Up to 3 workbooks at a time, 100 MB per workbook and 100 MB in total.
- We can’t open workbooks with a password to open.
- If you need to share the workbook for reading only, try Excel to PDF.
Frequently asked questions
How do I reduce the size of an Excel file?
If it has images, upload it here and click “Compress Excel”: we shrink photos and screenshots without touching the data. If it’s heavy because of the data, save it in Excel as a binary workbook (.xlsb) and remove formatted empty rows and the source data saved with pivot tables.
Are my data or formulas changed?
No. We only swap the images for lighter versions and repackage the file. Cells, formulas, charts and pivot tables stay exactly the same.
Why is my Excel file the same size after compressing it?
Because its size comes from the data, not from images. An .xlsx already stores the data compressed, so compressing it again saves nothing. In that case, save it as .xlsb or check the pivot tables and the formatting of empty rows.
What is an .xlsb file?
It’s Excel’s binary workbook: it stores the same as an .xlsx (data, formulas, formatting and macros) in a format that is usually smaller and opens faster for large workbooks. Excel and LibreOffice open it, but not every app does.
Advertisement
Convert your Excel files too
Advertisement
Advertisement