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.

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

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

Read More: How to Convert Large XML to Excel

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.

Read More: How to Convert XML to XLSX Without Opening File

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

Read More: How to Convert XML to Excel Table

4. Saving Edited File As XML Document

After making the desired changes, 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.

Read More: VBA Code to Convert XML to Excel

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.

Download Practice Workbook

You can download the practice workbook from here.


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. So, don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.

Related Articles

<< Go Back to Import XML to Excel | Importing Data in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Zehad Rian Jim
Zehad Rian Jim

Zehad Rian Jim is a dedicated professional with a BSc. Degree in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology. He's good with Microsoft Office and has written more than 80 helpful articles for ExcelDemy in the last year. Now, he makes fun and easy-to-follow Excel tutorials for YouTube as part of the ExcelDemy Video project. Zehad loves figuring out Excel problems, and his passion for learning new things in Excel shines through in... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF