Excel ⇄ JSON Converter
Convert a JSON array of objects to a downloadable .xlsx file, or upload an Excel/CSV file and get a JSON array back.
Drop in an .xlsx, .xls or .csv file and get a JSON array of objects back — one object per row, column headers become keys, and a sheet picker handles multi-sheet workbooks. Everything happens locally in your browser.
- ✓.xlsx, legacy .xls, and .csv all supported through the same reader
- ✓First row becomes the object keys automatically
- ✓Multi-sheet workbooks — pick which sheet to convert
- ✓Empty cells become null, so every row has the same keys
- ✓100% private — the file never leaves your device
Why convert Excel to JSON?
A spreadsheet someone hands you — a product catalog, a list of users to seed, a config someone maintains in Excel because it's easier to edit — usually needs to become JSON before it's useful in code: an API fixture, a database seed script, a config file. This tool uploads the file locally, reads the first sheet (or one you pick), and turns every row into a JSON object keyed by the header row.
name | price | inStock
MacBook Pro | 2499 | truebecomes:
[
{ "name": "MacBook Pro", "price": 2499, "inStock": true }
]Multi-Sheet Workbooks
If the uploaded file has more than one sheet, a sheet selector appears so you can pick which one to convert — each sheet is converted independently, since a JSON array can only represent one flat table at a time. Column headers become object keys directly; an empty cell becomes null rather than being silently omitted, so every row in the output has the same set of keys.
Common Use Cases
- ▸Database seed scripts — Convert a spreadsheet of sample data into a JSON array ready for a seed script or fixture file
- ▸API test fixtures — Turn a QA-maintained spreadsheet of test cases into JSON payloads for automated API tests
- ▸Config migration — Move a config someone maintains in Excel into a JSON config file your application actually reads
- ▸One-off data imports — Import a client's product list or user list, handed over as a spreadsheet, straight into JSON without writing a parser