The health check for your Excel file
Drop a workbook: within seconds, see what weighs it down, what makes it fragile and what it leaks. Every problem comes with its fix, and the fixed file is read back before it is offered.
What this tool does
- The file's weight, part by part: sheets, styles, images, pivot table caches.
- The real end of the data on each sheet, and the phantom rows beyond it.
- Duplicate styles, copied conditional formatting, broken defined names, links to other workbooks.
- Formula errors, hidden sheets, rows and columns, the author and the comments.
- The fixed file is read back and compared with the original, cell by cell, before it is offered.
What it does not do: Excel 2007 and later workbooks (.xlsx, .xlsm). An old .xls file or a workbook with an opening password is not read; a workbook whose sheets alone are protected is.
No file is uploaded. Turn off your network once this page has loaded: the tool keeps working. How to check it yourself.
Other tools
- Clean before sending : Author, comments, hidden sheets, macros: what travels with the file without showing.
- Inspect a workbook : Hidden sheets, author, comments, links: what the file carries without showing it.
- Formula audit : Errors, hard-coded values, formulas that stand out: what to check in a model.
- Slim down a workbook : Phantom rows, thousands of styles, copied formatting: the extra weight, removed.
- Formulas to values : Paste Special, Values, on the whole workbook at once: the file is frozen.