How to Remove XML Mapping in Excel (with Easy Steps)

If you have decided that you no longer want to use XML Mapping in Excel, there are a few ways that you can remove it. You can either remove the XML schema file from your computer, or you can unregister the schema file from Excel. Removing the XML schema file from your computer will permanently delete it. If you think that you might want to use the schema again in the future, you should unregister it from Excel instead. In this article, I will show you how to remove the XML mapping in Excel. So, without having any further discussion, let’s get straight into the topic.


Download Practice Workbook

You can download the Excel file from the following link and practice along with it.


What Is XML Mapping in Excel?

XML Mapping in Excel is the process of defining how an XML Document is transformed into an Excel workbook. This process is helpful when working with large or complex XML documents, or when you want to control how data from an XML document is imported into an Excel workbook.

An XML Map is an XML Schema that represents the structure of an XML document. The XML Map is used to bind XML elements to cells in an Excel workbook. When you import an XML document into an Excel workbook, the data from the XML document is mapped to the cells that are associated with the XML elements in the XML Map.


Steps to Remove XML Mapping in Excel

Look at the table dataset below. The following Excel Table has been created by importing an XML file.

The following XML file was used to create the table above. So, an XML map was created between this XML file and the data table above. In this tutorial, I will show you how to remove the XML mapping between the following XML file and the Excel Table above.


Step-1: Activate Developer Tab

To remove an XML mapping, you need to activate the Developer tab first. Because you can only open the XML Map dialog box from the Developer tab.

To activate the Developer tab,

❶ Go to the File menu.

❷ Then select Options.

Excel Options dialog box will appear.

❸ Select Customize Ribbon command in the left-most column.

❹ Now select Developer in the Main Tabs section.

❺ Finally, hit the OK button.

Now check out your Excel ribbon, you will find the Developer tab this time.


Step-2: Open XML Source Dialog Box

To avail of the XML MAP dialog box, you need to open the XML Source dialog box first.

For that,

❶ Select any cell in the Table that you created using the XML mapping feature.

❷ After that, go to the Developer tab.

❸ Click on the XML drop-down.

❹ Now select the Source command in the XML group.

Remove XML Mapping in Excel

Finally, the XML Source dialog box will appear.

Remove XML Mapping in Excel


Step-3: Remove XML Mapping in XML Map Dialog Box

After you have opened the XML Source dialog, follow the steps below to remove the XML mapping in Excel.

❶ First, click on the XML Maps command at the bottom of the XML Source dialog box.

Remove XML Mapping in Excel

After that, the XML Maps dialog box will appear.

❷ Now select your preferred XML map in the ‘XML maps in this workbook’ section.

❸ After that, click on the OK button to remove the map.

Remove XML Mapping in Excel

In this state, a warning dialog box will appear that says ‘If you delete this XML map, you will no longer be able to import or export XML data using this XML map.’

❹ Click OK to delete the XML map permanently.

Remove XML Mapping in Excel

Now check the XML Maps dialog box. Your selected XML map has been removed successfully.

❺ Just click on the OK button to go back to your Excel worksheet.

Remove XML Mapping in Excel


Practice Section

You will get an Excel sheet like the following screenshot, at the end of the provided Excel file where you can practice all the topics discussed in this article.


Conclusion

To sum up, I have discussed how to remove XML Mapping in Excel. Please don’t hesitate to ask any questions in the comment section below. We will try to respond to all the relevant queries asap. And please visit our website Exceldemy to explore more.

Mrinmoy

Mrinmoy

Hi! I'm Mrinmoy Roy. I'm an Excel and VBA content developer. I write blogs relating to Microsoft Excel on Exceldemy.com. I've completed my graduation in Electronics and Communication Engineering from Khulna University of Engineering & Technology. I've expertise in Excel functions, formulas, Pivot Table, Power Query, Visual Basic, etc. I write blogs to lessen people's hassles while working on Microsoft Excel.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo