Importing XML-data into Excel (as JSON)

1. Copy your link into a spreadsheet and save the link as...

2. Import the file into excel

3. Convert to table (delimiter:none)

4. Expand (untick use original column name as prefix)

5. Close and load to finalize the changes and add the report into the Excel-sheet