Format HUGE JSON file

Question

I have a huge unformatted JSON file - size is around 2.5G. Is there any tool or way to write script that can help me to format this file into well-readable indented format? I have PC with Intel Core i7 and 16GB memory, so it is more-less that elevated hardware requirement should not be an issue.

Are you really wanting to human read a 2.5GB json file, that could be 3-4GB when formatted ? — xlecoustillier, Mar 22 '16 at 08:31
simple solution [how to format big json file in effective way](https://stackoverflow.com/questions/19875218/best-way-to-format-large-json-file-30-mb) — NIKUNJ PATEL, Feb 22 '23 at 09:19

score 2 · Answer 1 · answered Mar 22 '16 at 08:30

You may try Webstorm. I haven't tried it with such a large file, but Webstorm is able to handle really big files. There is a 30 day trial version, so you may give it a try.

Once you've opened the file in Webstorm click Code-> Reformat Code.

Hope this helps. Cheers!

score 0 · Answer 2 · answered Mar 22 '16 at 08:34

0

My advice is to use Jackson Streaming API. Since it is streaming it will read token by token of your JSON file and will not consume too much memory.

An example of streaming API can be found on this link.

answered Mar 22 '16 at 08:34

Milan

1,780
1
16
29

score -2 · Answer 3 · answered Jul 19 '22 at 15:18

-2

There is an online tool - https://conversiontools.io/convert/format-json which is able to format JSON files of up to 100 GB.

But there are limits for free usage - at the moment of writing it's only possible to convert files (for free) up to 20MB.

answered Jul 19 '22 at 15:18

drdmitry

21
5

Format HUGE JSON file

3 Answers3