0

How to create a table in Google Sheets from an XML output with multiple children levels?

I'm trying to create a table in Google Sheets with data sourced from an XML output. The XML source is here.

Using the below formula gets the following sample output:

=TRANSPOSE(IMPORTXML(url,"//comparables/*"))

enter image description here

Lines 2, 14 and 15 of the output include multiple siblings in one cell for each parent element.

Is there a way to disaggregate those siblings into separate cells?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.