{"id":359,"date":"2016-07-14T10:39:31","date_gmt":"2016-07-14T00:39:31","guid":{"rendered":"http:\/\/chuchuva.com\/pavel\/?p=359"},"modified":"2016-07-19T15:03:36","modified_gmt":"2016-07-19T05:03:36","slug":"how-to-view-large-json-files-on-windows","status":"publish","type":"post","link":"https:\/\/chuchuva.com\/pavel\/2016\/07\/how-to-view-large-json-files-on-windows\/","title":{"rendered":"How to View Large JSON Files on Windows"},"content":{"rendered":"

Let’s say you need to view a huge (more than 1 GB) JSON file. Of course you are not going to view so much data, it’s humanly impossible. What you want to do is to get a general understanding of JSON structure.<\/p>\n

I assume that JSON document is already properly formatted.<\/p>\n

First of all we will copy first 10,000 lines to a new file. We will user PowerShell for that:<\/p>\n

<\/p>\n

Get-Content large.json -TotalCount 10000 | Out-File truncated.json<\/pre>\n
<\/code><\/p>\n
Next, open truncated.json in Sublime Text Editor<\/a> and scroll to the end:
\n\"sublime-truncated-json\"<\/p>\n
The JSON is not valid right now. Let’s make it valid by closing all ‘[<\/code>‘ and ‘{<\/code>‘ brackets. Sublime Text has a great feature that highlights invalid JSON code:
\n\"sublime-invalid-json-highlighted\"<\/p>\n
All you need to do is to try to add brackets alternating between ‘[<\/code>‘ and ‘{<\/code>‘ until you reach the first column:
\n\"sublime-valid-json\"<\/p>\n
Now you can save the file and open it in JSON Viewer<\/a>. Since the new file is small you should have no problems viewing it as tree:
\n\"json-viewer\"<\/a><\/p>\n
By the way, I’m thinking of building a tool that would automate this process – leave a comment if you’re interested in learning more.<\/p>\n","protected":false},"excerpt":{"rendered":"
Let’s say you need to view a huge (more than 1 GB) JSON file. Of course you are not going to view so much data, it’s humanly impossible. What you want to do is to get a general understanding of JSON structure. I assume that JSON document is already properly formatted. First of all we … Continue reading How to View Large JSON Files on Windows<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[7],"tags":[33],"class_list":["post-359","post","type-post","status-publish","format-standard","hentry","category-software","tag-json"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/chuchuva.com\/pavel\/wp-json\/wp\/v2\/posts\/359","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chuchuva.com\/pavel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/chuchuva.com\/pavel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/chuchuva.com\/pavel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/chuchuva.com\/pavel\/wp-json\/wp\/v2\/comments?post=359"}],"version-history":[{"count":0,"href":"https:\/\/chuchuva.com\/pavel\/wp-json\/wp\/v2\/posts\/359\/revisions"}],"wp:attachment":[{"href":"https:\/\/chuchuva.com\/pavel\/wp-json\/wp\/v2\/media?parent=359"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/chuchuva.com\/pavel\/wp-json\/wp\/v2\/categories?post=359"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chuchuva.com\/pavel\/wp-json\/wp\/v2\/tags?post=359"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}