excel data to xml - list of lists error

[Ana Paola Escobar Romero]

Hello, I'm having trouble exporting my data to xml.

Someone knows how to avoid this or what do I need to do to arrange this?

[#2 · Accepted solution]

Excel can only export very simple XML structures with a maximum nesting level of 1. So this is allowed:
<?xml version="1.0" encoding="UTF-8"?>
<title>JKP's Excel pages</title>
<description>Excel Articles at JKP Application Development Services</description>
<link>http://www.jkp-ads.com/Articles/Excelarticles.asp</link>
</xml>
This is not allowed:
<?xml version="1.0" encoding="UTF-8"?>
<channel>
<title>JKP's Excel pages</title>
<description>Excel Articles at JKP Application Development Services</description>
<link>http://www.jkp-ads.com/Articles/Excelarticles.asp</link>
</channel>
</xml>

[#3]

Does exist a way to make it work? an extensión, macro or something?

[#4]

VBA would work, you would need to know the structure of the XML to write the code however, this sin't trivial.

[#5]

Well thank you very much! :D