Import xml file,How?

B

Benny

I want to import a xml file to excel to get the following result

src_id word Key Key
40 abridg(e)ment abridgment abridgement

NOT

src_id word Key
40 abridg(e)ment abridgment
40 abridg(e)ment abridgement

is there a way to do that?

My xml file's format:

<?xml version="1.0" encoding="utf-8"?>
<Dict name="EC_LDOBE">
<rec src_id="40">
<word>abridg(e)ment</word>
<Key>abridgment</Key>
<Key>abridgement</Key>
</rec>
<rec src_id="94">
<word>Accepting Houses Committee (A.H.C.)</word>
<Key>accepting houses committee</Key>
<Key>A.H.C.</Key>
</rec>
.......
<rec src_id="13152">
<word>year to year, tenant from</word>
<Key>yeartoyeartenantfrom</Key>
</rec>
<rec src_id="13155">
<word>Y.E.R.,</word>
<Key>YER</Key>
</rec>
</Dict>
 
Top