Data Tools Learning Hub
Guides and explainers for Data Tools tools
Filter By Popular Topics
Guides
15 guidesHow to Format SQL: A Guide to Readable, Reviewable Queries
Learn why SQL formatting matters, the conventions that make queries readable — clause-per-line, keyword casing, indentation — and how a formatter re-indents your SQL without changing what it does.
25 Jun 2026
5 min read
TOML to JSON: A Complete Guide to the Format and How to Convert It
Everything you need to know about TOML — its syntax, design philosophy, type system, and how to convert TOML to JSON reliably in Python, Go, and JavaScript.
25 Jun 2026
5 min read
TOML vs YAML vs JSON: Which Config Format Should You Use?
A thorough feature-by-feature comparison of TOML, YAML, and JSON for configuration files — covering comments, type systems, date support, footguns, and real-world use cases.
25 Jun 2026
5 min read
YAML to JSON: A Practical Conversion Guide
How YAML maps to JSON, why scalar typing and indentation matter, and how to convert config files cleanly — with worked examples for block mappings, sequences, and flow collections.
25 Jun 2026
5 min read
Converting HTML Documents to Markdown Files
A practical guide to converting whole HTML documents into committable Markdown files — frontmatter, file downloads, batch migration, and what to check afterward.
24 Jun 2026
5 min read
How JSON Diffing Works: Paths, Deep Compare and Edge Cases
Understand how a JSON diff compares two documents — matching objects by key and arrays by index, building paths to each change, and handling type changes and ordering.
24 Jun 2026
5 min read
JSON to TypeScript: How Type Inference Works
Learn how a JSON sample becomes TypeScript interfaces — how types are inferred, how nested objects and arrays are handled, and the edge cases to watch for.
24 Jun 2026
5 min read
JSON vs YAML: When to Use Each and How to Convert
Understand the real differences between JSON and YAML, when each format fits, and how a converter turns JSON into clean, round-trip-safe YAML without quoting bugs.
24 Jun 2026
5 min read
How Binary Represents Text: ASCII, UTF-8 and Bits
Understand how computers turn letters into bits, the difference between ASCII and UTF-8, why bytes are 8 bits, and how to convert binary to text and back.
23 Jun 2026
5 min read
CSV Format Explained: Delimiters, Quoting, and Common Errors
A complete guide to the CSV format and RFC 4180 — how delimiters and quoting work, the most common ways CSV files break, how to read validation errors, and how to validate a file before importing.
23 Jun 2026
5 min read
How to Use CSV to JSON — Complete Guide
Learn how to convert CSV data to structured JSON using the free CSV to JSON tool on Tools.Town — with type inference, nested flattening, and multiple output modes.
7 May 2026
5 min read
How to Use JSON to CSV — Complete Guide
Learn how to convert JSON arrays to spreadsheet-ready CSV using the free JSON to CSV tool on Tools.Town — flatten nested objects, pick columns, download instantly.
7 May 2026
5 min read
How to Use JSON to XML — Complete Guide
Learn how to convert JSON to valid XML using the free JSON to XML tool on Tools.Town — configure root elements, attribute mode, and generate well-formed output.
7 May 2026
5 min read
How to Use Markdown to HTML — Complete Guide
Learn how to convert Markdown to clean HTML using the free Markdown to HTML tool on Tools.Town — GFM support, syntax highlighting, live preview, and instant copy.
7 May 2026
5 min read
How to Use XML Formatter — Complete Guide
Learn how to beautify, validate, and minify XML using the free XML Formatter on Tools.Town — consistent indentation, well-formedness checks, and line-number errors.
7 May 2026
5 min read
No guides match your search.