JSON to Excel Converter

Features of This Tool

• Supports JSON to Excel/CSV conversion.
• Imports JSON from file, text input, or web URL.
• Automatically flattens nested objects into dotted-key columns.
• Expands arrays of objects into separate parent.key columns.
• Handles single-object JSON by converting it to an array.
• Field mapping with drag-and-drop reorder and up/down arrows.
• Choose output format (.xlsx, .xls, .csv) and customize file name.
• Include/exclude header row.
• Responsive, mobile-friendly design with progress indicator.

How to Use This Tool

1. Load JSON: Upload a JSON file, paste JSON text, or enter a JSON URL, then click Load JSON or Fetch JSON.
2. Configure Options: Select your desired output format, file name, and header settings.
3. Map Fields: Check/uncheck fields, rename columns, and reorder via drag-and-drop or arrows.
4. Generate Excel: Click Generate Excel to download the file. Watch the progress bar for large datasets.

[
  {
    "id": 1,
    "name": "John Doe",
    "age": 30,
    "isActive": true,
    "birthdate": "1993-10-01",
    "address": {
      "street": "123 Main St",
      "city": "New York",
      "zip": "10001"
    },
    "orders": [
      { "orderId": 101, "item": "Laptop", "price": 999.99 },
      { "orderId": 102, "item": "Mouse", "price": 29.99 }
    ]
  },
  {
    "id": 3,
    "name": "Bob Johnson",
    "age": 40,
    "isActive": true,
    "birthdate": "1983-03-22",
    "address": {
      "street": "789 Pine Rd",
      "city": "Chicago"
    },
    "orders": []
  },
  {
    "id": 2,
    "name": "Jane Smith",
    "age": 25,
    "isActive": false,
    "birthdate": "1998-05-15",
    "address": {
      "street": "456 Oak Ave",
      "city": "Los Angeles",
      "zip": "90001"
    },
    "orders": [
      { "orderId": 201, "item": "Phone", "price": 699.99 }
    ]
  }
]