Excel Metadata (View, Modify and Remove)

Get FREE Advanced Excel Exercises with Solutions!

In this article, we will learn about Excel metadata. We will learn how to view, modify, or remove all or selected metadata.

We need to view the metadata to know various information regarding a file. Also, we can know information like the author’s name and file modification date. And we can modify the metadata of an Excel file.

Sometimes, we need to remove metadata for privacy or security purposes. We will also explore different options for removing metadata in this article.

Image1-Excel Metadata Overview

Download Practice Workbook

You can download the workbook from here and practice yourself.

What Is Metadata in Excel?

Metadata can be defined as the data about data. For example, a file contains data about various topics- business data, contact information, etc. And metadata of the Excel file is the data regarding the file itself. This metadata includes the author name, file creation date, modification, etc.

Types of Properties (Metadata) of an Excel File

There are several types of metadata. Here, we will shed light on the key points.

  • Standard properties are the metadata that contains basic information like author, title, subject, category, etc.
  • Automatically updated properties contain the information that is created automatically. The file size and date of creation or modification of a file are such examples.
  • User-defined properties are known as Custom properties. You can modify this information yourself.
  • Properties for your organization contain information about your organization.
  • You can set the Document Library properties while adding a file to the document library.

How to View Excel Metadata

We can view metadata following two methods.

1. Using Info Option

  • Select File.

Image2-File Selection

  • Go to Info.

Image3-Info Selection

  • As a result, we will get metadata.

Image4-Excel Metadata

2. Using Windows Explorer

  • Right-click on the file to view details.

Image5-File Navigation

  • Click on Properties to open details.


  • Go to Details, where you’ll get the file metadata.

Image7-Metadata using file explorer

How to Create Metadata in Excel

  • Go to File.

Image8-File Selection

  • Select Info.

Image9.1-Info Selection

  • Go to Properties >> Advanced Properties.

Image9-Click on Properties

  • Fill up the data fields in the Summary tab and click on OK.

Image10-Metadata Creation

How to Modify Metadata in Excel

1. Edit Default Author Name

  • Click on File.

Image11-File Selection

  • Select Options.

Image12-Option selection

  • Type the author name in the User name field and click on OK.

Image13-Change Default author-name

2. Add Author’s Name

  • Go to File >> Info as shown in the previous examples, type the author name as shown in the figure, and press ENTER.

Image14-Add author-name

  • As a result, the author’s name will be added.

Image15-Author name is added.

3. Modify Custom Properties

  • Go to File >> Info as shown in the previous examples, and click on Properties >> Advanced Properties.

Image16-Click on Properties

  • A Metadata Properties dialog box will pop up.
  • Go to Custom, fill in the data fields, and click OK to modify the custom data.

Image17-Custom data

How to Protect Metadata in Excel

1. Protect Metadata Using Info Option

  • Go to File >> Info, as shown in the previous examples.

Image18-Info Selection

  • Click on Protect Workbook >> Mark as Final.

Image19-Protect data 1

  • Finally, click on OK to mark the workbook as final.

Image20.1-Protect data2

2. Protect Metadata Using a Password

  • Click on File.

Image20-File Selection

  • Select Save As to open the window.

Image21-Save As

  • Select Tools >> General Options.


  • Type the password to modify and click on OK.

Image23-Setting Password

  • Confirm the password to modify and click on OK.

Image24-Confirming password

How to Remove Metadata in Excel

1. Remove Metadata from a Single Workbook

  • Go to File >> Info like the previous examples and select Check for Issues >> Inspect Document.

Image25-Inspect Document

  • A warning will pop up. Click on Yes.

Image26-Saving Warning

  • Select Document Properties and Personal Information and click on Inspect.

Image27-Document Prop

  • Select Remove All and click on Close.


2. Remove Metadata from Multiple Workbooks

We can remove the metadata of multiple workbooks together.

  • Select all the files and right-click to open the options.

Image29-File Selection

  • Click on Properties.


  • Select Details and click on Remove Properties and Personal Information.


  • Select the options as shown in the following image and click on OK.


Note: You can select the specific metadata to remove instead of all the metadata.

Things to Remember

  • Consider your privacy while sharing a file, and remove metadata if necessary.
  • Check the author list to ensure author authentication.
  • Regularly back up files to avoid file or metadata loss.


I’ve discussed the Excel metadata in this article. The topics covered the basics of metadata and the more advanced uses like editing or removing metadata. If you have followed this article thoroughly, you know the basics of metadata and ways to modify or remove metadata. I hope you can use metadata according to your needs with some practice. Please let me know in the comment section if you have any queries. Team Exceldemy will be there to solve your problem. Have a good day!

Frequently Asked Questions

1. Can I edit or customize metadata in Excel?

Yes, Excel allows you to edit or customize metadata.

2. Can I extract metadata from multiple files at once?

It is possible to extract metadata from multiple files at once. You can use VBA to do so.

3. Does metadata impact the performance of my workbook?

Metadata does not impact the performance of a workbook unless the metadata is extremely large.

Excel Metadata: Knowledge Hub

<< Go Back to Workbook in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Hadi Ul Bashar
Hadi Ul Bashar

Hadi Ul Bashar holds a BSc degree in Biomedical Engineering from Bangladesh University of Engineering and Technology.  In January 2023, Bashar joined SOFTEKO as an Excel and VBA content developer. Since then, he has authored over 50 articles. He was engaged in two specialized training programs focused on VBA and Chart & Dashboard designing in Excel. Currently he is creating video content on Excel and VBA and has created over 70 videos. Reading books and traveling are his... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF