CSVCSV Dock
All CSV tools

Private, local-first data tools

Excel to JSON

Convert an XLSX or XLS worksheet to JSON locally. Select a sheet, review headers and choose objects, arrays or JSON Lines before export.

Processed in your browserNo account requiredEncoding and delimiter controlsIncomplete exports are blocked
JSON export options
Empty cells can be converted to null only when type inference is enabled.
Drop a file, paste data, load a CORS-enabled URL, or try the sample.
Rows0
Columns0
EncodingAuto
DelimiterAuto
Issue groups0

Open a data file to start

The parser runs off the main thread. Once loaded, you can search, sort, validate, repair and export without an account.

Compare the input and output

This synthetic table checks leading-zero IDs, punctuation and empty values. For Excel, use these values in a worksheet; for TSV, separate the three fields with tabs.

id,name,note
00123,Ada,A&B
00456,Grace,

Select objects with type inference off. Empty cells remain empty strings.

[
  {
    "id": "00123",
    "name": "Ada",
    "note": "A&B"
  },
  {
    "id": "00456",
    "name": "Grace",
    "note": ""
  }
]

Open the downloaded file in the destination and verify two records with identifiers 00123 and 00456.

What this tool does

Excel to JSON

Select one worksheet from an XLSX or XLS workbook. Its header row becomes the keys for JSON objects. Export one sheet at a time; worksheets are not merged automatically. Formula results depend on cached values in the workbook: this tool does not calculate Excel formulas.

How to use it

  1. Choose the source file and inspect the headers and column boundaries.
  2. Select the available settings or worksheet and check identifiers, empty cells and punctuation.
  3. Confirm the export row scope, download the result and inspect it in the destination.

Common tasks

  • Formatted identifiers and dates should be checked against the source worksheet. Choose arrays instead of objects when column names are not suitable as keys.
  • Inspect identifiers and empty cells before using Excel to JSON for a downstream import.
  • Choose the required records and download the Excel to JSON result without uploading local files.

Privacy and local processing

Local files are read by a dedicated browser worker and are not uploaded to an application server. File contents and filenames are not included in analytics events. Loading a public URL is an explicit direct request from your browser and may fail when the remote server blocks CORS.

Supported edge cases

  • Formatted identifiers and dates should be checked against the source worksheet. Choose arrays instead of objects when column names are not suitable as keys.

Frequently asked questions

Are local files uploaded?

Local files are processed in your browser. Loading a public URL makes a direct request from your browser to that URL.

What output limitations should I check?

Formatted identifiers and dates should be checked against the source worksheet. Choose arrays instead of objects when column names are not suitable as keys.