WilliamLam.com

  • About
    • About
    • Privacy
  • VMware Cloud Foundation
  • VKS
  • Homelab
    • Resources
    • Nested Virtualization
  • VMware Nostalgia
  • Apple
You are here: Home / Automation / Quick Tip - Convert VMware Cloud Foundation (VCF) Deployment Workbook XLSX to JSON

Quick Tip - Convert VMware Cloud Foundation (VCF) Deployment Workbook XLSX to JSON

02.17.2023 by William Lam // 2 Comments

The deployment wizard for VMware Cloud Builder (CB) can accept either an XLSX or JSON configuration file that describes your desired VMware Cloud Foundation (VCF) deployment.


Interestingly enough, only an XLSX template is available for users to download, edit and then provide that back as user input. While I can appreciate the rich logic that has been built into the CB workbook, I personally would prefer to work with something a bit more straight forward like JSON, especially for the ability to easily source control via Git/etc.

I have been spending some time with VCF 4.5 and CB this week and I have always wondered if there was a way to convert to JSON format given an XLSX as the initial input. While poking around the logs, I noticed a reference to the following script /opt/vmware/bringup/scripts/json-generator.sh which is used by CB to convert an XLSX to JSON document.

For those that prefer to work with JSON, you can simply fill out the XLSX template once and then convert that to the equilvenet JSON using following instructions

Step 1 - SCP the completed XLSX document to CB. In my example, the XLSX document is called my-vcf-deploy.xlsx

Step 2 - Run the following command specifying the source XLSX, destination JSON and vcf-ems string for VCF deployment:

/opt/vmware/bringup/scripts/json-generator.sh my-vcf-deploy.xlsx my-vcf-deploy.json vcf-ems

Step 3 - SCP the generated JSON configuration file back to your local system and you can now use that as input to CB.

More from my site

  • ESXi on GMKtec NucBox K11
  • Quick Tip - VMware Cloud Foundation (VCF) Bringup fails without persistent ESX-OSData
  • Enhancements to VMware Cloud Foundation (VCF) & vSphere Automated Lab Deployment Scripts
  • vSAN ESA hardware mock VIB for physical ESXi deployment for VMware Cloud Foundation (VCF)
  • Quick Tip - Easily host VMware Cloud Foundation (VCF) Offline Depot using Python SimpleHTTPServer with Authentication

Categories // Automation, VMware Cloud Foundation Tags // VMware Cloud Foundation

Comments

  1. *protectedhisham gamil says

    09/22/2023 at 10:15 pm

    this works with VCF 5 as well ?

    Reply
    • William Lam says

      09/23/2023 at 4:22 am

      yes, it should work the same

      Reply

Thanks for the comment!Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Search

Thank Author

Author

William is Distinguished Platform Engineering Architect in the VMware Cloud Foundation (VCF) Division at Broadcom. His primary focus is helping customers and partners build, run and operate a modern Private Cloud using the VMware Cloud Foundation (VCF) platform.

Connect

  • Bluesky
  • Email
  • GitHub
  • LinkedIn
  • Mastodon
  • Reddit
  • RSS
  • Twitter
  • Vimeo

Recent

  • VMUG Connect 2025 - Minimal VMware Cloud Foundation (VCF) 5.x in a Box  05/15/2025
  • Programmatically accessing the Broadcom Compatibility Guide (BCG) 05/06/2025
  • Quick Tip - Validating Broadcom Download Token  05/01/2025
  • Supported chipsets for the USB Network Native Driver for ESXi Fling 04/23/2025
  • vCenter Identity Federation with Authelia 04/16/2025

Advertisment

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy

Copyright WilliamLam.com © 2025

 

Loading Comments...