Boneyard Tools

JSONL to CSV Converter

Paste JSONL (one JSON object per line) to convert it to CSV, or switch direction to turn CSV back into JSONL. The header is the union of all keys.

How to convert JSONL to CSV

  1. Paste your JSONL, with one JSON object per line.
  2. Keep the default direction to get CSV, or switch to go back to JSONL.
  3. Copy the converted output.

Examples

Two records

{"name":"Ada","city":"London"}
{"name":"Alan","city":"Bletchley"}
name,city
Ada,London
Alan,Bletchley

Frequently asked questions

What is JSONL?

JSONL, also called NDJSON or JSON Lines, stores one JSON object per line. It is common for logs, exports and streaming data.

How is the CSV header built?

The header is the union of every key across all lines, kept in the order each key is first seen. Missing keys become empty cells.

How are commas and quotes handled?

Values containing commas, quotes or newlines are wrapped in double quotes and any inner quotes are doubled, following RFC 4180.

What happens to nested objects or arrays?

Nested values are written into a single cell as compact JSON, so an array like x and y becomes a JSON string in that column.

Can I convert CSV back to JSONL?

Yes. Switch the direction and the first CSV row becomes the keys, producing one JSON object per data row. Cells come back as strings.

Related tools

Converters

JSON to CSV

Convert JSON to CSV online. Paste an array of objects and get clean, spreadsheet-ready CSV with the right headers. Runs in your browser.

Converters

CSV to JSON

Convert CSV to JSON online. Turn spreadsheet rows into clean JSON objects or arrays, with smart number and boolean typing. Free tier plus API.

Converters

Binary to Decimal

Convert binary to decimal online. Paste any binary number, with or without spaces, and get the exact base-10 value instantly. Runs in your browser.

Converters

Binary to Hex

Convert binary to hexadecimal online. Paste a binary number and get exact hex, with optional uppercase. Handles huge values. Runs in your browser.

Converters

Binary Translator

Translate text to binary and binary back to text online. UTF-8 accurate, handles emoji and accents, with a copy button. Runs in your browser, nothing uploaded.

Converters

Celsius to Fahrenheit

Convert Celsius to Fahrenheit instantly. Type a temperature in C and get F, with the formula and a quick reference table. Runs in your browser.