In order to save time creating individual rules in the AWS Management Console, this CloudFormation template uses the AWS Config Excel spreadsheet to define each managed rule. Each managed rule's script parameters, as well as the scope's, are initialized to an empty dictionary. AWS managed rules can be stored in an Excel spreadsheet, and the pattern shows you how to convert that spreadsheet into an AWS CloudFormation template using a Python script. Rather than using a file in the JSON or YAML format, Troposphere can serve as the IaC, allowing for rule updates in an Excel spreadsheet. The managed rules in your AWS account can then be created and updated automatically by launching an AWS CloudFormation stack using the provided template.
