Excel to JSON Converter
Convert a selected Excel worksheet into structured JSON for an API, migration, test fixture, or data review. Choose between objects that use the first row as keys and arrays that preserve the worksheet row shape.
Convert Your File
Your files are processed in your browser and are not uploaded to Converter247.
No file selected.
Data preview
Supported Input
One .xlsx workbook up to 15 MiB.
Generated Output
A downloadable .json file and copyable JSON preview.
Declared Conversion Profile
| Profile decision | Current behavior |
|---|---|
| Accepted workbook | Modern .xlsx only, with one selected worksheet exported. |
| JSON shape | Choose arrays of objects with deterministic unique headers or arrays of arrays that retain row positions. |
| Formula cells | Stored cached values are used without recalculation; missing caches become null with a warning. |
| Dates and errors | Parsed date cells become ISO 8601 strings; spreadsheet error cells become their readable cached text or null. |
What This Conversion Preserves
- Cell values, booleans, numbers, empty cells, and Unicode text.
- Row order and column position in array-of-arrays mode.
- Deterministic keys in array-of-objects mode.
Important Format Limits
- Styling, charts, images, macros, and workbook layout are not represented in JSON.
- Merged cells can produce blank positions outside the stored anchor cell.
- Formulas are not executed and do not remain active in JSON.
Preview tables show at most the first 100 rows and 50 columns. The downloaded result contains all validated data unless a documented hard limit stops conversion before export.
A Practical Example
A worksheet headed Name, Region, and Active can become an array of objects for application import. Blank headings become column_N, and duplicate headings receive numeric suffixes so no property silently overwrites another.
Before You Download
- Check whether object mode or array mode fits the destination system.
- Review generated keys for blank headers, duplicate headers, and columns that should stay grouped together.
- Inspect empty cells, formula display values, dates, and booleans before importing the JSON elsewhere.
Browser Processing and File Safety
A Web Worker reads the selected workbook in your browser without sending it to a conversion API. Reset clears the workbook selection, preview, and generated download link.
Only modern .xlsx workbooks are accepted for Excel input in this release. Legacy .xls and macro-enabled .xlsm files are outside this profile. Workbook formulas are not recalculated; the stored cached value is used when present, and a missing cache is reported instead of being invented.
The input limit is 15 MiB, with up to 1,500 ZIP entries and 100 MiB of declared uncompressed data. The conversion does not preserve macros, charts, styles, or external connections.
Related Guides
Use these references when the format choice, preservation limits, or document handoff matters as much as the immediate conversion.
Frequently Asked Questions
Yes in array-of-objects mode. Array-of-arrays mode keeps the first row as a normal row instead.
Blank names become column_N, and repeated names receive _2, _3, and later suffixes in a deterministic order.
Formulas are never executed or exported as active formulas. A cached value is used when the workbook provides one.
Cells parsed as dates are exported as ISO 8601 strings so the value is explicit and portable.
Yes. Select array-of-arrays to preserve rows without creating object keys from a header row.
Related Tools
Browse all Office Converter tools or review adjacent developer data tools.