Import xml data to a Numbers table

Hello!

I am an architect also helping with real estate marketing sometimes and I would like to catalogue all our clients into a numbers table. Clients fill out a form that generates an xml file with the data they chose to fill in, it looks a little like this:

<?xml version="1.0" encoding="UTF-8" ?>

<openimmo_feedback>

<version>1.2.5</version>

<sender>

<name>IS24</name>

<datum>01.01.2001</datum>

<makler_id>xxxx</makler_id>

<regi_id>xxxx</regi_id>

</sender>

<objekt>

<oobj_id>000000</oobj_id>

<zusatz_refnr></zusatz_refnr>

<bezeichnung>ImmobilienScout24 Infoanfrage: PROJECT TITLE</bezeichnung>

<interessent>

<anrede>GENDER</anrede>

<vorname>NAME</vorname>

<nachname>SURNAME</nachname>

<strasse>STREET </strasse>

<plz>POST CODE</plz>

<ort>CITY</ort>

<tel>PHONE</tel>

<email>MAIL</email>

<anfrage>

MESSAGE

Zusätzliche Informationen per E-Mail erwünscht? YES

Beratungstermin erwünscht? YES

Verkaufsstandliste erwünscht? YES

</anfrage>

</interessent>

</objekt>

</openimmo_feedback>

I apologise for it being in German but I filled out the form in English with caps locked words being the ones I would like to have in my numbers table, each input being represented in an individual column.

I have gotten this to work in excel, although I can only convert a singular xml into an excel file and all of my colleagues use Macs with numbers, so doing it there to begin with would be more sensical since the file conversion from excel to numbers likes to mess with formatting and everything as you guys probably know.

Thank you so much for any help or leads!

Nico