Open Excel
Go to the Data tab
Select Get Data
Choose From File
Click From JSON
Browse to the JSON file
Select the file and click Import
In Power Query Editor, review the data
Expand nested records or lists if needed
Click Close & Load to load the JSON into Excel