Excel to JSON
Turn a spreadsheet into JSON records, in the page.
- Runs on your device — the file is never sent anywhere
- No sign-up, no watermarks, no daily quotas
- Free, with no limit on how often you use it
How it works
Getting a spreadsheet into JSON is the first step of most import scripts, seed files and test fixtures. It is also the point at which a file full of real data usually gets pasted into a random converter.
Records or raw rows
Records give one object per row with the first row supplying the field names, which is what an API or an import script expects. Raw arrays give you the rows exactly as they are, including the header row — useful when the sheet has no header, or when the layout is irregular and you want to handle it yourself.
Types are preserved
Numbers come through as JSON numbers and dates as readable values rather than everything becoming a string. Empty cells become null in record mode, so every object has the same shape, which matters when the result is fed to something strict.
One sheet or all
By default only the first sheet is converted, which is the usual case. Choosing all sheets produces an object keyed by sheet name, with each one's rows inside. You are told when a workbook had more sheets than were converted.
What is lost
Formatting, formulas, merged cells and charts have no JSON equivalent. Formula results are kept; the formulas are not.
Excel to JSON — questions
Where do the field names come from?
The first row of the sheet, in record mode.
Can I convert every sheet at once?
Yes. Choose all sheets and you get an object keyed by sheet name.
Are numbers converted properly?
Yes, numbers stay numbers rather than becoming strings.
Is my file uploaded?
No. Everything happens in your browser.