How to Remove Metadata from Excel Files – 5 Easy Methods

Written By

Nick Rogers

Published On

October 5th, 2026

Reading Time

9 Minutes Reading

What Is Metadata in an Excel File?

Metadata is data about a file rather than the content you see in the cells. In Excel, it is generally records who created the file, who edited it, when, and what else is stored inside it.

Metadata is very useful for internal tracking. The only risk is that it travels with the file. Therefore, if you email an Excel file to a client or upload it online, the author name, company name, and hidden sheets go with it.

Why Remove Metadata from Excel Files?

• Author names, company information and editing history can be stored in Excel metadata and can reveal confidential information.
• Removing hidden metadata helps prevent sharing of personal or organizational information.
• Cleaning metadata can slightly reduce file size, making files easier to store and share.
• It is better to share clean files without any hidden information to make it more secure and professional.

Types of Metadata in an Excel File

• Document Properties (title, author, tags)
• Hidden Rows/Columns
• Comments & Annotations
• Tracked Changes
• Hidden Worksheets
• Custom XML Data
• External Data Connections

What Hidden Data Can an Excel File Contain?

An Excel file can contain author names, company details, comments, hidden sheets, hidden rows and columns, headers and footers, and defined names.

How to Remove Metadata from Excel Files

You can scrub Excel file metadata using a manual approach and an automated tool. We’ll explain to you both the methods one by one in detail below. Follow the steps below.

Method 1: Use Document Inspector (Windows)

Microsoft Excel provides a built-in function called Document Inspector. With this function, you can easily remove the hidden data.

1. Open your Excel file
2. Click on “File” >> “Info”
3. Select “Check for Issues” >> “Inspect Document”
4. “Choose the data” you want to inspect
5. Click “Inspect”
6. Click “Remove All”
7. “Save” the file

Method 2: Remove Personal Information Automatically on Save

This setting will automatically exclude author & last modified details every time you save that file.

1. Click the “File” >> “Options” >> “Trust Center” >> “Trust Center Settings”.
2. Now, select “Privacy Options”.
3. Check “Remove personal information from file properties on save”.
4. Click “OK”. Then save the workbook.

This will only affect personal properties. Comments, hidden sheets, and links are not touched.

Method 3: Remove Properties Through File Explorer

You may easily remove properties even without opening Excel.

1. Right-click the file in “Windows File Explorer” and select “Properties”.
2. Open the “Details” tab.
3. Click “Remove Properties and Personal Information”.
4. Now, choose “Create a copy with all possible properties removed”. Or select specific properties to remove from the original file.
5. Click “OK”.

This is quick. However, it only handles properties, and not sheet-level hidden content.

Method 4: Remove Metadata in Excel for Mac

Menus on Mac actually differ from Windows. Also, Document Inspector may not be available in your version.

1. In Excel, open “Excel” >> “Preferences” >> “Security”.
2. Tick “Remove personal information from this file” on save.
3. Then, manually delete comments, unhide and review hidden sheets, rows, & columns. Now, check “Data” >> “Edit Links” for external connections.
4. Finally, save the file.

Method 5: Remove Metadata from Multiple Excel Files in One Go

Do you have hundreds of files? Opening each file in Document Inspector is usually not practical. You have two options.

Option A: A script.

This Python example can clear the main author related properties in every .xlsx file in a folder:

from pathlib import Path
from openpyxl import load_workbook

src, dst = Path("input"), Path("clean")
dst.mkdir(exist_ok=True)

for f in src.glob("*.xlsx"):
    wb = load_workbook(f)
    p = wb.properties
    p.creator = ""
    p.lastModifiedBy = ""
    p.title = ""
    p.subject = ""
    p.keywords = ""
    p.description = ""
    p.category = ""
    wb.save(dst / f.name)

Option B: A Bulk Excel Metadata Removal Tool

The 4n6 MetaRaser Tool is the suitable option for you if you want to remove metadata from bulk Excel files at once. Unlike the Document Inspector, you don’t have to inspect each Excel file one by one to remove metadata. This software automates the entire process and saves you a lot of time and effort.

Download Now Purchase Now

This Excel metadata remover is time-efficient and takes just a few easy clicks to remove hidden data in Excel files. We’ll walk you through all the software steps to get the job done. Please go through them.

Steps to Automatically Remove Hidden Data from Excel Files

1. Download, install and run the Excel metadata remover on your Windows computer
   
2. Click the “Open” menu and select Excel Files option.
   
3. Now, browse, select and import Excel files into the software panel.
   
4. Now, click the Actions option and choose Clear Metadata.
   
5. Select the location where you want to save the clean Excel files, then click Save.
   

The tool will immediately begin deleting hidden data from Excel files. It won’t take long, and once the job is done, you will be notified.

Benefits of Using Excel metadata Remover

• Allows you to remove metadata from multiple Excel files at once.
• Completely safe and preserves the content integrity in your Excel files
• Process your files offline and does not upload them to any server
• Supports to remove metadata from XLSX, XLS and other Excel files
• Supports removing metadata from large Excel files without downtime.
• Compatible with all latest versions of Windows operating systems
• Comes with a friendly interface and is useful for both technical and non-technical users.

What Document Inspector Does and Does not Remove

It does:

• Remove author names & other document properties
• Remove comments & annotations
• Remove custom XML data and headers / footers
• Delete hidden rows & columns

It does not fully handle:

• Hidden worksheets: it may find them, but you need to unhide and delete them manually
• External links: you break them under “Data” >> “Edit Links”
• Information in the visible cells

Manual vs Automated: Which Method Should You Use?

How to Check That Metadata Is Actually Gone

• Properties check. Open the Excel file and go to “File” > “Info”. Now, look at the Author, Last Modified By, and Company fields on the right.
• Windows check. Right-click the file, then open “Properties” >> “Details”, and scroll through the list.
• Re-run Document Inspector on the resultant file. It should report no issues in the categories you cleaned.
• Check for hidden content. Right click a sheet tab and look for hidden sheets. Then, select all and check for hidden rows and columns.

Best Practices Before Sharing Excel Files

• You should always clean a copy and keep the original.
• Review comments and also tracked changes before sending the file.
• Remove external links you do not want recipients to see.
• Always check sheet names, and formulas for internal names or file paths.
• Turn on Remove personal information on save for files you share most often.

Frequently Asked Questions

Does Excel save metadata automatically?

Yes. Excel records the author, last editor, dates, and other properties every time you create or save a workbook.

How do I remove the author name from an Excel file?

You may go to “File” > “Info”. Now, right click the author name under “Related People”, and choose “Remove Person”. You may also use Document Inspector or the File Explorer Properties method.

Does saving Excel as PDF or CSV remove metadata?

CSV drops most metadata as it may store only cell values. PDF can keep document properties like the author.

Is Document Inspector available on Mac?

It actually varies by version. You can check Microsoft’s current documentation. Mac users may use the Security preference to remove personal information and clean hidden content by hand.

Can I remove metadata without Excel installed?

Yes. You can use the File Explorer Properties method on Windows, a script, or a third-party tool.

Is it safe to use a third-party metadata remover?

You should use tools that process files locally like the 4n6 software. You should avoid uploading sensitive files to unknown web services.

Conclusion

Excel metadata can expose names, company details, and hidden content you never meant to share. You can use Document Inspector for a single file; it is free, fast, and reliable. Or, you can use a script or bulk tool for large-scale jobs to save time.