Guite To Excel Metadata: View, Modify and Remove

How to View Excel Metadata

Method 1 – Using Info Option

  • Select File.

Image2-File Selection

  • Go to Info.

Image3-Info Selection

  • We will get metadata.

Image4-Excel Metadata

Method 2 – Using Windows Explorer

  • Right-click on the file to view details.

Image5-File Navigation

  • Click 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 OK.

Image10-Metadata Creation

How to Modify Metadata in Excel

Method 1 – Edit Default Author Name

  • Click File.

Image11-File Selection

  • Select Options.

Image12-Option selection

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

Image13-Change Default author-name

Method 2 – Add Author’s Name

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

Image14-Add author-name

  • The author’s name will be added.

Image15-Author name is added.

Method 3 – Modify Custom Properties

  • Go to File >> Info as shown in the previous examples, and click 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

Method 1 – Protect Metadata Using Info Option

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

Image18-Info Selection

  • Click Protect Workbook >> Mark as Final.

Image19-Protect data 1

  • Click OK to mark the workbook as final.

Image20.1-Protect data2

Method 2 – Protect Metadata Using a Password

  • Click 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 OK.

Image23-Setting Password

  • Confirm the password to modify and click OK.

Image24-Confirming password

How to Remove Metadata in Excel

Method 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 Yes.

Image26-Saving Warning

  • Select Document Properties and Personal Information and click Inspect.

Image27-Document Prop

  • Select Remove All and click Close.


Method 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 Properties.


  • Select Details and click Remove Properties and Personal Information.


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


Note:  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.

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.

Download Practice Workbook

You can download the workbook from here and practice yourself.

Excel Metadata: Knowledge Hub

<< Go Back to Workbook in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
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