XML Import Confusion

DanHowles

New member
Joined
Sep 30, 2019
Messages
2
Reaction score
0
Points
0
Excel Version(s)
364
Hey all,
First time poster here, so I hope this is the correct place to post this.
I'm looking to import an XML in to Excel but i'm having issues with it.

I've used the Import wizard and feel like I'm most of the way, but I'm missing something probably simple.
The XML I am trying to import is the XML for a game that I need statistics from and because I believe it is full of tables I'm struggling to access any information.

The XML is a few hundred records and has several columns, so a manual copy and paste job isn't really viable for me.

Opening the XML in the Importer seems good promising to being with, but investigating more just shows me the value of "table"
I was wondering if there is a way to get Excel to automatically pull each record's value inside these tables.
Screen shots to follow.

So opening the XML, gets me here
https://imgur.com/a/oYGt11w

And I can see most of the information, until I go further across and start to see the value "table" is shown for most of the cells.
https://imgur.com/a/3wV9Kgc

At the bottom the query is pulled from the correct table and if I double click I see the individual value.
However I would like to it too pull every and every value that says table in one clear spreadsheet.

I'm sure it's very simple, but after googling I can't seem to get a simple answer.
Thanks in advance,

-Dan
 
Last edited by a moderator:
Can you post the XML?
 
Back
Top