How to get things done with JSON files, big and small. Every command and query in these posts was run before it was written down.
A JSON Editor Online alternative for large files
JSON Editor Online saves documents up to 1 MB. GigaJSON opens and keeps JSON files up to 1 GB in your browser, with no ads, account or upload. · 3 min readA JSONLint alternative for large JSON files
JSONLint checks a pasted snippet well. For files of 100 MB to 1 GB, GigaJSON validates and opens them in your browser, with nothing uploaded. · 3 min readConvert JSON to JSON Lines (JSONL) and back
Turn a JSON array into JSON Lines and JSONL back into an array with jq, Python or Node, including files too big to load and lines that won't parse. · 4 min readHow to create a JSON Schema from JSON
Turn example JSON into a JSON Schema, then make it strict: required fields, formats, enums and extra keys. With real generator output and validator errors. · 5 min readUnescape JSON: fix strings full of backslashes
Why JSON ends up as a string full of \" and how to get the data back in JavaScript, Python and jq. Plus what JSON escaping actually requires. · 3 min readJSONPath examples in JavaScript, Python, PostgreSQL and kubectl
The same JSONPath queries run in jsonpath-plus, two Python libraries, PostgreSQL and kubectl, with the real output and the syntax each one needs. · 6 min readWhat is the TOON format? Syntax and examples
TOON (Token-Oriented Object Notation) holds JSON data in fewer tokens. Its four forms, quoting rules, lengths and delimiters, each with a tested example. · 4 min readn8n $json expressions explained: paths, items and $jmespath
What {{ $json.field }} means in n8n, why saved workflows show ={{ }}, how to reach nested and odd keys, other nodes' items, and $jmespath queries. · 5 min readHow to open a JSON file on Windows, Mac, a phone or in Excel
What a JSON file is, and how to open one with Notepad, Notepad++, TextEdit, a browser, VS Code, Excel or a phone. Then read it, edit it, fix errors. · 5 min read · UpdatedJSON vs TOON: token counts measured on six kinds of data
TOON used 32 to 42% fewer tokens than compact JSON on records without list fields, and up to 25% more with one. Measured on 600 records. · 3 min readHow to reduce JSON tokens for AI prompts
A worked example: 270 tokens of JSON down to 127 with TOON and all data kept, then 44 by keeping only the fields the question needs. Free tools, no upload. · 5 min readA JSON Crack alternative for large files: GigaJSON
When GigaJSON is a useful JSON Crack alternative: large files, table browsing, queries and saved history, with practical limits and screenshots. · 5 min readCompare two JSON files: values, key order and saved history
Compare two JSON files and find what changed: values, added and removed keys, arrays. Ignore key order, and compare saved versions of the same file. · 4 min readLarge JSON numbers: preserve 64-bit IDs without silent rounding
JSON.parse rounds integers above 2^53, so long IDs change without an error. When to send them as strings, when BigInt helps, and how to spot rounding. · 4 min readConvert JSON to CSV: nested objects, arrays and Excel gotchas
Turn nested JSON into a CSV that Excel opens correctly: flattening objects, three ways to handle arrays, and keeping leading zeros, long IDs and dates. · 7 min read · UpdatedHow to fix invalid JSON: the 10 most common errors
Trailing commas, single quotes, comments, NaN, cut-off files and JSON from AI chats: what each parser error means and how to fix it, with before and after. · 7 min read · UpdatedHow to open a large JSON file (100 MB to 1 GB) without crashing
Text editors freeze on big JSON files. What opens a 100 MB to 1 GB file instead: jq, ijson, VS Code, and browser viewers, with measured times. · 8 min read · UpdatedHow to view and query API responses and NDJSON logs
Read JSON API responses and JSON Lines logs: curl and jq commands, skipping broken log lines, counting errors, and viewing logs as a table. · 7 min read · Updatedjq vs JSONPath vs JMESPath: the same 8 tasks in all three
The same eight tasks in jq, JSONPath and JMESPath, all tested, with a playground to run them on your JSON. Which one to use, and where each runs out. · 6 min read · Updated