Question: how to import excel into xml?
Answer: Create an .xsd file for the XML Mappings.
Add the developer toolbar to the ribbon. Select File menu, then Options.
Add the .xsd file as an XML Source.
Map the columns to elements. Select the columns you would like to map in the Excel file.
Export to XML.