How to Remove Metadata from Excel

Sharing an Excel file can sometimes feel like sharing a bit too much, and not just because of the data in the cells. Every Excel workbook contains hidden information called metadata, which includes details like who created the file, when it was last edited, and even hidden comments or tracked changes. This tutorial will walk you through exactly how to find and remove this metadata, making your spreadsheets clean, private, and professional.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What Exactly is Metadata in Excel?

Metadata, also known as "document properties," is data about your data. It’s information that Excel automatically creates and saves with your workbook to help manage and organize your files. While some of it is harmless, other pieces can reveal sensitive information you didn't intend to share.

Think of it like the label on a food package. The food inside is your actual data (the numbers and text in your cells), but the label (the metadata) tells you who made it, when it was made, and other background details.

Common types of metadata stored in Excel files include:

• Author and Editor Information: Names of the person who created the file and the person who last saved it.
• Personal Details: Username, company or organization name linked to the Microsoft Office license.
• Timestamps: Dates for file creation, last modification, and last printout.
• File Paths: The location where the document was saved on a computer or network drive.
• Comments and Annotations: Notes and feedback left within the cells that might contain internal discussions.
• Hidden Content: This can include hidden rows, columns, or entire worksheets that aren't immediately visible but are still part of the file.
• Tracked Changes: If you've used the "Track Changes" feature, a complete history of edits can be stored within the file.
• Macros and VBA Code: Scripts and automated processes embedded in the workbook.

Removing this data is important for a few key reasons: privacy, security, and professionalism. You wouldn’t want to send a client a proposal that still has internal comments like "Are we sure about this price?" or a file that reveals a confidential folder structure on your company’s server.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

How to Quickly Find Your File's Metadata

Before you remove anything, it's good practice to see what information is actually there. Finding it is simple. In both Windows and macOS versions of Excel, you can see a summary of the metadata right inside the application.

Just follow these steps:

1. Open your Excel workbook.
2. Click on the File tab in the top-left corner.
3. In the menu that appears on the left, make sure Info is selected.

On the right side of the screen, you’ll see a panel labeled Properties. This panel gives you a high-level overview of your file's metadata, including its size, title, tags, and categories. It also shows "Related Dates" (like creation and modification dates) and "Related People" (like the author and last modifier). For a more detailed view, click on Show All Properties at the bottom of the section.

The Easiest Method: Using the Document Inspector

Excel has a powerful built-in tool designed specifically for finding and removing hidden and personal information. It’s called the Document Inspector, and it's the safest and most thorough way to clean your workbook before sharing it.

A quick warning: Using the Document Inspector to remove data is a permanent action. You can't undo it. It’s highly recommended to save a separate copy of your file before you begin. You might name it something like Original_Report_Q3.xlsx and Cleaned_Report_Q3.xlsx.

Here’s how to use it:

Step 1: Open the Document Inspector

With your workbook open (remember, a copy!), go to File > Info. Next to "Inspect Workbook," you'll see a button that says Check for Issues.

Click this button and select Inspect Document from the dropdown menu.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 2: Choose What to Inspect

A dialog box will appear with a checklist of all the types of metadata the tool can search for. These categories include:

• Comments and Annotations
• Document Properties and Personal Information
• Custom XML Data
• Headers and Footers
• Hidden Rows and Columns
• Hidden Worksheets

For a complete cleaning, you can leave all the boxes checked. If you know you want to keep certain information, like headers and footers, you can uncheck that specific box. Once you've made your selections, click the Inspect button at the bottom.

Step 3: Review the Results and Remove Data

The Document Inspector will scan your file in a few seconds and present a report of what it found. Next to each category of data it located, you'll see a "Remove All" button.

For example, if it found the author's name and company info, that will be flagged under "Document Properties and Personal Information." If it found a worksheet you had hidden, it will appear next to "Hidden Worksheets."

Go through the list and click "Remove All" for each category of data you want to get rid of. Again, remember this is permanent. Once you click it, the information is gone for good.

Step 4: Close and Save

After you’ve removed the desired information, click the Close button. Finally, save your file. The workbook is now scrubbed of all the hidden data you selected, making it safe to share.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Manually Removing Specific Pieces of Metadata

What if you don't want to wipe all of your metadata? Maybe you just want to change the author's name or remove a few stray comments without affecting anything else. In that case, you can edit these properties manually.

Editing Basic Properties like Author and Title

1. Go to File > Info.
2. In the Properties pane on the right, you can directly edit many of the fields.
3. Hover your mouse over the author's name, for instance. A text box will appear, allowing you to type a new name or delete it entirely.
4. To remove an author, simply right-click their name and select Remove Person.
5. You can do the same for the Title, Tags, and other fields. Click into the field and type or delete as needed.

Removing Hidden Content Manually

The Document Inspector is great for finding hidden content, but you can also do it yourself if you want to be sure of what you’re deleting.

• To unhide columns: Select the columns on either side of the hidden one, then right-click and choose Unhide.
• To unhide rows: Select the rows above and below the hidden one, then right-click and choose Unhide.
• To unhide a worksheet: Right-click on any visible worksheet tab at the bottom of the screen and select Unhide. A dialog box will appear listing all hidden sheets, allowing you to select one to make visible.

Deleting Comments

To find and remove all comments in a workbook at once:

1. Go to the Review tab in the ribbon.
2. In the "Comments" section, click the small dropdown arrow on the Delete button.
3. Currently, there isn't a "Delete all comments in workbook" option. However, Excel 365 provides the option to delete a thread (and all the comments that belong to that thread) with a keypress (command + delete).

This is much faster than hunting for each comment one by one and deleting them manually.

Final Thoughts

Cleaning metadata from your Excel files is a straightforward process that plays a vital role in protecting your privacy and maintaining a professional image. Using the built-in Document Inspector, you can quickly and thoroughly strip your workbooks of sensitive background information before they ever leave your control.

Much of data analytics involves cleaning, preparing, and checking data - whether it's scrubbing metadata or combining reports from different platforms. This manual work takes time away from focusing on strategy. We built Graphed to automate that overhead. By connecting all your data sources in one place, you can simply ask for the reports you need in plain English and get live, interactive dashboards in seconds, freeing you from tedious tasks like manual data cleanup.