Articles
What is JSON? Full form, syntax rules and examples
JSON stands for JavaScript Object Notation. Learn its six data types, the syntax rules that cause most errors, and how to read JSON in JavaScript, Python, Java.
How to open a JSON file in Excel
Three ways to get JSON into Excel: Power Query's From JSON import, converting JSON to an .xlsx file online, or JSON to CSV. With tips for nested data.
What is a JWT? JSON Web Tokens explained
JWT stands for JSON Web Token. See how the header, payload and signature work, what claims like exp and aud mean, and how to decode a token safely.
JSON Schema validation: a practical guide
How to validate JSON with JSON Schema draft 2020-12: types, required fields, strings, numbers, arrays, conditional rules, $defs and $ref, with examples.
XML to JSON conversion: the decisions that matter
XML and JSON don't map one to one. How to handle attributes, text, repeated elements, data types and namespaces when converting XML to JSON, with examples.
Working with large JSON files
Practical ways to handle large JSON: when JSON.parse is fine, streaming in Node.js and Python, Web Workers in the browser, NDJSON and compression.