Pulling Data Out of HTML/XML Code

[default_name]

I have a bunch of data that was exported in an html/xml format.

<schoolFood1Type location="" size="0">63</schoolFood1Type>
<schoolFood1Order location="" size="0">198</schoolFood1Order>
<schoolFood1ProgramA location="" size="0">Yes</schoolFood1ProgramA>
<schoolFood1XPos location="" size="0">32</schoolFood1XPos>
<schoolFood1YPos location="" size="0">81</schoolFood1YPos>
<schoolFood1ZPos location="" size="0">91</schoolFood1ZPos>
<schoolFood2Type location="" size="0">30</schoolFood1Type>
<schoolFood2Order location="" size="0">19</schoolFood1Order>
<schoolFood2ProgramA location="" size="0">No</schoolFood1ProgramA>
<schoolFood2XPos location="" size="0">74</schoolFood1XPos>
<schoolFood2YPos location="" size="0">8</schoolFood1YPos>
<schoolFood2ZPos location="" size="0">48</schoolFood1ZPos>
.....


There are a ton more rows than this.
If I open up a blank sheet and just paste all of the xml/html code into it, luckily it DOES split the data up into individual rows (so that's a little bit helpful at least).
It is super tedious to try and pull this data manually into an excel table.
I am wondering if there is a more structured/automated approach.
The table is designed like this:

	A	B	C	D	E	F	G
1		Type	Order	ProgramA	X	Y	Z
2	Food1	63	198	Yes	32	81	91
3	Food2	30	19	No	74	8	48
4	...

Not sure if this is even possible in Excel.
VBA would be nice.
Non-VBA would also be nice.

Thanks in advance for your help!

 

[Alex Blakenburg]

At the risk of stating the obvious, have you tried File > Open > Change file type to all files, then open ?

Power Query would be another option if the above does not give you a decent result.
Date > Get Data > From File > From XML (change to all file types)