XML Import Confussion

[Dover]

Hey all,
First time poster here, but i've lurked on the site for a while.
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 is a few hundred records and has several rows, so a manual copy and paste job isn't really viable for me.

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.

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 advanc,

 

[sandy666]

you are welcome

have a nice day

 

[mlohani]

This can help you.

Import CSV & XML files into Excel - ProWorkflow

Export contacts, quotes, invoices and most reports in both CSV and XML format into excel using ProWorkflow management software.

www.proworkflow.com