How to Edit XML File in Excel (With Easy Steps)

This tutorial will demonstrate how to edit an XML file in excel. XML is a markup language. It is mainly used for giving definitions of markup languages. XML is mostly used for creating formats for data transferring or records or encoding particular documentation. After going through this article you will learn how to edit the XML files in excel on your own.


Download Practice Workbook

You can download the practice workbook from here.


Step-by-Step Procedures to Edit XML File in Excel

Our main goal is to learn how to edit XML files in excel. If you follow the below steps correctly, you should learn the process on your own. The steps are:


1. Locating XML File’s Location

To edit the XML file, first, we have to arrange the XML file and find it on your desktop. The step is described below.

  • First of all, we will go to the Start button of windows or just go to the search button to find the XML’s file location.

  • Next, select the XML file.

Procedures to Edit XML File


2. Displaying XML’s Content in Excel

In this case, our goal is to display the content of the XML file in excel. We will be able to do that if we follow the below steps:

  • At first, open a blank workbook using excel.

Opening Blank Workbook

  • Next, click on the XML file.
  • Then, drag the XML file into the blank workbook.

Dragging XML file into Excel

  • After that, select the option open As an XML table and press OK.

  • Finally, you will get results like the below image.


3. Editing Excel Document

Now, our excel file is ready to be edited. So, let’s fulfill the step by following the below description.

  • Click on the Filter Text option and make the desired changes in the excel file.
  • After that, press OK.

Editing the XML file

  • Then, you will get the desired result.

Showing Final Result


4. Saving Edited File As XML Document

After making the desired changes, now we want to run the file. But before that, we have to save the edited document similar to the below description.

  • To begin with, go to the File option of the altered document.
  • Secondly, press Save As or press Shift+S to save the desired document.

Saving the Edited File

  • Now, select the XML Data option to save the excel file as an XML file.

  • Finally, you will get the desired result.


Things to Remember

  • Knowing the file’s exact name is very important. This type of XML file is very difficult to locate as they are usually stored as internal functions in the computer.
  • It is very important to save the file otherwise the changes on work.

Conclusion

Henceforth, follow the above-described steps of the method. Thus, you will learn how to edit the XML files in excel Let us know if you have more ways to do the task. Follow the ExcelDemy website for more articles like this. So, don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.

Zehad Rian Jim

Zehad Rian Jim

Hi there! I am Zehad Rian Jim. I graduated with a bachelor's degree in engineering from BUET. Currently, I am working as a technical content writer at ExcelDemy. You will find all my articles on Microsoft Excel on this site. Outside of the workplace, my hobbies and interests include watching movies, tv series, and meeting new people. I also enjoy sports. My favorite sports are Cricket (to watch and play) and Badminton (play).

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo