Question Re: How to write json data to CSV/Excel? in Technology Q&A

How to write json data to CSV/Excel?

mritunjay_tiwari — Mon, 28 Nov 2022 15:06:02 GMT

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!

Re: How to write json data to CSV/Excel?

yacamo — Tue, 29 Nov 2022 16:18:57 GMT

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

Re: How to write json data to CSV/Excel?

mritunjay_tiwari — Wed, 30 Nov 2022 10:23:10 GMT

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!

Re: How to write json data to CSV/Excel?

Alexia — Mon, 15 May 2023 10:00:42 GMT

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

Re: How to write json data to CSV/Excel?

data-dan — Mon, 12 Feb 2024 20:38:40 GMT

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

Re: How to write json data to CSV/Excel?

rashantha — Tue, 13 Feb 2024 00:20:05 GMT

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.