Forum Discussion
Solved
Excel to XML
I need to convert Excel to XML. I have the XML Schema and data available. Any idea where to start?
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 this Udemy Blog article.
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)
No, it doesn't look like that, as I said, there is no section for source and the only add ins aoffered do not solve the issue.
- Are you using a Mac? That may be the issue. Mac doesn't have this function. It has been requested since at least 2012 to no avail.
