{}

JSONL / NDJSON Formatter

Format, validate, and inspect JSON Lines (JSONL) and NDJSON files. Validates each line individually, reports parse errors by line number, outputs compact JSONL or a pretty-print preview, and lets you download the cleaned file.

Data ToolsDevelopment
Loading tool...

How to Use JSONL / NDJSON Formatter

How to Use the JSONL / NDJSON Formatter

What is JSONL / NDJSON?

JSON Lines (JSONL) and Newline Delimited JSON (NDJSON) are text formats where each line is a self-contained, valid JSON value — most commonly a JSON object. They are widely used for:

  • Log streaming and aggregation (Datadog, Loki, CloudWatch)
  • BigQuery and Snowflake data imports
  • Large dataset exports and ETL pipelines
  • Streaming API responses
  • Machine learning training datasets

Example valid JSONL:

{"id":1,"name":"Alice","role":"admin"} {"id":2,"name":"Bob","role":"user"} {"id":3,"name":"Carol","role":"viewer"}

Step 1: Paste Your JSONL

Paste your JSONL or NDJSON content into the input box. Each line should contain exactly one JSON object or value. Empty lines are allowed and are counted separately from errors.

Step 2: Check the Stats

The tool immediately reports:

  • Total Lines — total line count including empty lines
  • Valid JSON — lines that parsed successfully
  • Errors — lines that failed to parse (invalid JSON)
  • Empty Lines — blank lines (ignored in output)

Step 3: Review Errors

If any lines fail to parse, the Parse Errors panel shows:

  • Line number
  • The exact parse error message
  • A preview of the problematic line content

Common errors:

  • Unquoted keys: {name: "Alice"} → must be {"name": "Alice"}
  • Trailing commas: {"a":1,} → not valid JSON
  • Single quotes: {'name': 'Alice'} → must use double quotes
  • Truncated lines: JSON cut off mid-object

Step 4: Choose Output Mode

  • Compact JSONL (default) — reformats each valid line as minified single-line JSON. This is the standard NDJSON format, ready for file imports and pipeline processing.
  • Pretty Preview — formats each object with 2-space indentation, separated by blank lines. This is for human reading only and is not valid NDJSON — do not use this output in pipelines.

Step 5: Copy or Download

  • Copy JSONL — copies the compact output to clipboard
  • Download .jsonl — downloads the compact JSONL output as output.jsonl, containing only valid lines

The downloaded file strips all empty lines and reformats each object as compact JSON. Invalid lines are excluded from the output.

Frequently Asked Questions

Most Viewed Tools

🔐

TOTP Code Generator

2,937 views

Generate time-based one-time passwords from a TOTP secret key. Enter your base32 secret, choose a period and digit length, and get the current and next codes with a live countdown timer. Useful for testing and debugging 2FA integrations.

Use Tool →
{ }

JSON to Zod Schema Generator

2,936 views

Generate Zod validation schema code from a JSON sample object. Infers z.string(), z.number(), z.boolean(), z.array(), z.object(), and z.null() types automatically. Handles nested objects, arrays of objects with optional field detection, and outputs copy-ready TypeScript with import and z.infer type alias.

Use Tool →
🔍

Secret and Credential Scanner

2,481 views

Scan pasted text, code, or config files for accidentally exposed API keys, tokens, passwords, and private keys. Detects 50+ secret types across AWS, GitHub, Stripe, OpenAI, and more — all client-side, nothing leaves your browser.

Use Tool →
🔑

Password Entropy Calculator

2,414 views

Calculate the information-theoretic bit entropy of any password or API key. Detects character set pools automatically, shows the total number of possible combinations, and estimates crack time across five attack scenarios from rate-limited web logins to GPU cracking clusters.

Use Tool →
🔐

TLS Cipher Suite Checker

2,385 views

Check TLS protocol version compatibility and cipher suite strength ratings against current best practices. Supports IANA and OpenSSL cipher names — rates each suite as Strong, Weak, or Deprecated and explains why.

Use Tool →
🔒

Content Security Policy Generator

2,074 views

Build Content Security Policy headers interactively. Toggle directives like script-src, style-src, and img-src, select allowed source tokens, and add custom origins. Instantly outputs your CSP as an HTTP header, meta tag, Nginx directive, or Apache header.

Use Tool →
📺

Screen Size Converter

1,850 views

Calculate screen width and height from diagonal size and aspect ratio. Convert between inches and centimeters for displays, TVs, and monitors with instant dimension calculations.

Use Tool →
🔐

API Key Hasher

1,768 views

Hash API keys using SHA-256, SHA-512, or PBKDF2 before storing them in your database. Generates a Node.js verification snippet and shows the recommended storage format — all 100% client-side using the Web Crypto API.

Use Tool →

Related Development Tools

📱

QR Code Generator

Featured

Create custom QR codes for URLs, text, and contact info

Use Tool →
{ }

JSON to TypeScript Interface

Generate TypeScript interfaces from JSON objects instantly. Infers types for strings, numbers, booleans, arrays, and nested objects. Detects optional fields from array element merging, handles null values, and outputs clean, ready-to-use interface definitions.

Use Tool →
{ }

JSON to Zod Schema Generator

Generate Zod validation schema code from a JSON sample object. Infers z.string(), z.number(), z.boolean(), z.array(), z.object(), and z.null() types automatically. Handles nested objects, arrays of objects with optional field detection, and outputs copy-ready TypeScript with import and z.infer type alias.

Use Tool →
{ }

JSON String Escaper / Unescaper

Escape and unescape special characters in JSON string values. Handles double quotes, backslashes, newlines, tabs, carriage returns, and Unicode \u sequences. Real-time bidirectional conversion with a built-in escape sequence reference.

Use Tool →
🟣

Kotlin Formatter

Format Kotlin code instantly in your browser. Fix indentation, enforce opening-brace-on-same-line style, and add trailing commas to function parameters and class bodies — no server required.

Use Tool →
🗂️

Parquet to CSV Converter

Convert Apache Parquet files to CSV format instantly in your browser. No uploads, no server — all processing is 100% client-side.

Use Tool →
⏱️

API Rate Limiter Calculator

Calculate safe polling intervals, per-client request capacity, burst headroom, and throttle risk from any API rate limit. Enter your rate limit, time window, and number of concurrent clients to instantly see the minimum delay between requests, per-client allocation, burst capacity, and a color-coded throttle risk assessment. Supports Stripe, GitHub, X (formerly Twitter), OpenAI, Twilio, and any custom rate limit. Free and runs entirely in your browser.

Use Tool →
🪙

YAML to TOON Converter

Convert YAML to TOON (Token Oriented Object Notation) and reduce LLM token usage. Free, instant, browser-based.

Use Tool →

Share Your Feedback

Help us improve this tool by sharing your experience

We will only use this to follow up on your feedback