What it is
The Excel to JSON Converter reads an .xlsx or .xls spreadsheet and gives back JSON: an array of objects, where each row becomes an object and each column header becomes a key.
Who needs this
It is the bridge between the people who keep data in spreadsheets and the systems that only speak JSON. A product list maintained in Excel becomes seed data for an application. A translation sheet becomes a language file. A configuration table becomes something an API can accept. A one-off export becomes a fixture for automated tests.
Doing it by hand is slow and error-prone; a hundred rows retyped as JSON is a hundred chances to miss a comma.
How to use it
- Add the spreadsheet.
- Pick the sheet if there is more than one, and confirm that the first row holds the column names.
- Copy or download the JSON.
What to check in the output
Header names become keys, exactly as written. A header with spaces or accents produces a key with spaces or accents, which is valid JSON but awkward in most languages. Renaming the headers before converting is usually easier than fixing the JSON afterwards.
Types are inferred. Numbers come out as numbers, not strings. That is usually what you want, except for things that only look numeric: product codes and postcodes with leading zeros are the classic case.
Empty cells become empty or missing values rather than the string "null", so a consumer that expects every key to be present should be checked against a real export.
Your file stays on your device
The conversion runs in your browser, so nothing is uploaded and nothing is stored.
For a CSV source instead of a spreadsheet, use the CSV to JSON converter.