Micro Tools
Advertisement

JSONL to TSV converter

Convert JSONL to TSV free in your browser. Paste your JSON Lines on the left, press Convert, and copy clean TSV on the right. No sign-up, no uploads.

Converter

Paste JSON Lines below, press Convert, and copy the TSV output.

Advertisement

How JSON Lines becomes TSV

Each non-empty line is parsed as its own JSON object and treated as one row, so a 10,000-line file is simply 10,000 rows. The converter collects the union of all keys across lines to build the column set, which means ragged objects with different keys still convert cleanly, with blanks where a line lacked a key.

Getting the best results

Press Load sample first to see the exact JSONL shape the converter expects, then replace it with your own data. If a conversion errors, the message names the exact line or token at fault, so fixing the input is usually a one-minute job. For repeated jobs, bookmark the page; your data never leaves the browser.

Related tools

JSON formatterFormat and validate JSON, privately. Regex testerTest regex live with highlighting. Base64 encoderBase64 encode and decode, plus URL encoder and JWT decoder.

JSONL to TSV FAQs

What exactly counts as JSON Lines input?
One complete JSON object per line, with no commas between lines and no outer array brackets. Each object becomes one row, and the union of all keys becomes the TSV columns. Blank lines are ignored, and the tool tells you the exact line number if one line fails to parse.
Why choose TSV over CSV here?
Tabs rarely appear inside real data, so TSV survives copy-paste through chat apps and documents better than CSV. The output uses the same quoting rules as CSV for cells that contain tabs or newlines, and it imports directly into spreadsheets.
What about nested objects inside a line?
Nested objects and arrays are kept as compact JSON strings inside their cell, so nothing is dropped. If you need them flattened into dotted columns, convert to JSON first and flatten there; this tool keeps the TSV one row per line.
Is there a size limit for JSONL input?
No hard limit, but everything runs in your browser tab, so tens of thousands of rows convert in seconds while millions of rows may slow the page. For very large JSONL files, split them into smaller chunks and convert each separately.
Is my JSONL data private, and who uses this?
Yes. The conversion runs 100% in your browser; nothing is uploaded to any server. Developers, analysts and DBAs use it to move JSONL data into TSV for migrations, reports and config work without installing anything.
Advertisement