Skip to content

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

Uploading…

Your file is processed automatically and deleted right after you download the result, or after 3 hours at the latest.

How it works

  1. 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. 2/3

    Perform .ndjson to .xlsx conversion

    After successful file upload, click to convert when you are ready.

  3. 3/3

    Download converted .xlsx file

    Conversion result is ready to download.

How to convert ndjson to xlsx file

101convert.com assistant

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

  1. Upload the NDJSON file on the converter page.
  2. Choose or confirm XLSX as the output format, then start the conversion.
  3. 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.

Was this information helpful?

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.

Additional formats for
ndjson file conversion

Convert to xlsx from
other formats

Share on social media:

Already downloaded

This file has already been downloaded. For your privacy it was deleted from our server right after the download, so it cannot be downloaded again. To get it once more, convert the file again.