I am trying to get a list of entries from an XML file which is essentially an open data source.

EDIT:

If i use

=IMPORTXML(B1;”/*”)

all the content gets jammed into one cell. B1 is the field where the website URL is stored. What i would need in seperate columns are the title, the type, the city and the media objects. The url:

http://meta.et4.de/rest.ashx/search/?experience=open-data-niedersachsen-tourismus&licensekey=VdEVEni8FhWA58234fIbjwk0bAysCkHhvXXTnC5b&type=POI&latitude=52.3744779&longitude=9.7385532&distance=30000&template=ET2014A_LIGHT_MULTI.xml

Looking forward to any idea, hint and answer. Greetings

CodePudding user response：

If you want to get the title of that page, use:

=IMPORTXML(B1,"//title", "en_US")

Which shows - for your page:

POI

See here the

https://docs.google.com/spreadsheets/d/1jnqlo0RIopHYbNqXoBOHSB1y9XjnaVKRH56Myrlrxto/copy