Generic Test Payload

Highly Complex Nested JSON Dummy Dataset

A generic, incredibly messy JSON structure containing arrays of objects, objects containing arrays, missing keys, and diverse data types to test JSON flattening edge cases. Use this payload to test JSON flattening, data loading pipelines, or database seeding.

Struggling to convert your own JSON?

Don't write another Python script. Use our free, 100% secure client-side tool to flatten any complex JSON export into a perfect Excel file in seconds.

Data never leaves your browser window.

Repair Your Export

payload.json

[
  {
    "id": "REC-001",
    "timestamp": "2024-01-01T00:00:00Z",
    "user": {
      "profile": {
        "name": "Admin User",
        "settings": {
          "theme": "dark",
          "notifications": [
            "email",
            "sms"
          ]
        }
      }
    },
    "events": [
      {
        "type": "login",
        "ip": "192.168.1.1"
      },
      {
        "type": "click",
        "element": "btn_submit",
        "duration_ms": 120
      }
    ]
  },
  {
    "id": "REC-002",
    "timestamp": "2024-01-02T00:00:00Z",
    "user": {
      "profile": null
    },
    "events": [],
    "anomalies": {
      "code": 404,
      "details": "[object Object]",
      "trace": null
    }
  }
]

Dataset Size

715 Bytes

Format

JSON (Nested)

License

MIT (Free to use)