How to write json data to CSV/Excel?

[mritunjay_tiwari]

Dear All,

I am looking for a solution where I have a json file and I want it to convert in CSV. There is an activity readjson which returns a collection or data but I am not sure how to covert that into csv.

I am new to this platform and will be really great any of you can help me on this.

Thank you in advance!

[rashantha]

Save your JSON make sure it's clean.

Open Excel and go to the Data Tab > Get Data > From JSON.

If your using PowerAutomate you can also convert JSON to CSV.