Flatterer

Convert JSON into tablular data. Most common JSON structures will work, so give it a try!
Here is an example converting the noble prize winners JSON API .If you need more flexibility try the python libary/cli.

Why flatterer over other JSON to CSV converters?

One-to-Many relationships are delt with by creating multiple tables instead of a single wide table with lots of headers. This makes analyzing deeply nested JSON structures easier.
The conversions are done in locally in the browser, so the data is not sent to a server.
Fast and can deal with data ~1GB or more of JSON if you have enough RAM.
Lots of options including an XLXS Converter.

JSON Input

File input

Position in JSON:

Object or Array

JSON stream

Array in object

Position where main data array exists.

Key in object of data array

The key in the object where the main array of objects exists.

Main Table Name

Table name that represents main data array in input. Defaults to `main`.

Inline arrays with only single item

Table Prefix

Text prefixed to all output table names. Defaults to no prefix.

Path Separator

Separator between each part of the output field and table name. Defaults to `_`.

Pushdown

Field to pushdown to child tables

fields.csv file

Only output fields in file

tables.csv file

Only output tables in file