Use Excel's Get & Transform (Power Query) experience to connect to a JSON file.
Connect to a JSON file
Click the Data tab, then 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.
There are many solutions available to convert excel files to .json file. Many online tools are availale on the internet to convert file to .json it is the easy way for converting your files.