StackOverflow and its kin have a good set of references on this topic. Note that CSV can manage only very simple JSON; we really want native importers similar to what Microsoft Access tried with XML . I suspect one approach might be to convert JSON to XML then use Microsoft Access 2010 import.
Incidentally, this topic veered off unexpectedly into something that's actually relevant to my work life and a Strata conference I'm attending in a few weeks.
As of today here are some of my pointers ...
- What is “JSON” and what does it have to do with distributed computing? « DivConq: great reference (see below for DivConq series on Access)
- JSON - Wikipedia, the free encyclopedia: I liked the comparison to XML 
- JSON.org: points to libraries
- convert from json to csv using python - Stack Overflow
- Download JSON data and convert it to CSV using Python - Stack Overflow
- python - Convert JSON to CSV - Stack Overflow
For me this DivConq series was particularly useful because it placed JSON nosql processing in a familiar context - Microsoft Access.
- What is “JSON” and what does it have to do with distributed computing? « DivConq: best single reference for my purposes
- Export a Microsoft Access Database to JSON (Northwind Example) « DivConq
- Why Cassandra « DivConq
- Installing and Running the Cassandra Database « DivConq
- Migrate a Relational Database Structure into a NoSQL Cassandra Structure (Part I) « DivConq
- Migrate a Relational Database into Cassandra (Part II – Northwind Planning) « DivConq
- Migrate a Relational Database into Cassandra (Part III – Northwind Conversion) « DivConq
- Migrate a Relational Database into Cassandra (Part IV – Northwind Import) « DivConq
Maybe I should start using Apache Cassandra to manipulate my Google Reader JSON archive and prepare it for WordPress processing. For example ... Cassandra Development Environment in Mac OS Snow Leopard « BigDiver.
 I doubt JSON has truly significant advantages over XML as a data interchange format (see JSON Example and wikipedia xml/json). Alas, nobody asked me. Fashion is more powerful than geeks imagine.