Convert Excel spreadsheets to JSON format. Upload XLSX or CSV files and get clean, formatted JSON output instantly.
Converting Excel spreadsheets (XLS/XLSX) to JSON transforms tabular data into the structured format used by web APIs, databases, and modern applications. Excel remains the most common format for business data — financial reports, inventory lists, customer databases, and project plans — but developers need this data in JSON for integration with web services, NoSQL databases, and configuration systems.
This tool converts Excel files to JSON directly in your browser with no server uploads, supporting multiple sheets, data type preservation, and customizable output structures.
| Format | Structure | Best For |
|---|---|---|
| Array of objects | [{col1: val, col2: val}, ...] | API payloads, MongoDB imports |
| Array of arrays | [[val, val], [val, val], ...] | Raw data processing, matrix operations |
| Nested objects | {key: {col1: val, col2: val}} | Lookup tables, configuration data |
| Keyed by column | {col1: [vals], col2: [vals]} | Column-oriented analytics |
| Excel Type | JSON Mapping | Considerations |
|---|---|---|
| Text | String | Direct mapping |
| Number | Number | Preserve precision for financial data |
| Date | ISO 8601 string | Excel stores dates as serial numbers; convert to ISO format |
| Boolean | true/false | Excel TRUE/FALSE → JSON true/false |
| Empty cell | null or omitted | Decide whether to include null values or skip empty cells |
| Formula | Computed value | Convert the formula result, not the formula itself |
Yes, your data is completely secure. All Excel parsing and JSON conversion happens entirely in your browser using JavaScript. Your file data never leaves your device or gets uploaded to any server, ensuring complete privacy for sensitive spreadsheet information.
The converter offers four output formats: Array of Objects (each row becomes an object, ideal for APIs and databases), Column Arrays (columns as separate arrays, great for charting libraries), Key-Value Pairs (explicit key-value structure for configuration files), and Nested Sheets (all sheets in one object, useful for multi-sheet workbooks).
You can configure how empty cells are handled using three options: Set to null (empty cells become JSON null values), Set to empty string (empty cells become blank strings), or Skip (empty cells are omitted from the output entirely). Choose the option that best matches your target system requirements.
The converter supports all common Excel formats including .xlsx (Excel 2007 and later), .xls (Excel 97-2003), and .xlsm (macro-enabled workbooks). Simply drag and drop your file or click to browse, and the tool will automatically detect and parse the format.
Yes, the converter fully supports multi-sheet workbooks. You can select which sheet to convert from a dropdown menu. If you need all sheets in one JSON file, use the Nested Sheets output format, which creates an object with sheet names as keys and their data as values.
Dates can be formatted in two ways: ISO 8601 format (e.g., 2023-01-15T00:00:00.000Z) which is widely compatible with most programming languages and APIs, or Unix timestamp (seconds since January 1, 1970) which is useful for systems that work with epoch time.
You can toggle off the First row contains headers option. When disabled, the converter will generate automatic column names (Column1, Column2, etc.) instead of using the first row as property names. This is useful for spreadsheets that start directly with data.