Excel to XML

[Fitness__69]

I need to convert Excel to XML.

I have the XML Schema and data available. Any idea where to start?

[#2 · Accepted solution]

@Fitness__69 

XML for the uninitiated

To convert Excel to XML, you can follow these steps:

1. Create an Excel spreadsheet.
2. Create an XML schema.
3. Enable the Developer tab.
4. Open the XML Source pane.
5. Map XML file to Excel file.
6. Convert Excel file to XML file.
7. Save the XML file.

You can find more detailed instructions on how to convert Excel to XML in this Udemy Blog article.

XML for the uninitiated

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.

NikolinoDE

I know I don't know anything (Socrates)

[#3]

That's perfect information thank you. The Udemy Blog made it very simple

[#4]

I'm glad that you can support your project with this information.
I wish you continued success with Excel.

[#5]

Hi, thanks for taking the time to provide this info. I am however stuck at step 4, because whilst I have enabled the developer tab, there is no section on it for sources. I am using excel from office 365 on a mac.

[#6]

@hollywood72 

Your Tab look like this, otherwise there could be ad ons required.

[#7]

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.