How to convert JSON to CSV

JSON was dreamed up back in the early 2000s by Douglas Crockford who worked for Yahoo at the time. He wanted to transmit data in the least complicated way. At the time, XML was the most popular transfer format. XML is like an advanced version of HTML and it is indeed powerful - however, it can be a little cumbersome. For example, XML includes some redundant information such as named closing tags which increases the overall length of the data and makes interpretation a little more complicated.

It didn't take long for others to adopt the new "XML alternative" which Douglas constructed. Ajax was starting to become popular at the time. Ajax was all about trying to minimize the transfer of data between the client (web browser) and the server. As JSON was smaller in size, it was readily accepted as a transfer mechanism.

CSV format is a very old method of data representation, however it is still very commonly used across the world. Researchers, scientists, economists, analysts, are very familiar with spreadsheets (Excel or Open Office) and CSV files are best viewed in spreadsheets.