Import JSON Data in Excel 2016 or 2019 or Office 365 using a Get & Transform Query
If you have data stored in JSON format that you would like to import into Excel, it’s now very easy and doesn’t require any VBA to import data locally from the disk or from a web API. Watch the video or read the steps below!