Every Excel file you save carries a quiet trail. Author name, company, comments, last printed date, and more sit inside the workbook even when no cell shows them. If you share that .xlsx with a client, a hiring manager, or a vendor, they can read it in two clicks. This guide shows how to scrub metadata from Excel files cleanly, in bulk, without breaking the data you actually care about.
What you will learn
- What metadata Excel stores inside .xls and .xlsx files
- How to delete metadata from a single Excel file
- How to scrub metadata from multiple Excel files in bulk
- How XLSX format keeps metadata differently than XLS
- Why free or online metadata scrubbers carry real risk
What Metadata Sits Inside an Excel File
Excel is Microsoft’s spreadsheet program, shipping since 1985. The modern .xlsx format is OOXML (Office Open XML), which Microsoft introduced in Excel 2007. Both .xls and .xlsx store a layer of file properties that have nothing to do with the cells.
The metadata an Excel workbook can hold:
- Author name and last modified by name
- Company and manager name
- Title, subject, category, tags, keywords
- Comments and notes inside cells
- Hidden sheets, hidden rows and hidden columns
- Custom XML data and document version
- Last printed date and total editing time
- Embedded headers, footers and watermarks
Anyone who opens the .xlsx can right click the file in Windows Explorer, choose Properties > Details, and read most of these fields. That is why excel metadata removal matters before you share or publish a workbook.
I once forwarded a sales sheet that still carried the original analyst’s name and our internal project code in the company field. The client saw both. Now I scrub every workbook before it leaves my drive.
How to Remove Metadata from a Single Excel File
This works in Excel 2010, 2013, 2016, 2019, 2021 and Microsoft 365 on Windows. The path is the Document Inspector, built into Excel itself.
Open the Workbook
Double click the .xlsx or .xls file. Wait for Excel to finish loading all sheets.
Go to File and Info
Click File > Info. The Info pane shows file properties like Title, Author, Last Modified By and Tags on the right side.
Open Document Inspector
Click Check for Issues > Inspect Document. Save the workbook first if Excel asks. The Inspector dialog lists every metadata category found.
Tick the Categories
Keep Document Properties and Personal Information, Comments and Annotations, Hidden Worksheets and Custom XML Data checked. Click Inspect.
Remove All
Excel shows a red exclamation mark next to anything it found. Click Remove All on each row you want stripped. Close the dialog and save the workbook.
The Inspector cannot undo. If you accidentally remove a hidden sheet you still need, close without saving and reopen.
How to Clear Author Name and Personal Info Before Save
You can also tell Excel to wipe personal information on every save for the active workbook.
- Click File > Options > Trust Center > Trust Center Settings.
- Open Privacy Options.
- Tick Remove personal information from file properties on save.
- Click OK and save the file.
This setting is per workbook, not global. You set it once per file you plan to share.
How to Scrub Metadata from Many Excel Files at Once
The Document Inspector handles one file at a time. If you have a folder of 50 or 500 workbooks, that workflow burns hours. For bulk excel metadata scrubbing, a desktop scrubber is faster.
PCDOTS Metaraser is a Windows desktop program that strips metadata from .xlsx, .xls and other Office files in one pass. It runs locally, so your workbooks never leave your machine.
Bulk Scrub Workflow
- Install and open PCDOTS Metaraser on Windows.
- Click Add Folder and pick the directory that holds your Excel files.
- The list shows each .xlsx or .xls with its current author, title and other metadata fields.
- Pick the fields you want cleared. Author, Company, Last Modified By, Comments and Custom Properties are the common ones.
- Click Erase Metadata. The status column flips to Done as each file is scrubbed.
- Save the output to a new folder so your originals are untouched.
A company that ships monthly Excel reports to 30 partners cannot inspect 30 files by hand each cycle. A bulk scrubber finishes the same job in under a minute.
XLSX vs XLS: How the Two Formats Store Metadata
The .xls format is the older Excel binary used until Excel 2003. The .xlsx format is the ZIP-based OOXML standard introduced with Excel 2007. Both carry metadata, but they hold it differently.
| Feature | XLS | XLSX |
|---|---|---|
| Released with | Excel 97 onward | Excel 2007 onward |
| Format type | Binary BIFF | ZIP of XML parts |
| Where metadata lives | Inside the binary stream | In docProps/core.xml and docProps/app.xml |
| Editable by text editor | No, binary | Yes, after unzipping |
| Document Inspector works | Yes | Yes |
You can rename an .xlsx to .zip, open it, and look inside docProps/core.xml to see Author, Last Modified By and Created date in plain XML. That is also why excel metadata cleanup matters, the data is right there for anyone to read.
Scrub Metadata vs Remove Metadata: Same Thing
People search both phrases. Scrub metadata and remove metadata mean the same outcome for Excel files. Some users prefer scrub because it suggests a deeper wipe, especially for compliance work. The mechanic is identical: the file is rewritten without the metadata fields you marked.
About Free and Online Excel Metadata Scrubbers
Free and online excel metadata scrubbers exist. They are tempting when you have one file to clean. We do not recommend them for any workbook that holds business, client, or personal data.
- You have to upload the workbook to a server you do not control.
- The terms often allow the service to store, analyze or share the uploaded file.
- If the workbook has client emails, salaries or customer lists, the upload is the leak.
- Browser session caches sometimes hold the file after you close the tab.
For anything you would not paste into a public chat, use the offline route. The built-in Document Inspector handles one file. PCDOTS Metaraser handles many. Both keep the workbook on your machine.
Checklist Before You Share an Excel File
- Author and Last Modified By are blank or set to a neutral name.
- Comments are removed or marked clearly safe to read.
- Hidden sheets, hidden rows and hidden columns are reviewed.
- Custom XML and macros are stripped if the recipient does not need them.
- The file is saved as the version of Excel the recipient uses.
Frequently Asked Questions
How do I remove metadata from an Excel file?
Open the workbook, click File > Info > Check for Issues > Inspect Document, run the inspector and click Remove All on Document Properties and Personal Information, then save.
How do I remove metadata from multiple Excel files in bulk?
Use a desktop scrubber such as PCDOTS Metaraser on Windows. Add a folder of .xlsx or .xls files, pick the fields to clear, and run Erase Metadata. The whole batch is processed locally.
Does saving an Excel file as PDF remove the metadata?
No. Saving as PDF carries Author and Title across into the new PDF. Strip the Excel metadata first, then export to PDF.
What is metadata in Excel?
Metadata in Excel is the set of file properties stored alongside the cell data: author, company, comments, hidden sheets, custom XML, last printed date and similar fields. It is separate from the rows and columns you see.
Is it safe to use online Excel metadata removers?
Not for sensitive data. Online scrubbers require you to upload the workbook to a server, which exposes the very content you are trying to protect. Use offline tools for any file that holds business or personal data.
What is the difference between XLS and XLSX metadata?
XLS is the older binary format, XLSX is the ZIP-based OOXML format from Excel 2007. Both hold metadata, but XLSX keeps it as plain XML inside docProps/core.xml and docProps/app.xml, which is readable by any text editor.
