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.
TABLE OF CONTENTS
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: