How does Gigasheet Analyze JSON Files?

Modified on Thu, 25 Apr at 1:50 PM

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:

 




Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article