Results 1 to 3 of 3

Thread: XML Import Confussion

  1. #1
    Neophyte DanHowles's Avatar
    Join Date
    Sep 2019
    Posts
    2
    Articles
    0
    Excel Version
    364

    XML Import Confussion



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,668
    Articles
    0
    Excel Version
    O365
    Can you post the XML?

  3. #3
    Neophyte DanHowles's Avatar
    Join Date
    Sep 2019
    Posts
    2
    Articles
    0
    Excel Version
    364
    Hey Bob,
    Attached is the XML.
    In there are several tables, I am looking at the "monsters" table, but i would like to eventually apply the same logic to everything here.

    https://1drv.ms/u/s!AigUhyDVsz8Yg_cYUn9A_g7Ru6Up1A?e=EJone2
    Last edited by DanHowles; 2019-09-30 at 06:32 PM.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •