If you're using Mac, try Hex Fiend. Loads large files super fast. Just disable the hex view and you'll get a regular-ish editor.
Answer from captain on Stack OverflowI have a full text + summary dataset that I'm using to train T5 - I have the data in both csv and json formats. I have to manually go over many of the entries, do edits, remove sentences from the summaries etc, but doing it in Calc/Sheets is a pain. Are there any open source/free trial GUI tools to easily edit text data row by row/entry by entry in json lists/dicts?
want to view a huge .json file (to be precise, .jsonl) in read-only mode(if possible). A write stream to that file hasn't been closed yet, and a process running on my pc is constantly writing to it. I tried sublime text to open the file, but it seems to force a refresh every time whenever a chunk is written to the .jsonl. In contrast, vsc doesn't refresh as long as I keep focus.
I'm not trying to edit it literally, so it would be nice if it was optimized for read-only.
I have written Huge JSON viewer based on JSON.NET, one of the fastest JSON frameworks. It matches the requirements as follows:
- open decently large files: it can open the 1.44 GB example file without crashing in ~ 2:45 minutes on my machine (Intel Core i7, 16 GB RAM, SSD). To do that, the OS must be 64 bit. A progress bar is shown
- has a decently responsive UI: I use a commercial tree view from DevExpress which I hope is optimized very well.
- can collapse/expand a given level: it is a full tree view and can expand/collapse any nodes. It has a feature to expand to a given level
- works off-line: it's a Windows desktop application. Needs .NET
- provide some statistics on the JSON content: some. Can definitely be improved.
- tabs: yes.
- gratis: yes. MIT license, but closed source.
- displays the filename somewhere: yes, in the tab
The only thing it can definitely not (but was optional):
- "can edit JSON data"
Additional features:
- search capability
- performance warning when memory swapping to disk is expected
System requirements:
- Windows 7 SP1 or higher, x64 bit recommended
- Physical RAM roughly 7 times the file size to be opened
- .NET 4.5
Watch out the list of known issues until it's out of beta phase.
Screenshots:
Download (including portable version): https://github.com/WelliSolutions/HugeJsonViewer#releases
Disclaimer: I am the author of this software.
I'm using JSONedit, typically with 1-2MB of text. Largest data sets I've tested were around 50MB and it's annoyingly slow with loading it and peak RAM usage reaches few hundreds MB - there is definitely room for improvement, but it's at least order of magnitude better than browser-based editors I've tested. It seems to meet most of your requirements except tabs and I don't know what you mean by statistics - JSONedit can count nodes by type or count total length of strings for memory usage estimation for DOM-style parsers, maybe this is sufficient).
It can show node statistics:
