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.
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.
How to Remove XML Mapping in Excel: Step-by-Step Procedure
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.
Finally, the XML Source dialog box will appear.
Read More: How to Create 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.
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.
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.
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.
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.
Download Practice Workbook
You can download the Excel file from the following link and practice along with it.
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.
Related Article
<< Go Back to XML Mapping in Excel | Export Excel to XML | Export Data from Excel | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!
