Parquet to JSON / JSONL Converter

Decode Apache Parquet columns offline and export BigInt-safe formatted JSON arrays or streaming-friendly JSONL (NDJSON).

Zero-Upload Guarantee:Processed 100% locally in your browser via WebAssembly & client-side JavaScript. Disconnect Wi-Fi and it still works.(Includes a 50-row synthetic SaaS order Parquet sample)
Drop a .parquet file here or pick from disk
Reads Parquet footer & row groups locally with byte-slice streaming.

Converting Parquet Columns Back to JSON or NDJSON

API fixtures, Elasticsearch seeders, document stores, and LLM evaluation harnesses expect row-oriented JSON rather than binary columnar Parquet blocks. Switching output modes between formatted JSON Array (.json) and newline-delimited JSONL (.jsonl) lets you reuse the same local Parquet source for both REST payloads and streaming CLI pipelines.

This browser workbench decodes Snappy, Zstd, Gzip, Brotli, and LZ4 columns without server uploads, safely converting BigInt integers to string scalars and JavaScript Date objects to ISO-8601 timestamps so JSON.stringify never crashes on analytics exports.

Step-by-Step Workflow & Local CLI Commands

  1. Load your .parquet file or click Try sample .parquet (50 rows) above.
  2. Toggle between JSON Array (.json) and JSONL / NDJSON (.jsonl) and inspect the live formatted output.
  3. Click Download JSON / JSONL, or switch to the SQL Query tab first to extract a filtered subset.

For multi-hundred-megabyte full-file conversions on your machine, use DuckDB CLI:

# Export Parquet to newline-delimited JSONL locally via DuckDB
duckdb -c "COPY (SELECT * FROM 'orders.parquet') TO 'orders.jsonl' (FORMAT JSON, ARRAY false);"

# Or export as a single JSON array
duckdb -c "COPY (SELECT * FROM 'orders.parquet') TO 'orders.json' (FORMAT JSON, ARRAY true);"

Known Limitations & Precision Checks

Frequently Asked Questions

What is the difference between JSON Array and JSONL / NDJSON output?

JSON Array wraps all records inside [...] so standard JSON parsers read the whole file at once. JSONL (newline-delimited JSON) puts one valid JSON object per line without commas between lines, making it ideal for log pipelines and LLM datasets.

How does the converter handle 64-bit BigInt columns from Parquet?

Standard JSON.stringify throws a TypeError on JavaScript BigInt values. This workbench converts BigInts cleanly to strings so timestamp nanosecond columns and snowflake IDs never fail export.

Are Parquet files ever sent to an API during JSON export?

No. All decompression and JSON formatting execute strictly inside browser memory after loading the page.

Live · Offline

Parquet Viewer & SQL Inspector

Open .parquet files locally, inspect column schema & row groups, run SQL queries, and export CSV/JSON without uploading.

Open tool
Live · Offline

Parquet to CSV Converter

Select columns from local Apache Parquet files and export clean RFC-4180 CSV directly in browser memory.

Open tool
Live · Offline

CSV to Parquet Converter

Infer column types from local CSV spreadsheets, compress with Snappy in WebAssembly/JS, and download .parquet.

Open tool
Live · Offline

JSON / JSONL to Parquet Converter

Turn JSON arrays or NDJSON log lines into typed, Snappy-compressed Apache Parquet files locally.

Open tool