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 is not read; a password-protected workbook is, once its password is typed, and a workbook whose sheets alone are protected is read directly.
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.
- Dependency map : Which sheet reads which, which workbooks are called: the workbook's diagram.
- Understand a Power Query query : A query's M code, put into sentences: its source, its steps, its pitfalls.