Excel to JSON
Convert worksheets into clean JSON for APIs and apps.
Turn a spreadsheet into an array of objects keyed by your header row, ready to paste into a seed file, a fixture or an API request. Choose between arrays of objects, arrays of arrays, or a nested object keyed by a column of your choice.
- Rating
- 4.9(2.5K)
- Monthly uses
- 361K
- Price
- Free
or drag it here
.xlsx, .xls, .csv · processed locally, never uploaded
Files stay on your device
What it does well
- Real JSON types — numbers, booleans and ISO dates instead of strings
- camelCase, snake_case or verbatim key naming
- Minified or 2-space pretty output with syntax highlighting in the preview
How to use Excel to JSON
- 1
Upload the workbook and pick the sheet to export.
- 2
Select the header row so keys are named correctly.
- 3
Choose the output shape: objects, arrays, or keyed by a column.
- 4
Copy the JSON or download it as a .json file.
Watch a walkthrough
Common problems and fixes
Keys are named __EMPTY, __EMPTY_1 and so on.
The chosen header row has blank cells. Pick the correct header row number, or supply your own key names in the column editor.
Numbers come out as strings.
The source cells are text-formatted. Enable “Coerce numeric strings”, or clean the column first with the Number Formatter.
Frequently asked questions
What people say
Small thing, but the error messages actually tell you what to fix. Excel to JSON flagged a hidden character that had been breaking my lookups for weeks.
Exactly what I needed. Excel to JSON used to be a twenty-minute job with a macro I did not trust; now it takes one drag and one click.
The preview before committing is the part that sold me — I could see exactly what excel to json was going to change before it changed anything.
More convert tools
Move data between XLSX, CSV, JSON, XML, HTML and PDF without losing formatting, encoding or number precision. Every conversion runs locally in your browser.
Browse Convert