Developer data guides
Practical explanations of JSON, CSV, YAML, TypeScript and SQL data problems: what goes wrong, why it happens and how to fix it.
Common JSON syntax errors and how to fix them
Trailing commas, single quotes, comments and other mistakes that make JSON invalid, with corrected examples and tips for finding the error quickly.
Read guide ↗How to convert nested JSON to CSV
Three ways to turn nested JSON objects and arrays into CSV or Excel: keep JSON in cells, flatten with dotted columns, or split arrays into linked tables.
Read guide ↗JSON vs YAML: differences and when to use each
A practical comparison of JSON and YAML for configuration files and data exchange, covering syntax, comments, types, tooling and common mistakes.
Read guide ↗YAML gotchas: implicit types, indentation and the Norway problem
The YAML mistakes that silently change your data, including unquoted booleans, version numbers, leading zeros, indentation errors and duplicate keys.
Read guide ↗Generating TypeScript types from JSON
How to turn a JSON API response into TypeScript types, what a single sample cannot tell you, and how to combine types with runtime validation.
Read guide ↗How to compare two JSON documents
Why text diffs are misleading for JSON, how a structural diff reports added, removed and changed values, and how to handle reordered arrays.
Read guide ↗Importing CSV into a SQL database
How to load CSV data into PostgreSQL, MySQL, SQLite or SQL Server with INSERT statements or bulk loaders, and how to avoid type, NULL and encoding errors.
Read guide ↗CSV pitfalls every developer should know
Why CSV files break between applications, covering quoting rules, delimiters, line breaks, UTF-8 and BOMs, spreadsheet type guessing and CSV formula injection.
Read guide ↗