How to export data from Excel to a valid Xml?

Question

I have an Excel table with some data that I would like to export to an Xml file.
This exported Xml needs to be valid against an Xsd.

Note that all the formatting and validation must be done inside Excel because it'll be the only tool available to the person who will do the export.

Any recommendation to get this task done?

Answer 1

Save your file in xml format from Excel. This is known as MS Office XML. Documentation (and schema) is available for both Office 2003 and 2007.

Answer 2

I know it's a very old question but just in case some one else bumps in..

Accepted answer is good but XMLSS is far more complicated(though it's valid XML), I thought of sharing this resource on Microsoft. It explains everything step by step.

Another option is to create a CSV file and then convert it into XML using XI - There was an article about it on IBM developer works which can do the job quite well.

This Java API may also be of interest for few.