[mistermann]

I'd be interested to learn more about this, I've never heard of anyone importing XML into Excel before - typically "flat files" or SQL datasets are imported into an Excel table, upon which you can quickly build a pivot table, etc. Are you pulling in nested data?

[discordance]

I import nested XML into Excel all the time. You will need to create an XML Map first. Look under Excel/Developer/XML Source/XML Maps

[5h]

yes, exactly that, drag an xml file into excel, choose "generate a schema", then you can drag and drop fields from your nested structure,

parent records will be repeated intelligently for nested sub-records.