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.