ConverterExcel 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
Conversion runs locally in a Web Worker so the interface can remain responsive while spreadsheet data is parsed. Converter247 does not send the selected file or pasted data to an API. Files stay in memory for the current page session and are released when you reset or leave the page.
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.
Blank cells and unsupported workbook features are handled conservatively. The tool blocks over-limit inputs and does not claim to preserve macros, charts, styles, external connections, or complete workbook behavior.
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.