JSON Crack – Visualize JSON data into graphs (opens in new tab)

If you indent your code manually then you can achieve something that I feel looks quite similar. So the example they give would be written as:

    {"squadName":  "Super hero squad",
     "homeTown":   "Metro City",
     "formed":     2016,
     "secretBase": "Super tower",
     "active":     true,
     "members":    [{"name":           "Molecule Man",
                     "age":            29,
                     "secretIdentity": "Dan Jukes",
                     "powers":         ["Radiation resistance",
                                        "Turning tiny",
                                        "Radiation blast"]},
                    {"name":           "Madame Uppercut",
                     "age":            39,
                     "secretIdentity": "Jane Wilson",
                     "powers":         ["Million tonne punch",
                                        "Damage resistance",
                                        "Superhuman reflexes"]},
                    {"name":           "Eternal Flame",
                     "age":            1000000,
                     "secretIdentity": "Unknown",
                     "powers":         ["Immortality",
                                        "Heat Immunity",
                                        "Inferno",
                                        "Teleportation",
                                        "Interdimensional travel"]}]}

I've been doing with Clojure/EDN data and I feel it makes it much easier to visually parse.

PS: Does anyone knows if there was an emacs mode that'd do this for me automagically?

Cool. PlantUML also does JSON visualization [1] if you need a local option or are hesitant to load your data onto a website.

[1] https://plantuml.com/json

Looks good. Unfortunately most JSON (I personally handle) contains private information and I would never paste it into a web page.

The arrays are not presented correctly. Each element in the array points to the parent, rather than being grouped together. Ditto for Objects (key/value pairs).

Since JSON is just a simple tree structure without cycles, the JSON "visualization" doesn't buy you much that indented text formatting can't already give you.

Note: when browsing on mobile it isn't obvious that there are examples, the tweet from github isnt obvious that it is an example and the interactive graph doesnt look like one because it zooms into blank space

although I have a desktop and do development there, my interest in a new tool is frequently is sparked by my casual browsing on mobile, there might be (many) others like me

Once I was working with an api that used mongodb in the back. Mongo uses very large integers as ids and I was looking at the json generated through a json viewer extension in the browser. I was having problems because I couldn't find the document I was looking at in the database. Turns out, the viewer used the browser's JSON.parse and that was converting the id to a number and losing precision since it was so large. Ever since, I prefer to look at json raw first and then use formatters just to look at the shape, not the data.

For working with JSON from terminal recommend: https://fx.wtf

Personally I've never had a problem reading through json, I mean its designed that way to be flat and simple, but this could be brilliant for documentation, even auto updating with some schema changes etc.

Super useful for me in that way so thanks!

Ideally this is something that could run locally but it looks great thank you!

I wish these kind of projects would show up when searching "Online JSON visualization". Current SEO logic means that website like this have pretty much no chance of making it. Would love to be proven wrong though!

This looks like a neat tool, but without the ability to collapse and expand most sections, it's only useful for trivially small JSON files :/

You guys will love this also

https://jsonhero.io

I am curious, who needs to visualise these datas? What I am interested in is validation. it's the same as with XML, or any transitional data formats, if I need to fix something I work on a specific set of the data and make sure that it is valid. If it is not I fix it. If I want to visualize data I use it at the endpoints, ie. in Excel or in PowerBI.

this might be a good place to ask: is there any tool out there that can help with json to normalised tables?

I know that many databases can store json, but i often have api's that i would like storing in tables, and feel that 'splitting it out' should be fairly trivial.

Each time i think about making a tool, i am put off by the fact that there is a voice saying 'someone will have done this, in a much better way than you!' :-)

EDIT:

Ignore that, i did that think where i didn't look at the link - this pretty much does what i would need

There’s a message saying “incompatible device”. I’m using an iPhone.

Opening on iOS I see an "Incompatible Device" notice on the page. Does the demo only work on desktop?

Looks good.

Slight quibble, JSON with large value fields (eg: 4K text as a single line) blow out the containing box dimensions in the web visualiser.

