An XML map allows a business to arrange data stored in XML documents so that the information can be easily imported into a predefined table in an application such as Microsoft Excel. In this way ...

The Developer tab unlocks powerful automation tools in Excel—macro recording, Visual Basic for Applications (VBA), XML import ...

If so, delete it. Now download this file and add it as an XML Map. Excel will use it to create a schema. Close any dialog boxes and you should now have something like this: Drag and drop the ...