Ensure that you save the map file with a ".xml" extension. Click on the "Data" menu in Excel and choose "XML," then "XML Source" to open the "XML Source" task pane.

We’ll take you through a step-by-step guide on how to open an XML file in Excel, Word, Chrome, and Edge. Let’s get started. It may sound strange, but MS Excel can handle XML data. It allows ...