extract info from xml and populate to excel

Dear all,

I was assigned with a new project to extract parameters from an xml file and insert into excel.

How should i start with? Example once i locked to <name> tag and greap "danny", how should i proceed with the next few rows to look for "steven" and insert into excel?





example of the xml file:

<name>danny</name>
<ip>10.11.22.3</ip>
#
#
#
#
#
<name>steven</name>
<ip>10.11.22.45455555</ip>
#
#
#

I don't know. I was just thinking this way.
- First import xml data in Excel in a sheet.
- Loop through the rows (records) of your sheet.
- If there is a match <name> take the value.