Question: how to import excel data into xml?
Answer: If you don't see the Developer tab, see Show the Developer tab. In the Import XML dialog box, locate and select the XML data file (. xml) you want to import, and click Import. If the XML data file doesn't refer to a schema, Excel infers the schema from the XML data file.