Maybe there's a flag to clip | wrap such values, if so I missed ny option to toggle it.

( I used MediaInfoCLI --output=JSON on some multitrack files from handbrake, the encode argument flags are a single large value )

This is pretty awesome. I wonder how this scales. Like if I wanted to visualize a graph with millions of nodes, would it make sense to copy a whole JSON blob into it?

One of my side projects is called GraphJSON (https://graphjson.com), where we took the opposite approach. Log events (kind of like nodes in your graph) in a segment/mixpanel/amplitude way and then use SQL to stitch these events together. Currently it just does basic visualizations like lines and tables, but it'd be awesome to do the flow charts you've created. Perhaps there's opportunity for partnership?

Having an extra box for nested fields is somewhat annoying and space wasting, I think. Can that be switched on/off? From a drawing perspective it is easier, but it seems it should be possible to do away with the extra box.

I've been looking for something visual like this that can generate JSON Schemas. You would be able to visit any "node", right-click, and specify the constraints you're looking to add to the schema...

Looks like a cool project and I love that it is open source.

But naming a graph visualization tool using the same word as the Microsoft Flowchart visualization tool would make me somewhat nervous since it can cause "brand confusion." Granted I can't find a trademark listed for Visio specifically (maybe the name is too generic) so may be all good.

Cool, but when I loaded something that would help to visualize (a trace of a single block of ethereum) it just died. The JSON is 374KB.

why is it its own app? is it available a vscode/jupyter plugin?

Probably just me, but the "members" and "powers" arrays in the example should be in the same box as their siblings. When presented in another box joined with arrow, to me it seems to introduce hierarchy that isn't there. Probably I'm unaware of some convention used here.

This looks like it might he useful for migrating pre-typescript code to Typescript. Identifying permutations of otherwise similar objects can be a pain, and sometimes similar APIs will return fields that have the same property name but only contain a small subset of data.

Pedantry - I clicked on the link wondering how it would represent cycles in the JSON, then I found it is a tree. Should the strap line be changed to "Visualize JSON data into trees" :).

I get "Incompatible device" error on Huawei P30 Pro, a very good smartphone.

There's also this tool we built a while ago to break down JSON size by key. https://www.debugbear.com/json-size-analyzer

That's really cool. One change would be for nested structures I wouldn't put and arrow but have it be a property with the rest of the properties that then has an arrow to the contents.

Something that I am currently struggling at my job is how can I automatically convert everything in a JSON into a table. I'm writing my own "macros" to deal with it but it's far from ideal yet.

You may also find Graphize interesting https://apvarun.github.io/graphize/

i think similarly, this db will tx arbitrary json and let you query it.

https://github.com/quoll/asami

Very cool! This is close to being a perfect mind-map creation tool. Text wrapping would be nice. It can be done manually by adding \n, but that has to be done manually.

Is anyone aware of a good desktop application for visually exploring a JSON data set and running queries?

I've found good online tools, but not a good desktop app.

This is a very good one for understanding API results, so you can debug what the properties are. For bigger ones, we are working on Dadroit Viewer.

Neat-o, I'll give this a whirl next week, will definitely help parsing the garbage used in Airflow config files I'm always debugging.

As someone that works with complex json objects on an almost daily basis, this looks like it will become part of my daily toolkit - nice job.

I was expecting a JSON-to-DOT transformer and a new graphviz backend (if that's at all necessary).

Uses https://reaflow.dev

It looks like the natural evolution of tools like jsonviewer.stack.hu

Could someone point what it uses to draw the tree chart?

Excellent tool for developers, I use it all the time

This is really cool! Looks great.

What is the use case for this?

This will be the first project that I will be sponsoring...

Where has this been for all this time.

Very nice

very nice. thank you!

Cool tool, thanks for sharing. Would be great to have a version as a VS Code extension, imagine using it directly inside VS Code <3

I thought this was a new feature in Microsoft Visio initially. Would “JSON Visio” be a breach of their trademark?

https://trademarks.justia.com/742/75/visio-74275413.html