How can I bulk edit this code?

{"@context":“http://schema.org/","@type":“LocalBusiness”,“name”:"",“image”:"",“description”:"",“address”:{“addressLocality”:"",“streetAddress”:""},“aggregateRating”:{"@type":“aggregateRating”,“ratingValue”:“0”,“reviewCount”:“0”,“bestRating”:“5”,“worstRating”:“1”},“review”:"",“geo”:{"@type":“GeoCoordinates”,“latitude”:"",“longitude”:""},“sameAs”:"",“telephone”:"",“photos”:"",“priceRange”:"",“email”:"”}

스크린샷 2021-04-22 18.59.52
How can I bulk edit this kind of code??
I want bulk import and export this data on cvs file. but I could not find some editor or program for easy way.

I need help some information. Thank you

1 Like

That looks like JSON, you’ll need a JSON parser for the programming language of your choice, and then a CSV writer. For example in Python you could use the built-in json and csv modules.

2 Likes

in addition to @airtower-luna’s great info, these sort of things often have online tools available for one-offs. Searching “JSON to CSV converter online” in the search engine of your choice should result in some sites that do the conversion for you. Sometimes there are limitations on these tools for complex input but I think in this case you should have good results.

1 Like

@airtower-luna @billythekid Thank you so much for your information really helpful for me.