Whilst I am relatively proficient in using Excel, I have never worked with external data sources using queries and connections. I am trying to set up a spreadsheet that works with the Mapbox API and need some help using the imported data. I have managed to set up a query to the API using the Get Data > From Web etc, which I believe has captured the returned data in JSON format. I just don't know where to go from here to start utilising the data in my spreadsheet.
Can anybody suggest any tutorials that I can work through to get an understanding of how this all works?
Can anybody suggest any tutorials that I can work through to get an understanding of how this all works?