Question: how to extract data from json file to excel?
Answer: On the Data tab, click Get Data > From File > From JSON.
Browse to your JSON file location, select it, and click Open.
Once the Query Editor has loaded your data, click Convert > Into Table, then Close & Load.