Skip to main content
Question

Excel data to XML

  • June 29, 2023
  • 1 reply
  • 78 views

Hello,

what are the options for converting Excel data to XML, please? Can you provide me with multiple options (easier/more complex)? Is it possible to show me a graphical representation or even send a file directly?

 

The problem may also occur with the XML file format, but I would address it by using an XSD file.

 

Thank you very much in advance for your help.

1 reply

hkingsbury
Celebrity
Forum|alt.badge.img+53
  • Celebrity
  • July 2, 2023

This is an incredibly open ended question. Without examples of the input data there's not really any examples that can be provided.

 

There's also the question of what does the output xml need to look like? Is there a specific schema it needs to conform to? Is the data going to be at a single level or are there sub levels that form a 1:N relationship (arrays/lists).

 

If the data is 100% flat, then you can export the xml directly from excel: https://support.microsoft.com/en-gb/office/export-xml-data-0b21f51b-56d6-48f0-83d9-a89637cd4360

This will at least give you a starting pont of how you need to do it in FME


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings