Question

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

  • 18 October 2022
  • 2 replies
  • 4 views

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

Userlevel 6
Badge +32

Please study the article Converting from XML (Simple XML Reading Example) from the Tutorial: Getting Started with XML.

Userlevel 4
Badge +30

@vijaychinkate​ Please, could you share your file?

Reply