To convert Excel to XML, you can follow these steps:
- Create an Excel spreadsheet.
- Create an XML schema.
- Enable the Developer tab.
- Open the XML Source pane.
- Map XML file to Excel file.
- Convert Excel file to XML file.
- Save the XML file.
You can find more detailed instructions on how to convert Excel to XML in thisUdemy Blogarticle.
You may have heard of Extensible Markup Language (XML), and you may have heard many reasons why your organization should use it. But what is XML, exactly?
This links explains the basics of XML— what it is and how it works.
In this link
- A brief look at mark up, markup, and tags
- So what makes it XML?
- A word about well-formed data
- A quick look at schemas
- A quick look at transforms
- A peek at XML in the Microsoft Office System
Hope I could help you with these information / links.
I know I don't know anything (Socrates)