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.

[Alexia]

Did you ever find a solution for this? I'm also interested and would appreciate your feedback.

[data-dan]

For quick conversions of JSON to CSV, use https://www.convertcsv.com/json-to-csv.htm

[yacamo]

Hi mritunjay.tiwari ,

This video may give you a clearer idea of how to perform this process.

Read write CSV JSON XML files

I hope you find it useful,

Greetings

[mritunjay_tiwari]

HI yacamo,

thank you for your time and suggestion!

However, in this video data is coming from CSV while in my case data is coming from json. Normally in other automation tools or say python we have option to convert from json to csv but in this tool we don't have or maybe I am not aware of.

please let me know if you have any solution to covert json data to csv.

Thank you!