Import JSON Data in Excel 2016 or 2019 or Office 365 using a Get & Transform Query - Syntax Byte
GitHub - theAwesomeFufuman/VBA-Excel-Table-To-JSON: A small VBA script that converts Excel tables to JSON format and exports the data to a file at the location of your choice