Micro Tools
Advertisement

XLSX to JSON converter

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

Converter

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

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

Advertisement

How the spreadsheet becomes JSON

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 with types preserved from the cells.

Getting the best results

Press Load sample first to see the exact XLSX shape the converter expects, then replace it with your own data. If a conversion errors, the message names the exact line or token at fault, so fixing the input is usually a one-minute job. For repeated jobs, bookmark the page; your data never leaves the browser.

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 JSON 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 the JSON output formatted?
As a pretty-printed array of objects with two-space indentation, one object per row and null for missing cells. It validates as strict JSON, so you can paste it into APIs, config files or JavaScript with JSON.parse and it just works.
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 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 for migrations, reports and config work without installing anything.
Advertisement