Today something about XML in Excel. We will learn how to use XSD files in the Excel application.
Downloading Xml Tools
Firstly, you will have to download the XML TOOLS ADD-IN. After downloading the add-in, start Excel, click on the FILE tab, go to OPTION and then click the ADD-INS category.
Click on EXCEL ADD-INS and then click GO. In the dialog box, click BROWSE and locate the XMLTOOL.XLA file. Select it and click OK.
Enter the data.
Converting xsd to Excel
On the Add-Ins tab, in the menu commands group, click the arrow next to XML Tools and then click Convert a Range to an XML list.
Enter the cell range of the data that you want to convert as an absolute reference in the text box.
Under Use first row as column names, select No if the first row contains data or Yes if the first column contains a header and click OK.
On the Developer tab, in the XML group, click Export.
In the dialog box, type a name in the File Name field.
Select any cell in the EXCEL table.
On the ADD-INS tab, in the Menu commands group, click the arrow next to the XML Tools and then click Create XSD file for the XML Schema.
In Notepad, click File and Save AS.
Further reading: How to open XML files in Excel?