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.

Guide to Remove XML Mapping in Excel

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.

Guide to Remove XML Mapping in Excel

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.

Guide to Remove XML Mapping in Excel

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!

Related Articles

(Visited 78 times, 3 visits today)

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *