Slim down a heavy Excel file
A workbook grows without any new data: formatting applied to whole columns, thousands of styles copied from file to file, conditional formatting rules duplicated on every paste. We remove that weight, and nothing else.
What this tool does
- Phantom rows and columns beyond the real end of the data.
- Duplicate cell formats and unused named styles, the cause of the "Too many different cell formats" message.
- Duplicated conditional formatting rules, merged back into one.
- Pivot table data copies, images nothing displays any more, broken defined names.
- The parts we do not touch come out byte for byte: charts, images and macros stay as they are.
What it does not do: Images are not recompressed: an 8 MB photo pasted into a sheet keeps its weight. The health check shows it, so you can replace it.
No file is uploaded. Turn off your network once this page has loaded: the tool keeps working. How to check it yourself.
Other tools
- Remove external links : The "this workbook contains links" warning goes away: formulas become values.
- Formulas to values : Paste Special, Values, on the whole workbook at once: the file is frozen.
- Unmerge cells : Merges removed and the value copied everywhere: you can finally sort and filter.
- Recover a damaged file : The repaired workbook when possible, and always the data that could be read.
- Workbook health check : Size, phantom rows, styles, links, errors, hidden content: all of it, with one-click fixes.