How to process JSON data in Excel

The AlisQI API returns results in JSON format. The videos below show how to receive and process this JSON data in Excel.

Step 1: Fetch JSON data from an URL in Excel

The method used in above video does not always work correctly. In that case try: How to call Alis API and process JSON data in Excel

Step 2: Process JSON in Excel