JSON files tend to be big so they can be incredibly difficult to analyze on a local machine. With Gigasheet, you can upload various types of JSON files to analyze, sort, filter, and export data. This requires no coding, no databases, and no downloading. 

Note: If you are looking upload a file, please visit this article.


Contents of JSON Files

JSON file has a few key features which allow us to identify the number of sheets, values, rows, and columns. Here you can see the following parts of the JSON file: 

Metadata: Overall information of the JSON file. Some JSON files do not contain metadata.

Array of Objects: The various objects that are separated by [ and ]. Here we can see the main objects are "batter" and "toppings". A specific object will have it's own sheet in Gigasheet. Some JSON files only have one object, so only one sheet will populate

Keys: Keys are the defining columns within Gigasheet. In sheet 2, we see this it "id" and "type" 

Values: Values are attached with the keys. In sheet 2, you can see the corresponding value to the "id" key are values "1001-1004".

Let's take a look how a JSON file appears in Gigasheet.

JSON into Gigasheet

Once a JSON file is into Gigasheet, it may be parsed into multiple sheets depending on the number of objects within the native JSON file. It is possible to have a single sheet, but it is not unlikely to have multiple: 

Each sheet will contain the object keys and values that are separated by commas: