JSON is a data format that is easy for a machine to work with, but sometimes it is not the easiest for a human to work with directly. For many JSON responses, you might be able to work with it more easily if you could convert it into a spreadsheet. To convert there are several tools available. One such options is https://www.convertcsv.com/json-to-csv.htm.
- Simply copy the JSON text response.
- Paste it into the tool.
- Click Convert
- Download the results as an Excel file.