Excel to JSON

Excel to JSON reads the first sheet only and writes a JSON array. Ada with qty 2 and Bea with qty 3 keep those qtys as numbers, unlike the CSV page, which keeps them as text.

First sheet, numeric cells

A workbook whose first sheet is named First, with a header name and qty, then Ada and 2, then Bea and 3, becomes an array of two objects. qty is the number 2 and the number 3, without quotes. A second sheet named Second is not in the JSON. An empty name cell stays an empty string and still has the qty key. A missing qty cell is omitted, so a row that only has Bea has a name and no qty key. The output is pretty-printed with two spaces. The stored name ends in converted.json. The content type is application/json. The button reads Run Excel to JSON. The cap is 25 MB. The job uses the first file.

What does not come from later sheets

There is no sheet picker. Move the sheet you need to the front, save, and upload that file. Charts that are not cell values are not objects. This page does not turn a number into a string. CSV to JSON does the opposite for a text export of the same rows. Dates follow whatever the sheet reader stored. This measurement used plain numbers and text, not a date cell, so a date format is not claimed here. Formulas are whatever value the reader placed in the cell. The JSON does not contain the formula text from this test, because the test cells were values.

How to tell the pages apart

If qty has quotes, you are looking at the CSV conversion. If qty is a bare number, you are looking at this page. If a secret column from a second sheet appears, that sheet was first in the file you uploaded. Count the objects. Two data rows under a header become two objects. A header alone becomes an empty array from a sheet with no data rows. The two-space indent is fixed. There is no minify switch.

The workbook is sent

The workbook is uploaded for this conversion, the cap is 25 MB, and the temporary object is removed after the JSON is ready. Keep the workbook if you still need the second sheet. The download is the first sheet only. The button reads Run Excel to JSON. The stored name ends in converted.json and the content type is application/json. Two data rows under a header become two objects, and a missing qty cell is left out of that object. A sheet that sits behind First is ignored even when it has more rows. Move that sheet to the front and save before you upload if those rows are the ones you need.