How to Remove Metadata From an Excel File

Sharing & Tools · Updated June 2026

Every Excel file carries hidden details: who created it, when, comments, revision notes, and sometimes more than you want a client or counterparty to see. Before a workbook leaves your organization, it is worth clearing that metadata so the file says only what you mean it to.

What metadata Excel stores

A workbook keeps document properties such as the author and last-modified-by names, a title and company, any comments or notes, hidden sheets and rows, and trace data from earlier edits. None of it is visible in the grid, but it travels with the file and is easy for a recipient to read.

On Windows, anyone can right-click the file in Explorer, open Properties, and read the Details tab without even launching Excel. In a finance context that can quietly reveal who really built a model, how recently it changed, or notes you left for yourself that were never meant for an outside reader.

Use the Document Inspector

Excel's built-in Document Inspector finds and removes most hidden content in one place.

Save a copy of the workbook first, because the inspector's removals cannot be undone.
Go to File > Info > Check for Issues > Inspect Document.
Leave the relevant boxes checked, especially Document Properties and Personal Information, and click Inspect.
For each category the inspector flags, click Remove All.
Click Close, then save the cleaned copy.

Always work on a copy

The Document Inspector strips content permanently, and breaking that out of your live file matters. Comments and properties you remove are gone, so clean a duplicate and keep your original with its full history. Naming the copy clearly, something like model_to_send.xlsx, keeps the two versions from getting mixed up.

Clear metadata as part of one send-ready pass

Opening the inspector and clicking through its categories each time is a chore that is easy to forget under deadline. ModelMint's Prepare to Share clears document metadata automatically as one step in its pre-send cleanup, alongside hiding gridlines, resetting zoom, and checking external links, and it can run on a copy so your original keeps everything.

Do it in one click

Prepare to Share

One click hides gridlines, resets zoom to 100 percent, checks external links, and clears document metadata, optionally on a copy so your original stays intact.

Get ModelMint See how it works

FAQ

Can I undo the Document Inspector after it removes metadata?

No. The inspector's Remove All cannot be undone, and saving locks it in. Always run it on a copy of the workbook so your original keeps its comments, properties, and history.

Does removing metadata delete my data or formulas?

No. Clearing document properties and personal information removes hidden details like author names and comments, not the values, formulas, or formatting in your cells. Hidden rows, columns, or sheets are a separate inspector category you choose whether to remove.