Data(Top bar)>>Get Data >> From File>> From JSON
Select File>>Import
(You can do changes now)
To Table>>(optional: Choose options)>>Ok
>>Choose the required columns and check use original name as prefix(if needed)>>Ok
>>close & load
https://www.howtogeek.com/775651/how-to-convert-a-json-file-to-microsoft-excel/