Found this while trying to figure out why my view was "Flat".
Turns out that only option 1 and 3 are supported in Excel. Option 2 is displayed as "Flat" instead of a tree view like in Azure DevOps.
Azure Devops Query Type Dropdown (Seems like I cannot embed images yet)