Free online NDJSON to XLSX converter
Convert newline-delimited JSON records into rows and columns in an XLSX workbook.
Convert NDJSON to XLSX 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 .xlsx conversion
After successful file upload, click to convert when you are ready.
-
3/3
Download converted .xlsx file
Conversion result is ready to download.
How to convert ndjson to xlsx file
- Internet
- No ratings yet.
101convert.com assistant
10m
API responses, event logs, and data exports often arrive as NDJSON, while spreadsheet users need XLSX to filter, edit, or share the records. Converting the file puts each record into worksheet rows and fields into columns.
What NDJSON is
NDJSON, also called newline-delimited JSON, stores one JSON value per line, usually one object per line. APIs, logging systems, and data-processing tools create it because records can be appended and processed one at a time without reading a single large JSON array.
What XLSX is
XLSX is the Office Open XML workbook format used by Microsoft Excel and supported by programs such as LibreOffice Calc. It organizes data into worksheets with rows and columns, and can store formulas, formatting, and multiple sheets. Choose it when records need spreadsheet editing, sorting, filtering, or compatibility with spreadsheet software.
How to convert NDJSON to XLSX
Online on 101convert.com
- Upload the NDJSON file on the converter page.
- Choose or confirm XLSX as the output format, then start the conversion.
- Download the converted workbook. The page supports batch conversion, and displays a per-file size limit.
Offline with desktop software
Python with pandas is a free, cross-platform option for Windows, macOS, and Linux. Install the required packages, then read the file as newline-delimited JSON and write the workbook:
python -m pip install pandas openpyxl
python -c "import pandas as pd; pd.read_json('input.ndjson', lines=True).to_excel('output.xlsx', index=False)"
Run the command in the folder containing input.ndjson, or replace the filenames with full paths. Each JSON object becomes a row; object keys become columns.
Microsoft Excel Power Query can parse NDJSON on Windows. In Excel, open Data → Get Data → From Other Sources → Blank Query, choose Home → Advanced Editor, replace the query with the following M code, and change the file path:
let
Lines = Lines.FromBinary(File.Contents("C:\data\input.ndjson"), null, null, 65001),
Records = List.Transform(Lines, each Json.Document(Text.ToBinary(_))),
Data = Table.FromRecords(Records)
in
Data
Choose Done, then Home → Close & Load to put the table in a worksheet. Remove blank lines from the source if Power Query reports a JSON parsing error.
Conversion limits and data quality
Nested JSON objects and arrays do not naturally fit flat spreadsheet columns; pandas may write them as text, while Power Query can expose them for expansion. Check these fields after conversion if they need to be analyzed as separate columns. Spreadsheet applications also impose row and column limits; Excel supports at most 1,048,576 rows and 16,384 columns per worksheet. Excel can alter long numeric identifiers or infer dates and types, so check identifiers, timestamps, nulls, and large numbers in the resulting workbook.
Note: This ndjson to xlsx 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 XLSX converter free?
Yes, converting NDJSON to XLSX 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 XLSX?
No. The NDJSON to XLSX 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 XLSX 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.