Micro Tools
Advertisement

XLSX to JSONL converter

Convert XLSX to JSONL free in your browser. Paste your XLSX on the left, press Convert, and copy clean JSON Lines on the right. No sign-up, no uploads.

Converter

Paste XLSX below, press Convert, and copy the JSON Lines output.

Picking a file reads its first sheet into the input box.

Advertisement

How the spreadsheet becomes JSONL

When you pick a file, the SheetJS library reads the first worksheet into a grid in memory, and the first row becomes the column headers for every row below it. That grid is exactly what you see staged in the input box as JSON, and pressing Convert reshapes it into JSON Lines with types preserved from the cells.

Tips for the JSON Lines output

JSON Lines is the friendliest shape for big data: stream it into BigQuery, ClickHouse or a log pipeline without loading everything into memory. Because each row is independent, you can also split the output file by line count and process chunks in parallel.

Related tools

JSON formatterFormat and validate JSON, privately. Regex testerTest regex live with highlighting. Base64 encoderBase64 encode and decode, plus URL encoder and JWT decoder.

XLSX to JSONL FAQs

Which part of my spreadsheet gets converted?
Upload any .xlsx or .xls file and the tool reads the first worksheet only, using its first row as the column headers. Blank rows are skipped. If your data lives on another sheet, move or copy it to the first sheet before uploading, or paste the cells as a JSON array of arrays.
How is each line formed?
Exactly one compact JSON object per row, one per line, with no trailing comma and no outer array. That is the format log shippers, BigQuery, ClickHouse and most streaming ingest tools expect, so the output can be piped straight in.
Do cell types survive the conversion?
Numbers, booleans and text come through with their types, and empty cells become empty strings. Dates arrive as Excel serial values, so format date columns as text in Excel first if you need readable dates in the JSON Lines output.
Is there a size limit for XLSX input?
No hard limit, but everything runs in your browser tab, so tens of thousands of rows convert in seconds while millions of rows may slow the page. For very large XLSX files, split them into smaller chunks and convert each separately.
Is my XLSX data private, and who uses this?
Yes. The conversion runs 100% in your browser with the SheetJS library loaded from CDN; nothing is uploaded to any server. Developers, analysts and DBAs use it to move XLSX data into JSON Lines for migrations, reports and config work without installing anything.
Advertisement