Converting a JSON Response
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.
Certain versions of Microsoft Excel have the ability to import a JSON file as a data source and can convert that data into a table format.