If you want to cancel the import procedure, click the Cancel button on that Import Data dialog box. Excel will automatically creates a schema based on the source data: Click Ok to create the map. The XML Maps dialog appears, click Add, select pets.xml file and click Open. If you click the Close button on the dialog, Excel continues the import process and then opens the Import Data dialog box. Open XML Source task pane by clicking the Developer > Source and click XML maps button from the XML Source task pane to add XML maps. Again, select the option 'Use the XML source task pane'. I've left out the name of the first employee from this file. Close all open files in Excel you don't need and select File, Open. The results might not be what you expect. First an XML file containing a reference to s schema must be mapped to Excel cells. Note that Excel will generate a new schema for your XML file by analyzing the data included in the file. If you don't want to see messages of this type in the future, select the In the future, do not show this message check box.Ĭlick OK if you want Excel to continue the import process.

Before we start preparing the excel file for conversion, you MUST save the XSD Schemas. To correct, you should probably validate the XML file you are trying to import to make sure it is the right type and the XML is well formatted. Please note, clicking the Save As option will not convert your file.

One example where this can happen is if you try and import an XSD file instead of an XML file. If you're seeing this message in Excel, it's because you are trying to import an XML file that Excel does not understand as a valid schema. Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007 More.

Excel xml schema