3

I'm looking for a software that can load a JSON file and show it like a spreadsheet with the option to search and filter the data. Editing and saving are optional, but would be great as well.

Easiest would be to just use LibreOffice Calc, but it can't import (let export) JSON.

Does anyone know a stand-alone tool for this use case or a way to get JSON into (and out of) Calc without complicated extra steps?

Fred
  • 220
  • My best find so far is https://jsoneditoronline.org, but I'd prefer a software that I can run locally without the need to be connected to the internet or to upload data to some online platform. – Fred Aug 31 '24 at 16:20
  • did you explore any of [these suggestions]https://www.linuxlinks.com/best-free-open-source-json-tools/)? – graham Aug 31 '24 at 16:36
  • https://github.com/jspreadsheet/ce – JayCravens Aug 31 '24 at 17:24

3 Answers3

1

Personally I use this tool to convert my JSON to CSV. Then, CSV can be used as normal with LibreOffice Calc, Google Sheets, or Microsoft Excel.

superuser
  • 111
  • 1
1

The mentioned Visual Studio Code or similar multi-functional editors or IDEs may not handle or crash even while processing JSON files of sizes bigger enough, like more than 500 MiB.

Sublime Text will handle quite big files in JSON at least for viewing.

But still, both are not a solution to the question, I believe. Those are full-blown multi-functional editors and sure not specifically oriented on data editing as JSON, YAML, CSV, or alike, predominantly, but just feature an additional support for relatively small files.

Therefore, have you considered standalone software, like the following?

Graphical User Interface (GUI)

Janice

A desktop app for viewing large JSON files...

What is the largest JSON file that I can load?

The largest JSON file you can load on your computer depends mainly on how much RAM you have and on the particular JSON file. The main driver for memory consumption is the number of elements in a JSON document.

For comparison we did a load test on one of our developer notebooks. It has 8 GB RAM and runs Ubuntu 22.04 LTS. We were able to load a JSON files successfully with up to 45 million elements. The size of our test file was about 2.5 GB.

Source

Janice Preview

Text User Interface (TUI)

FX

Fx is a CLI for JSON: it shows JSON interactively in your terminal, and lets you transform JSON with JavaScript. Fx is written in Go and uses goja as its embedded JavaScript engine.

Source

Fx Preview
Serious Angel
  • 256
0

You may want to try using Visual Studio Code or VSCodium with the Table Editor or JSON Table Editor extensions.

Ventolinmono
  • 221
  • JSON Table Editor looks exactly like what I'm looking for. Thanks a lot for the suggestion! – Fred Feb 13 '25 at 19:13
  • 1
    @Fred I'm glad it helps. – Ventolinmono Feb 13 '25 at 21:01
  • Just in case, VS Code may not handle or crash even while processing JSON files of sizes bigger than 500 MiB, where Sublime Text will handle it at least for viewing. But still, it is not a solution to the question, I believe, including both as full-blown multi-functional editors and sure not specifically oriented on data editing as JSON, YAML, CSV, or alike, but just as an additional support for small files. At this point, I am sorry, but you might list all the most common and popular text editors out there, including neovim or nano even. – Serious Angel Aug 25 '25 at 10:47