

Every Excel file has metadata. According to Wikipedia, “Metadata is data [information] that provides information about other data”. That means, metadata is some data which is not your content of your file but rather information like the author name, data saved or even the file name. Or in other words: If your Excel file is a letter or parcel, the address written on it is the metadata.
In many cases, the metadata is very useful: You can easily see who edited the file the last time or when was it saved the last time. But sometimes, you want to remove this information. For example, when you send your file to a client and it still contains somehow data of your previous client.
This article introduces 5 methods to see, change and remove the metadata of your Excel file.
Contents
In Excel, click on “File” and then on “Info” to see the document properties.
The first method is actually quite simple. Excel can show you the most relevant metadata – the “document properties”. Just follow these steps.
Most properties you can change here right away. Just click into the field (for example “Add a title” or “Add an author”).
The Windows Explorer can show some metadata without opening the file.
The Windows Explorer can also show the most important metadata. The advantage is that you don’t even have to open the file. Say you have a password protected Excel file and still want to know when it was saved or what day it was created. Please note: If the file is password protected, some information is not show, e.g. the author name.
Follow these steps.
The Doeument Inspector can check and remove various hidden information and metadata.
This method is especially useful if you want to remove all metadata before sharing your Excel file. Excel provides a function to check your file for you. Not only metadata, but anything possible confidential is found and can be removed with just a few clicks.
Unfortunately, the Document Inspector for many cases doesn’t provide further information (like the actual author name) but just offers to remove them. The advantage of this function is that you gain a comprehensive impression of all the issues – not only the metadata itself – but also other possibly confidential content.
See the metadata with Professor Excel Tools.
You want to gain a quick impression of the metadata? We’ve added such function to our Excel add-in “Professor Excel Tools”. Just click on “Info” on the right-hand side of the “Professor Excel” ribbon.
It summarizes the following data.
Furthermore, you can see a summary of your content, e.g. the number of worksheets, hidden worksheets, headers and footers, hyperlinks, links to other workbooks and so on.
The best: With one click you can insert a summary worksheet so that you can comfortably copy and paste the information.
This function is included in our Excel Add-In 'Professor Excel Tools'
Learn more Download Free Trial
(No sign-up, download starts directly)
More than 10k people on Facebook can't be wrong.
Besides other document inspector, you can also manually check for other hidden data in your Excel file. The advantage of doing it manually: You can decide for each single item what to do with it. Remove, keep or change.
You could start with the following items.
The contents of an empty Excel workbook.
Our 6th and last method is probably more relevant to advanced users. You can check all the raw contents of your file. It’s recommended to save your file, close it and create a copy. Rename the copy and replace the .xlsx in the by .zip. Now you can open the .zip file, click on “docProps” and open “core.xml”. Now you can see some main metadata and change it. But please be careful: some changes might damage your Excel file.
This article has more information concerning this method and provides more detailed instructions.
Was the information helpful in this article?
'Professor Excel Tools': Add more than 60 amazing features to Excel!
Professor's Error Helper for Excel: Solve any error in Excel.
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.