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. Download this payload or convert it directly into Excel spreadsheets in 1 click.

Convert this Generic JSON to Excel or CSV

Instantly flatten and preview these records in multi-column tables. Auto-unwinds nested objects without writing Python or Power Query.

100% Client-Side in Your Browser (Zero Data Upload)

Convert to Excel

complex-nested-json-example.json

Convert Generic to Excel Online →

[
  {
    "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
    }
  }
]

Payload Size

715 Bytes

Format

JSON (Multi-level Nested)

Compatible Tools

Excel (XLSX), CSV, Pandas, Power BI

License

Public Domain / MIT (Free for Testing)