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.
- Convert JSON to CSV: nested objects, arrays and Excel gotchasTurn 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
- How to fix invalid JSON: the 10 most common errorsTrailing 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
- How to open a large JSON file (100 MB to 1 GB) without crashingWhy editors freeze on big JSON files, and what works instead: jq, streaming parsers like ijson, VS Code's limits, and browser tools. Measured trade-offs. · 7 min read
- How to view and query API responses and NDJSON logsRead 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
- jq vs JSONPath vs JMESPath: the same 8 tasks in all threeWhich JSON query language to use, shown with eight tasks solved in jq, JSONPath and JMESPath side by side. Tested queries, plus where each one runs out. · 6 min read