XML Import Confussion

Dover

New Member
Joined
Sep 29, 2019
Messages
6
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
oYGt11w

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,
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Forum statistics

Threads
1,213,482
Messages
6,113,913
Members
448,532
Latest member
9Kimo3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top