Course Content

Total learning: 7 lessons Time: 10 weeks

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.

  1. Simply copy the JSON text response.
  2. Paste it into the tool.
  3. Click Convert
  4. Download the results as an Excel file.

Convertcsv is not a Mediasite supported platform. Please check with you IT team before using.

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.

Was this Information helpful?