Join Data to JSON Lines Data

Join data to your JSON Lines / NDJSON data quickly

Drop your JSON_LINES (.jsonl) file here (or click to browse).
(100 MB or less file)
Sign-up to upload larger files
Join Data Tools JSON Lines Tools
Convert JSON Lines using an API
Join Data

Joining brings your JSON Lines / NDJSON file together with a second dataset by matching rows on the columns you choose, so related data ends up in one table. Pick an Inner, Left, Right, or Full join to decide which rows are kept when a match is missing. Perfect for enriching records, adding reference or lookup data.

JSON Lines / NDJSON

JSON Lines (also known as NDJSON — Newline Delimited JSON) is a text format where each line is a self-contained, valid JSON value, typically a JSON object. It is widely used for streaming data, log files, and large data exports because files can be read and written one record at a time without loading the entire document into memory. Common file extensions are .jsonl and .ndjson.