Clean an Excel file before sending it
A workbook carries its author's name, the path of the folder it was saved in, its comments and its hidden sheets. See what it holds, choose what goes, and send a clean file.
What this tool does
- The author, last editor, company, save-folder path and custom properties.
- Comments and notes, with their authors' names.
- Hidden sheets, deleted when nothing else depends on them; formulas that read them become values.
- Hidden rows and columns, unhidden so you can see what you are sending.
- Macros, removed: the workbook becomes an ordinary .xlsx file.
What it does not do: A hidden sheet that feeds a drop-down list, a chart or a pivot table is kept, and the screen says why. Hidden rows and columns are unhidden, not deleted: deleting them would shift the workbook's references.
No file is uploaded. Turn off your network once this page has loaded: the tool keeps working. How to check it yourself.
Other tools
- Workbook health check : Size, phantom rows, styles, links, errors, hidden content: all of it, with one-click fixes.
- 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.