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.

How to open a JSON file in Windows 11/10 A JSON file is a file that keeps basic data configurations and objects in JavaScript Object Notation (JSON) format, which is a universal data interchange ...

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.