Working With Structured Data
Last updated: 27 September 2026
JSON, YAML, TOML, XML, and CSV all store data, but they do not make the same promises. Converting between them is more than changing punctuation: you may lose types, nesting, comments, order, or repeated fields.
Read before converting
First check what the source actually contains. A JSON array of objects converts to a table easily when every object has similar keys. Nested objects and arrays do not fit cleanly into a CSV cell; decide whether to flatten them, serialize them as text, or keep the original format.
Compare meaning, not only appearance
A formatter changes whitespace; a parser checks syntax; a schema checks whether data follows agreed rules. If a conversion succeeds, inspect a few records and round-trip a small sample. Pay special attention to numbers, empty values, dates, and YAML values that look like booleans or timestamps.
Related tools
- CLI Table Converter — Turn aligned terminal output such as docker ps or df into a Markdown table, CSV or TSV.
- CSV and JSON Converter — Convert CSV to JSON, or JSON back to CSV, with configurable delimiter and pretty-printing.
- CSV Viewer — Open a CSV, TSV or pipe-separated file, filter it and sort it column by column in a table.
- JSON Diff — Compare two JSON documents and highlight the differences.
- JSON Formatter — Validate, pretty-print and minify JSON, with optional key sorting.
- JSON Minifier — Strip all whitespace from JSON to shrink it.
- JSON Path Explorer — Evaluate JSONPath expressions against JSON, list every match with its path, and browse the document as a clickable tree.
- JSON Schema Validator — Validate a JSON document against a JSON Schema and list every problem with the exact JSON Pointer path.
- JSON to CSV — Flatten a JSON array of objects into CSV.
- JSON to TOML — Convert JSON documents to TOML.
- JSON to XML — Convert JSON documents to XML.
- JSON to YAML — Convert JSON documents to YAML.
- JSON Viewer — Explore a JSON document as a collapsible tree or as a table of records, with a live count of nested values.
- TOML to JSON — Convert TOML documents to JSON.
- TOML to YAML — Convert TOML documents to YAML.
- XML Formatter — Pretty-print and minify XML.
- XML to JSON — Convert XML documents to JSON.
- YAML to JSON — Convert YAML documents to JSON.
- YAML to TOML — Convert YAML documents to TOML.
- YAML Viewer — Validate and explore a YAML document.