JSON Lines \u21c4 CSV

Convert JSON Lines (NDJSON) to CSV for spreadsheets, CSV to JSON Lines for data pipelines, and JSON arrays to and from JSONL. Each line is validated separately, so you see exactly which lines are broken instead of a single parse error. Drop many files to convert them in one go.

Formats

FormatShape
JSONL / NDJSONOne JSON value per line
JSON array[{…},{…}]
CSVHeader row + rows

When to use it

  1. Open a JSONL log export in Excel.
  2. Prepare a CSV for BigQuery or an LLM fine-tuning JSONL file.
  3. Find the broken line in a large NDJSON file.
  4. Convert an API's JSON array to JSONL.

How to Use

  1. Choose the direction.
  2. Paste or drop files.
  3. Fix any reported lines, then copy or download.

Features

  1. JSONL ⇄ CSV
  2. JSON array ⇄ JSONL
  3. Per-line validation
  4. Key union header
  5. Flatten / nest
  6. Batch to ZIP

FAQs

What is JSON Lines?

One JSON value per line, also called NDJSON.

What happens to invalid lines?

They're skipped and listed with line numbers.

How are nested objects handled?

Flattened to dotted columns like user.name, or kept as JSON.

Can I convert a JSON array to JSONL?

Yes, both ways.

Is my data uploaded?

No.

Technical Details

JSON Lines input is split on line breaks and every non-blank line is parsed on its own, so one malformed line is reported with its line number and skipped instead of failing the whole file. The CSV header is the union of keys across all records, in first-seen order, so a record missing a field gets an empty cell rather than shifting columns. Nested objects can be flattened to dotted columns, and arrays of plain values are written as JSON in a single cell. CSV to JSON Lines can detect numbers and booleans, and turns dotted headers back into nested objects. JSON arrays and JSON Lines convert both ways.

Data & CSV Tools

Data & CSV Tools

  • SQL INSERT to CSV
  • JSON Normalizer
  • CSV \u21c4 YAML
  • XSD Viewer
  • CSV Column Extractor
  • CSV Delimiter Converter
  • CSV to SQL INSERT
  • CSV to Markdown Table