JsonExport LogoJsonExport
Back to All Datasets
HubSpot Test Payload

Mock HubSpot CRM Contacts & Deals JSON

Authentic HubSpot CRM API payload with nested property dictionaries, deal stages, pipeline values, and association IDs for pipeline reporting. Download this payload or convert it directly into Excel spreadsheets in 1 click.

Convert this HubSpot 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
hubspot-contacts-deals-json.json
{
  "results": [
    {
      "id": "5129481",
      "properties": {
        "firstname": "Sarah",
        "lastname": "Connor",
        "email": "sconnor@cyberdyne.io",
        "company": "Cyberdyne Systems",
        "jobtitle": "VP of Engineering",
        "lifecyclestage": "lead",
        "hs_lead_status": "OPEN",
        "annualrevenue": "25000000",
        "createdate": "2026-03-12T14:23:10.000Z"
      },
      "associations": {
        "deals": {
          "results": [
            {
              "id": "deal_9901",
              "type": "contact_to_deal"
            }
          ]
        }
      }
    },
    {
      "id": "5129482",
      "properties": {
        "firstname": "Marcus",
        "lastname": "Wright",
        "email": "mwright@skynet.com",
        "company": "Skynet Defense",
        "jobtitle": "Director of Infrastructure",
        "lifecyclestage": "customer",
        "hs_lead_status": "IN_PROGRESS",
        "annualrevenue": "120000000",
        "createdate": "2026-04-05T09:12:44.000Z"
      },
      "associations": {
        "deals": {
          "results": [
            {
              "id": "deal_9902",
              "type": "contact_to_deal"
            }
          ]
        }
      }
    }
  ]
}

Payload Size

1,238 Bytes

Format

JSON (Multi-level Nested)

Compatible Tools

Excel (XLSX), CSV, Pandas, Power BI

License

Public Domain / MIT (Free for Testing)