XML into Excel

Feral

I have two different XML files that I'm trying to import into Excel 2016. As far as I can tell, they're structured mostly the same way. Here's a sanitized example of how they're structured.

<Report>

	<Family>
		<Surname>Doe</Surname>
		<Mother>Jane</Mother>
		<Father>John</Father>
		<Child>Timmy</Child>
		<Child>Julie</Child>
		<Child>Andy</Child>
	</Family>

	<Family>
		<Surname>Smith</Surname>
		<Mother>Steve</Mother>
		<Father>Sharon</Father>
		<Child>Madison</Child>
		<Child>Mason</Child>
	</Family>

	<Family>
		<Surname>Wilson</Surname>
		<Mother>Vanessa</Mother>
		<Father>Wade</Father>
		<Child>Logan</Child>
		<Child>Charles</Child>
		<Child>Scott</Child>
		<Child>Jean</Child>
		<Child>Peter</Child>
		<Child>Clark</Child>
		<Child>Jean-Luc</Child>
		<Child>Anakin</Child>
		<Child>Inara</Child>
	</Family>

</Report>

One of these XMLs imports exactly the way I want it to:



The other one, however, does this. And I can't figure out why.



The only difference I can find is that the second one has a lot of namespaces declared, so it really looks more like this:

<Report>

	<Family xmlns="http://www.yourmother.com/bagofdicks/family.html">
		<Surname xmlns="http://www.yourmother.com/bagofdicks/surname.html">Doe</Surname>
		<Mother xmlns="http://www.yourmother.com/bagofdicks/mother.html">Jane</Mother>
		<Father xmlns="http://www.yourmother.com/bagofdicks/father.html">John</Father>
		<Child xmlns="http://www.yourmother.com/bagofdicks/child.html">Timmy</Child>
		<Child xmlns="http://www.yourmother.com/bagofdicks/child.html">Julie</Child>
		<Child xmlns="http://www.yourmother.com/bagofdicks/child.html">Andy</Child>
	</Family>

<!-- Excess snipped -->

</Report>

I've tried removing some of the xmlns declarations to see if it changes anything and it doesn't.

Can anybody explain this behavior?

bowen

Something's up with that nesting, check for improperly closed tags and all that.

It's adding extra rows instead of transposing the data.

Feral

I gave up and used a different method to get the data I needed. Thanks, tho.