How to extract the data from Json to Excel

Use DeserializeJson activity and convert the json string to json object(jsonResult).
Loop through the array node in the json result. (jsonResult(“data”)
Add values of each array item into a datatable.
Once all the records are processed, Use write range activity to write into excel file.