Free online NDJSON to CSV converter
Convert newline-delimited JSON records into spreadsheet-ready CSV rows.
Convert NDJSON to CSV online - free
Your file is processed automatically and deleted right after you download the result, or after 3 hours at the latest.
Import a file from a URL
Paste a direct link to the file. We download it to our server and it is converted exactly like an upload.
How it works
-
1/3
Upload your .ndjson file
Click to browse to select your file you want to convert or simply drag & drop your file into selected area.
-
2/3
Perform .ndjson to .csv conversion
After successful file upload, click to convert when you are ready.
-
3/3
Download converted .csv file
Conversion result is ready to download.
How to convert ndjson to csv file
- Internet
- No ratings yet.
101convert.com assistant
12m
API logs and data exports often arrive as NDJSON, while spreadsheet and reporting tools commonly expect CSV. Converting the records to CSV makes flat fields easier to sort, filter, and share.
What NDJSON is
NDJSON (newline-delimited JSON) stores one JSON value per line, usually one object per record. Web APIs, application logs, data pipelines, and command-line tools commonly produce it because each line can be processed independently and new records can be appended easily. Files often use the .ndjson or .jsonl extension.
What CSV is
CSV stores tabular data as rows and columns, with fields separated by commas and rows by line breaks. Spreadsheet applications, databases, and analytics tools widely support it. CSV is useful for inspecting and editing flat data, but it does not retain JSON types or nested structures.
How to convert NDJSON to CSV
Online on 101convert.com
- Open the NDJSON-to-CSV converter page on 101convert.com.
- Upload the file; several files can be converted in one batch. Check the per-file size limit shown on the page.
- Start the conversion, then download the resulting CSV file or files.
Offline with desktop software
Python is free and runs on Windows, macOS, and Linux. Save the following as ndjson_to_csv.py. It collects columns from all records, leaves missing values blank, and writes nested objects or arrays as JSON text in their cells:
import csv, json
rows = []
columns = []
with open("input.ndjson", encoding="utf-8") as source:
for line in source:
if not line.strip():
continue
row = json.loads(line)
if not isinstance(row, dict):
raise ValueError("Each line must contain a JSON object")
rows.append(row)
for key in row:
if key not in columns:
columns.append(key)
with open("output.csv", "w", newline="", encoding="utf-8-sig") as target:
writer = csv.DictWriter(target, fieldnames=columns, extrasaction="ignore")
writer.writeheader()
for row in rows:
writer.writerow({key: json.dumps(value, ensure_ascii=False) if isinstance(value, (dict, list)) else value
for key, value in row.items()})
Place the input file beside the script, named input.ndjson, then run python ndjson_to_csv.py from a terminal. On some systems, use python3 ndjson_to_csv.py. The script writes output.csv.
Quality and compatibility
CSV has one header row, so records with different keys produce columns for the union of those keys; absent values are empty. Nested JSON is kept as text rather than expanded into columns. Review the output if downstream software needs a fixed column order, specific date or number formats, or flattened nested fields. The script uses UTF-8 with a byte-order mark, which helps some spreadsheet programs recognize the encoding.
Note: This ndjson to csv conversion record is incomplete, must be verified, and may contain inaccuracies. Please vote below whether you found this information helpful or not.
Information about file extensions and file types is provided by File-Extensions.org
Frequently asked questions
Is the NDJSON to CSV converter free?
Yes, converting NDJSON to CSV on 101convert.com is completely free. No registration, email address or installation is required. If you need a higher file size limit or want to convert more files at once, see our plans.
How large can my NDJSON file be?
You can upload NDJSON files up to 3 MB and convert up to 3 files at once in a single batch. With a paid plan the limit is up to 100 MB per file and 20 files at once, see our plans.
What happens to my uploaded files?
Files are processed automatically. Your upload is deleted from our servers right after you download the result, or after 3 hours at the latest. We never view or share your files.
Do I need to install any software to convert NDJSON to CSV?
No. The NDJSON to CSV conversion runs entirely online in your browser and works on Windows, Mac, Linux, Android and iPhone.
Did the conversion fail?
In most cases, the cause is an incorrect file format. Please upload a valid NDJSON file for this NDJSON to CSV conversion. Occasionally, the issue may be on our side. We analyze recurring conversion failures and disable or fix the converter if we detect a defect.