JSON Swiss

JSON Swiss

Konverter Excel ke JSON

Butuh konversi sebaliknya?
JSON to Excel Converter

Input Spreadsheet

Import a spreadsheet file to convert to JSON

Supports .xlsx, .xlsm, .xls, and .csv files

Output JSON

Pengaturan

Spreadsheet Import Options

Import a spreadsheet file to convert to JSON

Supports .xlsx, .xlsm, .xls, and .csv files

Cara mengonversi Excel ke JSON online – panduan langkah demi langkah

Gunakan konverter Excel → JSON ini untuk mengubah spreadsheet menjadi array atau object JSON untuk API, database, dan aplikasi web.

  1. Langkah 1 – Unggah file Excel

    • Unggah file .xlsx, .xlsm, atau .xls.
    • Pratinjau spreadsheet untuk sheet yang dipilih muncul di sisi kiri.
    • Untuk CSV, gunakan alat CSV→JSON atau konversi ke format Excel terlebih dahulu.

  2. Langkah 2 – Atur opsi konversi

    • Pilih worksheet yang akan dikonversi (untuk workbook multi-sheet).
    • Aktifkan “Baris pertama berisi header” untuk menggunakan baris pertama sebagai kunci JSON.
    • Opsional: tentukan range (mis., A1:D100) untuk mengonversi sebagian sheet saja.

  3. Langkah 3 – Tinjau output JSON

    • Saat header aktif, JSON menjadi array of objects (satu object per baris).
    • Setiap baris menjadi object JSON: header sebagai key, nilai sel sebagai value.
    • Periksa format tanggal, angka, dan teks sudah sesuai di output JSON.

  4. Langkah 4 – Salin atau unduh JSON

    • Gunakan “Copy” untuk menyalin array JSON ke clipboard.
    • Gunakan “Download” untuk menyimpan sebagai file .json.
    • Impor ke database, kirim ke API, atau gunakan di aplikasi frontend.

Quick tips for Excel to JSON

  • Keep one header row at the top so each JSON object gets consistent keys.
  • Dates and numbers are read as they appear in the spreadsheet; double-check them before sending to APIs.
  • Turn off auto-sync when you want to batch several spreadsheet edits, then use the update button to refresh the JSON once.
Example: Excel spreadsheet to JSON array
// Excel spreadsheet (with headers)
| Name        | Email              | Age | Active |
|-------------|--------------------|-----|--------|
| Maeve       | [email protected] | 28  | true   |
| Alex        | [email protected]   | 32  | false  |

// JSON output
[
  {
    "Name": "Maeve",
    "Email": "[email protected]",
    "Age": 28,
    "Active": true
  },
  {
    "Name": "Alex",
    "Email": "[email protected]",
    "Age": 32,
    "Active": false
  }
]

Related Excel & JSON tools

Work with spreadsheet data and JSON using these complementary conversion and formatting tools.

converter.excelToJson.related.cards.jsonToExcel.title

converter.excelToJson.related.cards.jsonToExcel.description

converter.excelToJson.related.cards.csvToJson.title

converter.excelToJson.related.cards.csvToJson.description

JSON Formatter

Format and validate the JSON output for readability and error checking.

JSON Validator

Validate the generated JSON to ensure correct structure and syntax.

Pertanyaan yang Sering Diajukan

What Excel formats are supported?

This tool supports .xlsx, .xlsm (macro-enabled), legacy .xls, and .csv files. Excel workbooks can contain one or many sheets, while CSV files open as a single sheet preview.

How does sheet selection work?

After importing a spreadsheet file, you can select which sheet to convert using the dropdown in settings. Sheet names are detected automatically from Excel workbooks, and CSV files are loaded as a single sheet.

Can I convert specific cell ranges?

Yes. Use the range option in settings to specify a cell range like 'A1:D10'. Leave it empty to convert the entire used range of the selected sheet.

How are headers handled?

When 'First row contains headers' is enabled, the first row values become JSON object keys. When disabled, generic keys like 'Column1', 'Column2' are used.

Is my data secure?

Yes, all data processing happens entirely in your browser. Your spreadsheet file is parsed locally and never sent to any server, ensuring completely private and secure conversion.