Start a new Spreadsheet Select the Data tab Go to the From JSON option Import the preferred JSON file Convert to table 1] Open Microsoft Excel To get started, please open Microsoft Excel right away.

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.