Question: how to import json 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.