Free JSONL to CSV — dot-notation flattening — no upload
Convert JSONL to CSV
JSON Lines to
spreadsheet.
Free JSONL to CSV converter. Upload any .jsonl or .ndjson file — nested objects flattened with dot-notation, arrays joined with semicolons. For BigQuery exports, MongoDB exports and Hugging Face dataset inspection. Upload or paste. No server.
Your data never leaves your browser
Nested objects flattened
Upload or paste
Copy to clipboard
Always free
JSONL to CSV Converter
100% client-side
Drop your JSONL file here
.jsonl, .ndjson, .json, .txt
or paste JSONL directly
Paste JSON Lines
Conversion complete
JSONL to CSV in Python
Python — pandas
import pandas as pd
df = pd.read_json('data.jsonl', lines=True)
df.to_csv('output.csv', index=False)
# With nested object flattening:
from pandas import json_normalize
import json
records = [json.loads(l) for l in open('data.jsonl')]
df = json_normalize(records)
df.to_csv('output.csv', index=False)
pd.read_json(lines=True) reads JSONL natively. json_normalize() flattens nested keys with dot notation — same as CSVShift.
DuckDB — query JSONL directly
import duckdb
# Read JSONL and export as CSV in one step:
duckdb.query("""
COPY (SELECT * FROM read_ndjson_auto('data.jsonl'))
TO 'output.csv' (HEADER, DELIMITER ',')
""")
DuckDB reads JSONL natively and can export to CSV, Parquet or any other format. Fastest option for large files.
Related CSV tools
Popular searches
jsonl to csvndjson to csvjson lines to csvconvert jsonl to csvjsonl to csv onlinejsonl to csv pythonndjson to csv converterjsonl to csv freejson lines converter csvbigquery export jsonl to csvmongodb export jsonl csv
Frequently asked questions
How do I convert JSONL to CSV?
Upload your .jsonl file or paste the JSON Lines content. CSVShift parses each line as a JSON object, collects all keys as column headers, and exports as CSV. Nested objects are flattened with dot-notation (address.city becomes a column).
What is the difference between JSONL and JSON?
A JSON file typically contains a single value — often an array of objects. A JSONL file has one JSON object per line, with no enclosing array. JSONL can be streamed and processed line-by-line without loading the entire file into memory, making it better for large datasets.
Is my data safe when converting JSONL to CSV online?
Yes. CSVShift processes everything in your browser. Your file is never uploaded to any server.