How to parse XML into a table?

Question

excel

There is xml with arbitrary tags

<offer id="" available="">
 <url></url>
 <picture></picture>
 <param name="Внешний код"></param>
 <param name="Наличие"></param>
 <price name="Цена USD"></price>
 <price name="Цена RUB"></price>
 <name></name>
 <description></description>
</offer>

How to translate it into a format to pull out the Offer tags as a row, and internal tags as its columns?

Answer 1

There are at least two ways: connect a library for working with XML or parse manually, up to not using VBA, but simply formulas