JSON to XLSX Conversion Automation using UI Path

[Madhavi (K)]

@Cedrick_Julian
There are two activities available to Deserialize Json. If your Json is already in array structure, you can use deserializeJsonArray activity. Else you have to use DeserializeJson activity. The result of these activities will be JsonArray and Jsonobject respectively.
You have to convert this resultant value to datatable.
Use write range activity to write the datatable in the excel

Please refer-

Activities - Deserialize Json Array

Activities - Deserialize JSON

How to extract the data from Json to Excel

@leewe01 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.