DEV Community

Is there any tool available for JSON where I can manipulate JSON data in various way?

codegirl on April 15, 2024

Hey, fellow devs!

Suppose I have a large JSON data, and I want to view my JSON data as a tree structure or a tabular form for instance.

There are some tools available, but not so useful, can you guys please share links for JSON visualization?

Collapse
 
hebaishi profile image
Husam Hebaishi

How about jq

Collapse
 
farrellit profile image
Dan Farrell

This is the way

Collapse
 
lieutdan13 profile image
Dan Schaefer

This is the way

Thread Thread
 
quintisimo profile image
Quintus Cardozo

This is the way

Collapse
 
bugblitz98 profile image
Bug Blitz

Hey, I think I know what you want with your JSON, there is a JSON tool I can suggest, jsonviewer.tools/
This is one of the light weight tool without any ads and it is absolutely free. You can go for it.

Collapse
 
markdebug profile image
thinkstop

There nice tools,Thank for you sharing.

Collapse
 
codegirl0101 profile image
codegirl

This tool makes sense, I can view my complex json in every way possible. Thank ya

Collapse
 
tracygjg profile image
Tracy Gilmore

Have you tried Jsonata?
jsonata.org/

Collapse
 
jmfayard profile image
Jean-Michel 🕵🏻‍♂️ Fayard

This looks amazing, thanks !

Collapse
 
deveshanand18 profile image
Devesh Anand Srivastava

Jsonata basically has every JSON related solutions one can imagine

Collapse
 
ayeshlk profile image
Ayesh Almeida

Are you familiar with Ballerina-lang [1], a programming language specifically designed for integration purposes? Ballerina offers comprehensive support for working with JSON data, making it easy to manipulate JSON payloads in various ways.

Furthermore, with the introduction of the data.json package in Ballerina version 2201.9.0, manipulating JSON payloads has become even more flexible and convenient. This package provides additional functionalities and utilities tailored specifically for working with JSON data, allowing you to handle complex JSON structures with ease.

As for manipulating large JSON data, Ballerina offers data projection where you can selectively convert the required fields by omitting the unwanted data. An example demonstrating data projection can be found in the Ballerina by Example (BBE) repository [2].

To learn more about how Ballerina simplifies JSON manipulation, you can explore the official Ballerina documentation on JSON support [3]. Additionally, you can refer to the data.json package documentation on GitHub [4] for detailed information on its usage and capabilities.

[1] - ballerina.io
[2] - github.com/ballerina-platform/ball...
[3] - ballerina.io/learn/by-example/json...
[4] - github.com/ballerina-platform/modu...

Collapse
 
thadguidry profile image
Thad Guidry

openrefine.org can import JSON and visualize, and transform it, and export it. Feel free to DM me on X.com if you need help.

Or Notepad++ and using it's Plugins Admin, you can install the JsonTools plugin.

Also OjG at ohler.com/ who is an amazing coder.

Collapse
 
lnahrf profile image
Lev N.

JSON is Javascript so you can just format it in a .json/.js file and do whatever you need.

Collapse
 
pictus profile image
Michael
Collapse
 
byihta profile image
Byihta

jqlang.github.io/jq/

jq is a cli tool for json manipulation

Collapse
 
imashwani profile image
Ashwani Singh

Use jsoncrack tool,
Will help you for the desired results

Collapse
 
schalkneethling profile image
Schalk Neethling

Hey, @codegirl0101 - have a look at the tools at this link:
developer-toolchest.com/?q=json

I hope this helps!

Collapse
 
siddicky profile image
siddicky

Also worth checking Json Crack

Collapse
 
eliazer_braun_2b427f370f4 profile image
Eliazer Braun
Collapse
 
hps8891 profile image
hps8891
Collapse
 
vikasdhakad profile image
vikasdhakad

I think I know what you want with your JSON, there is a JSON tool I can suggest

This Tool 100% Solve your problem
ovdss.com/apps/json-view-online

Collapse
 
codegirl0101 profile image
codegirl

Thank you so much

Collapse
 
yiddytlq profile image
Yiddy

I find myself building all kinds of tools for my specific needs each time and just host them locally

Collapse
 
codegirl0101 profile image
codegirl

that's amazing

Collapse
 
mooseface profile image
Andy • Edited

jsonviewer.co.uk/ I made this a while ago, you can drag drop your large JSON file into the raw tab or just paste it in there

Collapse
 
jpjitendrapal profile image
Jitendra Kumar Pal

This is one of the best one
jsonblob.com/

Collapse
 
zaidalig profile image
zaidalig

conversiontab.com/json-viewer
Have a look at this, here you can explore different features for deleting, updating fields for json and view in interactive manner

Collapse
 
efpage profile image
Eckehard

This might be an option for you. Though JSON is well supported by Javascript, JSONpath offers a different way to manipulate JSON data

jsonpath.com/

See this documentation also

Collapse
 
felsesser profile image
Frank Elsesser

Notepad ++
Query/editing tool for JSON including linting, reformatting, a tree viewer with file navigation, JSON schema validation and generation, escaping/unescaping strings, and much more.

The tree viewer can also be used to explore CSV files and regex search results (experimental).

Author: Mark Johnston Olson

Homepage: github.com/molsonkiko/JsonToolsNpp...

 

Collapse
 
stevezivalich profile image
Steve Zivalich

You can look at jSon in VScode, can't remember if it is native or I added an extension.

Collapse
 
deveshanand18 profile image
Devesh Anand Srivastava

Jsonata. It's so good that you can't ignore it. We use it at production level at gocobalt.io

Collapse
 
codegirl0101 profile image
codegirl

cool

Collapse
 
arenishr profile image
Abdul Renish R
Collapse
 
codegirl0101 profile image
codegirl • Edited

Thank you, saviors, all the tools you guys suggested are awesome, I am opting for this jsonviewer.tools/ tool, as suggested by dev.to/bugblitz98 for visualizing my data.

Collapse
 
jeffzone profile image
jeff-zone

Python or jq