JSON to Excel is one more free online tool that lets you convert a JSON file into multiple formats. You can upload a JSON file from your computer or by pasting the URL of the remote JSON file.

Convert to Excel: After selecting the JSON file, click “Convert”. The utility processes the data into a structured Excel format. 4. Save the Excel File: Once conversion is complete, save the Excel ...

That shouldn't be a problem, after all, Excel can handle JSON. So, you try to open the file in Excel using its data import tooling, which usually works very well indeed as a basic ETL system.