Question: can xml files be opened in excel?
Answer: The XML data is opened as read-only in Excel so that you don't accidentally save your original source file in the Excel Macro-Enabled Workbook file format (. xlsm). In this case, Excel doesn't infer a schema, and you can't use an XML Map. ... The schema of the XML data file is displayed in the XML Source task pane.