JSON converters

JSON (JavaScript Object Notation) is the text format most web APIs, apps and configuration files use for data. Values can be nested: a record can hold another record or a list, which a flat table cannot.

Convert JSON

• CSV → JSONConvert CSV to JSON
• JSON → CSVConvert JSON to CSV

What to know about JSON

• Objects hold named values, lists hold values in order; both can be nested to any depth.
• Values are text, numbers, true/false or null, so a postcode written as "0150" stays text.
• JSON Lines (.jsonl, .ndjson) puts one JSON object on each line, common in logs and data exports.
• Text is always Unicode, normally UTF-8.

File extensions: .json, .jsonl, .ndjson