Data Formats7 min read
How to Convert JSON to CSV: Steps, Code and Common Pitfalls
How to convert JSON to CSV with a free converter, JavaScript or Python, how nested objects, big IDs and Excel behave, tested on one real example.
Data Formats
JSON, CSV, YAML, XML, SQL and Markdown each have their own rules and their own ways to break. These guides show how to read, format, convert and repair them, explain the errors you are most likely to see, and link to tools that do the work in your browser.
Data Formats8 min read
JSON vs YAML: Differences, Examples and When to Use Each
JSON vs YAML explained with the same config in both formats, a size and speed test, the yes and no trap, and free converters to switch between them.
Data Formats7 min read
HTML Entities: The Common List, Syntax and When You Need Them
HTML entities explained: the three forms, the five characters you must escape, a list of common ones, the missing semicolon trap and a free encoder and decoder.
Data Formats7 min read
How to Make a Hyperlink: HTML, Markdown, Word, Docs and Email
How to make a hyperlink in HTML, Markdown, Word, Google Docs and email, with copy-ready code, link text that works and the mistakes that break links.