Convert your JSON to CSV or any delimited format with options for quoting, and transposing the final result. The converter can also auto-correct some formatting errors such as missing commas and cases where apostrophes ( ' ) have been used instead of speech marks ( " ).
If you want some sample data to play with, we recommend trying the random JSON generator at ExtendsClass.
Delimiting char:
Wrap values in quotes?