XML Data Conversion to Excel Spreadsheet

Hi, Trying to convert this XML file into a spreadsheet. All of the publically available data on large firms is available to download into excel format, but smaller state registered firms are in the XML format (https://www.sec.gov/files/investment/data/information-about-registered-investment-advisers-and-exempt-reporting-advisers/ia010523.zip) for example. Also looking for state rep level (here: https://reports.adviserinfo.sec.gov/reports/CompilationReports/IA_INDVL_Feed_01_06_2023.xml.zip) in addition to firm level data (here: https://reports.adviserinfo.sec.gov/reports/CompilationReports/IA_FIRM_STATE_Feed_01_06_2023.xml.gz). These publicly available reports can be found here: https://adviserinfo.sec.gov/compilation