Souptik Roy
In this article, I am going to show the procedures to remove Excel metadata. While working on an Excel worksheet, your information is stored as metadata in Excel. To remove this metadata for some security or other reasons, you need to follow such a procedure. Here, in this article, I will show you three suitable ways to remove Excel metadata. I will add the necessary images to make the processes easier for you. Hopefully, you will understand the methods easily.
Download Practice Workbook
Please download the workbook to practice yourself.
3 Effective Ways to Remove Excel Metadata
Here is a dataset shown in the picture given below. As you can see, there are three columns of this dataset, B, C, and D called Name, Id, and Email Id. The dataset ranges from B4 to D10 cells. I will use this dataset to remove Excel metadata.
1. Using Info Feature to Remove Excel Metadata
We can effectively remove Excel metadata by using the Info feature. The dataset used in this part is given below. You can look at the dataset. Follow the steps one by one. Hopefully, this will help you to grow your Excel skill.
Steps:
- First, select the File tab in your toolbar.
- Then, select the Info option.
- After that, select the Show all properties option.
- Meanwhile, you will find all the properties.
- In the related people option, you will find the Author’s name. Select it.
- Then, right-click on the option.
- Consequently, a window will pop up.
- Then, select the Remove Person
- As a result, Excel will delete the author’s name.
This is how you can delete Excel metadata easily by using the Info feature.
Read More: How to Create Metadata in Excel (4 Easy Ways)
2. Withdraw Metadata from Windows File Explorer
We can easily withdraw metadata from windows file explorer. I will remove Excel metadata by using windows file explorer here. Please follow the procedures step-by-step.
Steps:
- First, go to the destination where the file is saved.
- Then, select the file and right-click on it.
- After that, select the properties
- Meanwhile, a window will pop up. Select the Details option there.
- Then, select the Remove Properties and Personal Information
- After that, select the second option shown in the figure.
- Then, press the Select all
- At last press the Ok
- Consequently, Excel metadata will be removed.
As you can see, this is another easy process to remove Excel metadata.
3. Use Excel Document Instructor to Remove Metadata
This is the third or the last method of this article to remove metadata. Here, I will use Excel document instructor to remove metadata. This process is also easy and smart. Follow the procedure steps one by one.
Steps:
- First, select the file tab on your toolbar.
- Then, select the Info.
- After that, select the check for issues option. You can also check the properties there on the right-most side.
- Moreover, click on the Inspect Document option.
- Meanwhile, a window will pop up, and select the Inspect.
- You will find the following option shown below. Select the Remove all
- Consequently, all the properties and information will be removed.
- Then, close the window.
- After that, Check the property.
- Consequently, you will see all the personal information is removed.
This is how you can remove Excel metadata by using the Document Inspector.
How to Show Excel Metadata Viewer
In this portion of this article, I will show you how to show the Excel metadata viewer. This is an easy process. I hope you will understand the process easily. Follow the step-by-step procedure to show the excel metadata viewer.
Steps:
- First, select the File Tab.
- Then, select the Info option.
- After that, select the Show all properties option.
- As a result, you will find the related people option where you can view Excel metadata.
This is the procedure on how you can view Excel metadata.
Things to Remember
- In method 1, you can select the first option not to remove all the metadata You need to select manually the options you want to delete then.
Conclusion
I have tried to explain how to remove Excel metadata in this article. I hope, you have learned something new from this article. Now, extend your skill by following the steps of these methods. You will find such interesting blogs on our website Exceldemy.com. I hope you have enjoyed the whole tutorial. If you have any queries, feel free to ask me in the comment section. Don’t forget to give us your feedback.
