Guides
Practical, no-fluff tutorials for working with JSON, CSV and Excel data, from fixing errors to opening huge files.
How to Open Large JSON Files (100 MB and Bigger)Why big files freeze editors, and what works instead.Unexpected Token in JSON: What It Means and How to Fix ItThe most common JSON.parse errors, explained.9 Common JSON Syntax Errors and How to Fix ThemTrailing commas, quotes, comments and more.How to Convert Nested JSON to CSV (and Open It in Excel)Flatten objects and arrays into spreadsheet columns.How to Clean a Messy CSV File: Duplicates, Spaces and Empty RowsA checklist for tidy, import-ready CSV data.Why Your CSV Opens in One Column in Excel (and How to Fix It)Delimiter and encoding problems, solved.JSONPath Tutorial: Syntax and ExamplesQuery JSON with $, .., [*] and filters.JSON vs YAML: Differences and When to Use EachSyntax, pitfalls and when to pick which.How to Pretty Print JSON (Browser, Command Line, Python, JavaScript)Format JSON online, in code and in the terminal.How to Decode a JWT and Read Its ClaimsHeader, payload, claims and safety tips.How to Generate TypeScript Types from JSONInterfaces from sample data, done right.How to Compare Two JSON FilesStructural diff vs text diff, with examples.