Skip to main content
Question

XML to excel convert- how to convert attached xml file in excel? all attributes should be populate in single column


XML to excel convert- how to convert below xml file in excel?

All attributes should be populate in single row with separate columns

<PlaceList>

<Place><LocationList><Location type="MAIN"><Address><ParsedList><Parsed languageCode="en-GB"><CountryCode>IND</CountryCode><PostalCode>303805</PostalCode><Admin><AdminLevel><Level2>Rajasthan</Level2><Level3>Jaipur</Level3><Level4>Amber</Level4></AdminLevel></Admin></Parsed><Parsed languageCode="hi-Latn" languageType="TRANSLITERATION"><CountryCode>IND</CountryCode><PostalCode>303805</PostalCode><Admin><AdminLevel><Level2>Rajasthan</Level2><Level3>Jayapur</Level3><Level4>Ambar</Level4></AdminLevel></Admin></Parsed><Parsed languageCode="hi"><CountryCode>IND</CountryCode><PostalCode>303805</PostalCode><Admin><AdminLevel><Level2>राजस्थान</Level2><Level3>जयपुर</Level3><Level4>अम्बर</Level4></AdminLevel></Admin></Parsed></ParsedList></Address><GeoPositionList><GeoPosition type="ROUTING"><Latitude>27.0553</Latitude><Longitude>75.8362</Longitude></GeoPosition></GeoPositionList><MapReferenceList><MapReference providerName="HERE"><Map version="RN 181" sequenceNumber="1801302"><Link linkPvid="1242128103"><Side>neither</Side><Spot>87</Spot></Link></Map></MapReference></MapReferenceList><AdditionalData key="LocationType" languageCode="en">Entry Point</AdditionalData><AdditionalData key="MatchLevel" languageCode="en">GeoPoint</AdditionalData></Location></LocationList><Identity><Supplier><SupplierName><Text type="OFFICIAL">PLACES_OWNED_GOLF_COURSE</Text></SupplierName></Supplier></Identity><Content><Base><NameList><Name><TextList><Text><BaseText type="OFFICIAL" languageCode="en-GB">Royal Jaipur Golf Club</BaseText></Text></TextList></Name></NameList><CategoryList><Category categorySystem="navteq-lcms"><CategoryId>800-8600-0193</CategoryId></Category><Category categorySystem="navteq-poi"><CategoryId>7992</CategoryId><CategoryName><Text languageCode="en" type="OFFICIAL">Golf Course</Text></CategoryName></Category></CategoryList><ContactList><Contact type="MOBILE" preferred="true"><ContactString>97999-97715</ContactString><AdditionalContactInfo><AreaCode>97999</AreaCode><LocalNumber>97715</LocalNumber><CountryCode>91</CountryCode><AdditionalData key="PhonePrefix">0</AdditionalData></AdditionalContactInfo></Contact></ContactList><ExternalReferenceList><ExternalReference system="corepoixml"><ExternalReferenceID type="SUPPLIER_POIID">1230430117</ExternalReferenceID></ExternalReference></ExternalReferenceList></Base></Content></Place>

</PlaceList>

 

2 replies

nielsgerrits
VIP
Forum|alt.badge.img+54

danilo_fme
Evangelist
Forum|alt.badge.img+45
  • Evangelist
  • October 18, 2022

@vijaychinkate​ Please, could you share your file?


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings