Preparing a dataset for import
Most bulk loaders and machine learning pipelines expect one record per line rather than a single array.
Turn a JSON array into JSON Lines in your browser, one record per line, ready for streaming tools.
Maintained by Roshan.
Converts JSON array into JSON Lines in this tab. Configuration files routinely hold hostnames, keys and credentials, so nothing here is sent anywhere.
Find related browser-local tools for nearby tasks without starting another search.
Browse all developer and data toolsJSON Lines exists because a single enormous JSON array is awkward to process. To read one record you have to parse the whole file, which means holding all of it in memory, and a file that grows past what a machine can hold becomes unusable rather than merely slow. JSON Lines solves this by putting one complete JSON value on each line, so a program can read a line, process it, and forget it. That is why it has become the standard format for log shipping, machine learning datasets, database bulk import and anything else that streams. The conversion is mechanical but has one hard rule: no record may contain a literal newline, because the newline is the delimiter. Every record here is written compactly for exactly that reason.
Most bulk loaders and machine learning pipelines expect one record per line rather than a single array.
A multi-gigabyte array cannot be parsed in one go, but a JSONL file of the same records can be read a line at a time.
JSONL puts one complete JSON value on each line instead of wrapping everything in one array, which lets a program read records one at a time.
Because a newline ends a record. Pretty-printing would split one record across several lines and break the format.
Effectively yes. The names are used interchangeably, and the file extensions .jsonl and .ndjson both appear.
Yes. JSONL imposes no schema, though whatever reads the file might.
Turn JSON Lines into a single formatted JSON array in your browser. Names the exact line if one record is malformed.
Format, minify, and validate JSON locally in your browser. Inspect keys, values, nesting depth, and root type without sending private API data to a server.
Convert JSON objects to UTF-8 CSV in your browser. Union columns, quote values, and protect formula-like strings.