Documents & PDFs

Remove Metadata from Excel: Author Names and Hidden Data

Remove author metadata from Excel, inspect hidden workbook content, and check formulas before sharing an XLSX file with clients or colleagues.

2026-09-19 · 4 min read

Start with the sharing copy

To remove metadata from Excel, save a separate copy and use Excel's Document Inspector to review personal information and hidden content. Then inspect the final file and check that the workbook still works as intended.

An author name and a confidential number in a cell are different problems. Removing document properties does not make the contents of a spreadsheet safe to disclose. Decide what the recipient needs before choosing what to remove.

This guide focuses on Excel workbooks. For the broader Office workflow, see removing metadata from Word, Excel, and PowerPoint.

Use Document Inspector in desktop Excel

Microsoft recommends working on a copy because removed information may not be recoverable. In supported desktop versions of Excel:

1. Save a copy with a distinct filename.
2. Go to File, then Info.
3. Choose Check for Issues, then Inspect Document.
4. Select the categories to inspect and run the inspection.
5. Review the findings. Remove the categories you intend to exclude, including Document Properties and Personal Information where appropriate.
6. Reinspect and save the sharing copy.

Do not remove hidden rows, columns, or worksheets without reviewing them: formulas may depend on their contents. The inspector also has limits and cannot remove everything it finds. These instructions are for desktop Excel; menus and availability differ across versions and platforms. Microsoft's Document Inspector instructions

Review workbook content separately from metadata

Consider a supplier quotation workbook. You may want to remove the preparer's name, but the more important question is whether the recipient should receive your cost calculations at all. A file can have clean author properties and still contain information you meant to keep internal.

Before sending, make a simple sharing decision for each part of the workbook:

• Needed: The recipient needs this information to understand or use the spreadsheet.
• Not needed: Remove it from the sharing copy after checking dependencies.
• Uncertain: Ask the workbook owner before distributing it.

Check the sheet tabs, comments, headers, and visible cells as part of that review. Search for a few distinctive internal names or project terms. A search is a useful check, but it is not proof that every sensitive item has been found.

Microsoft also documents hidden names that Document Inspector detects but cannot remove for you. A finding needs review even when there is no automatic cleanup button. Microsoft: Hidden names found

Verify the workbook after cleanup

Choose several representative checks before making changes. For example, record a headline total, a subtotal, and the result of an important calculation. After cleaning, reopen the sharing copy and compare them.

If a number changes unexpectedly, return to the original and investigate. Avoid sending a workbook simply because its privacy checks look cleaner.

Review formulas as well as displayed values when appropriate. Excel's formula bar can show the formula behind a selected cell, while worksheet cells normally show the results. Microsoft: Show and print formulas

These checks serve different purposes: metadata inspection addresses embedded file information; workbook review addresses what the recipient can learn from the spreadsheet; calculation checks help catch accidental damage.

Inspect and clean an XLSX file online

For supported metadata fields in an XLSX sharing copy, you can also use MetaClean Pro:

1. Upload the XLSX file and review the detected metadata.
2. Sign in or create an account to clean it.
3. Review the cleaning report and any remaining fields.
4. Download the result, reopen it in Excel, and repeat your content and calculation checks.

MetaClean Pro's supported spreadsheet format is XLSX. Do not assume the same workflow supports legacy XLS files or macro-enabled XLSM workbooks. Also, do not treat metadata cleanup as a replacement for Excel's workbook-content review.

MetaClean Pro offers free metadata inspection before you create an account. An account includes one lifetime free successfully cleaned file with download, with no card required. Failed cleaning does not use that trial, and you can download the same retained result again. For further cleaning, Pro costs $14.99 per year with automatic annual renewal until canceled. Free files can be up to 10MB; Pro supports up to 50MB and batches of up to 20 files. See current pricing.

This is an upload-based service. Files become eligible for deletion after 24 hours, with removal performed by an hourly cleanup job. Check your organization's sharing rules and the privacy policy before uploading a work file.

Questions before you send

Is removing the author enough?

Only if the author property is the only information you need to remove. Review the workbook's actual contents separately.

Can I use the online cleaner for confidential spreadsheets?

Use it only when you are authorized to upload the file and its handling meets your requirements. Otherwise, keep the workflow local.

What is the final check?

Open the exact file you intend to attach, inspect its metadata, review its contents, and confirm important calculations. Give it a clear filename so it is not confused with the original.

Inspect an XLSX file when you are ready to review the sharing copy.

Try MetaClean Pro free — remove metadata from your files in seconds.