Excel to JSON

Convert Excel (XLSX, XLS) to JSON online. Array of objects or arrays, all sheets in one file, sanitized keys. 100% client-side.

JSON options

Drag & drop Excel files here

or

Related Tools

What This Excel to JSON Tool Offers

This free Excel to JSON converter runs in your browser with full control over format and keys. Use the first row as headers, sanitize keys for APIs, combine all sheets into one JSON, or output minified JSON—all without uploading your data.

  • First row as headers: Use the first row as object keys (array of objects) or output raw rows (array of arrays).
  • Sanitize keys: Convert header names to API-friendly keys: lowercase, underscores, no special characters.
  • All sheets in one JSON: Output one object with sheet names as keys, e.g. { "Sheet1": [...], "Sheet2": [...] }.
  • Minified output: Option to output single-line JSON for smaller file size.
  • Copy or download: Copy JSON to clipboard or download as a file. Apply options to JSON to regenerate without re-uploading.
  • Client-side and private: Conversion happens in your browser; files are never uploaded.

Why Convert Excel to JSON?

JSON is the standard format for APIs, web apps, and data pipelines. Converting Excel to JSON lets you feed spreadsheet data into scripts and services.

  • APIs and apps: Use the JSON in backend or frontend code.
  • Data pipelines: Import into databases or ETL tools that accept JSON.

How Excel to JSON Conversion Works

Your Excel file is read in the browser and converted to JSON using your chosen options. You can change settings and click Apply options to JSON to regenerate without re-uploading.

  • Set options: Choose first row as headers, sanitize keys, all sheets in one JSON, and minified output.
  • Upload Excel: Drag-and-drop or select XLSX/XLS files.
  • Choose sheet or all: Select a single sheet from the dropdown, or use all sheets in one JSON to get an object keyed by sheet name.
  • Get JSON: Copy or download the JSON. Use Apply options to JSON to update with new settings. All processing is client-side.

Powered by client-side spreadsheet processing (SheetJS).

Frequently Asked Questions

What JSON format is produced?

With first row as headers you get an array of objects; otherwise an array of arrays. You can optionally output all sheets in one JSON as an object with sheet names as keys (e.g. "Sheet1" and "Sheet2" as keys).

What does sanitize keys do?

When first row as headers is on, sanitize keys converts header names to API-friendly keys: trimmed, lowercase, spaces to underscores, and special characters removed (e.g. "Item Name" becomes "item_name").

Is my data secure?

Yes. Conversion runs entirely in your browser. Your files never leave your device.

Can I use the JSON in my app?

Yes. The output is standard JSON. Use copy or download; the minified option produces a single-line JSON for smaller file size. Use Apply options to JSON to change settings without re-uploading.