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.
Click OK.
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.
Note: The imported XSD file may not retain all the data formatting and structure of the original file. The data may be rearranged or reformatted to fit into the cells of the Microsoft Excel worksheet. If you need to retain the original structure of the XSD file, you may need to save the data as a separate XML file, or use a specialized XML editor to view and work with the data.
Further reading: How to open XML files in Excel?