How to Remove XML Mapping in Excel (Quickest Way)
An XML map connects an Excel file with an XML schema. It is an essential requirement to export an Excel file as an XML file. The XML map in Excel allows you to specify which data from the XML file you want to import into your worksheet. You can also specify how the data should be formatted. However, you may want to remove the XML mapping in Excel after exporting or importing data. Well, this tutorial will teach you to remove the XML mapping in Excel. So, without any further delay, let’s begin straight away.
Related: 2 VBA Codes to Open an XML File in Excel
Related: How to Create an XML Schema Using Data in Excel
Guide to Remove XML Mapping in Excel
To remove an existing XML map in Excel,
Step_1: First, open the Excel file with the XML mapping.
Step_2: Then go to the Developer tab.
If you don’t see the Developer tab in the main ribbon, read 2 ways to activate the Developer tab in Excel.
Step_3: In the XML group, hit the Source command.
Hitting the Source command will open the XML Source task pane.
Related: How to Import XML Data from Web to Excel
Step_4: However, click the XML Maps button at the bottom of the XML Source task pane.
The XML Maps dialog box will open. There you will see an XML schema already added as an XML source.
Related: 4 Ways to Open an XML File in Excel
Step_5: Click on the file to select.
Step_6: Then hit the Delete button.
Now a warning dialog box will pop up. It warns you that deleting the XML map will prevent you from importing or exporting XML data using the XML map.
Related: A Complete Guide to Convert a CSV File to an XML File in Excel
Step_7: If you are concerned about this, click OK to delete the map anyway.
Now the XML schema has been removed from the XML maps dialog box.
Step_8: Now click OK to go back to the Excel worksheet.
Finally, the XML mapping has been removed from the XML Source task pane. Thus, your Excel file is no longer connected with the XML file.
Related: 5 Steps to Convert an Excel File to XML File
As the XML map is cleared, you can no longer import or export your Excel data using the deleted XML schema.
Conclusion
To conclude, I’ve discussed the workflow to remove the XML mapping in Excel. However, if you face any difficulties regarding an XML map, please let me know in the comment section below. Regards!
