Excel to JSON: Export Spreadsheet Data as a JSON Array

2026-07-05

  • Excel
  • JSON
  • API
  • convert
  • online tool
  • tutorial

Why convert Excel to JSON

Frontend mocks, API docs, low-code imports, and Node/Python scripts all prefer JSON arrays over xlsx. Copy-paste breaks columns easily. ComTools Excel to JSON (Tools/Excel/ToJson) uploads a sheet and downloads a pretty-printed .json file.

Conversion rules

Item Details
Input .xlsx, .xlsm, .xltx, .xltm, .csv
Worksheet First sheet only
Structure Row 1 → property names; row 2+ → array items
Values Cell display text as strings
Output UTF-8 JSON, indented for readability

Input (Excel)

id name email
1 Alice alice@example.com
2 Bob bob@example.com

Output (JSON)

[
  {
    "id": "1",
    "name": "Alice",
    "email": "alice@example.com"
  },
  {
    "id": "2",
    "name": "Bob",
    "email": "bob@example.com"
  }
]

Empty sheets return [].

Steps

  1. Open Excel to JSON.
  2. Select or drop your Excel / CSV file.
  3. Click Convert.
  4. Download the .json file.

Common scenarios

Scenario Next step
Frontend list mock import data from './users.json'
API sample payload Validate with JSON Formatter
Load into a database Prefer Excel to SQL INSERT
Diff two versions Excel Compare
One sheet from many Split or move sheet to first position

Notes

  • Numbers are strings—"1" not 1; parse in code if needed.
  • Dates follow Excel display format; standardize as yyyy-MM-dd in source.
  • Duplicate headers—later columns may overwrite keys; keep unique headers.
  • Large files—JSON can be huge; export fewer columns or use CSV export.
  • Privacy—server-side conversion; use trusted hosts for sensitive data.

Other JSON entry points

Source Tool
Excel / CSV file Excel to JSON
CSV text CSV to JSON (local browser)
JSON back to table JSON to CSV or CSV to Excel

Suggested workflow

Business Excel → dedup → JSON → frontend / Postman
              └→ SQL → database (persistence)

FAQ

Can I pick a sheet?
Only the first worksheet—split or reorder sheets first.

Nested JSON?
Flat array of objects only; build nesting in code after export.

CSV encoding issues?
Save as UTF-8 or CSV to Excel to inspect.

vs Excel to XML?
JSON fits Web/API; Excel to XML for enterprise exchange formats.

中文版