Hi All,

Greeting!

I have scenario where I need to compare source with Target, My Target is in xml form, I want to convert xml into xl like table and compare with source.

Challenge here is Target which is in xml format is placed in each cell of a column need to be converted into readable xl table format and compare it with source(the source contains only few columns whereas target is combination of multiple tables contains all the associated data,hence there are many tags I need to compare with available source data with target which in xml format)

Source
Col1 Col2 Col3
Test1 Test2 Test3
Test1 Test2 Test3

Target
Col a
xml1
xml2
xml3


Is there any way to convert xml into excel and compare with it my source data, it will be really helpful if any macros is available which can help me resolve me problem.


Regards,
Vivek.