URGENT HELP on XML Data delimiter to columns (with input being Excel)

[navedkhan]

Hi All - i've some data in column which is in XML format and i want it to delimit in Power Query so that i can then build my report on it. Input is EXCEL file which has following columns;

For e.g;

Date	Region	Data
01 07 2020	Japan	<?xml version="1.0"?> <catalog>    <book id="bk101">       <author>Gambardella, Matthew</author>       <title>XML Developer's Guide</title>       <genre>Computer</genre>       <price>44.95</price>       <publish_date>2000-10-01</publish_date>       <description>An in-depth look at creating applications       with XML.</description>    </book>    <book id="bk102">       <author>Ralls, Kim</author>       <title>Midnight Rain</title>       <genre>Fantasy</genre>       <price>5.95</price>

How do i read this data in power query so that necessary MI can be built on it? 

Any help would be much much appreciated. this is to be delivered Very URGENTLY.

[collinq]

Hi @navedkhan ,

Connect to the data file using "XML" and then the file will be brought into Power Query and you can manipulate it as needed.

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!