What is JSON?
The format the web runs on. Nested objects and arrays, real types, and a syntax small enough to fit on a postcard. It maps badly onto a grid, which is why converting deeply nested JSON to a spreadsheet always involves losing something.
What is CSV?
The least glamorous and most durable data format there is: rows of values separated by commas, readable by every spreadsheet and database ever written. All its subtlety is in quoting - a value with a comma in it has to be wrapped in quotes, and a quote inside that has to be doubled.