Export Well-Architected content to XLSX Spreadsheet

Authors

  • Eric Pullen, Performance Efficiency Lead Well-Architected

Introduction

The purpose of this lab is to teach you how to use the AWS SDK for Python (Boto3) to retrieve all of the questions, best practices, and improvement plan links for each lens and export the results to a XLSX spreadsheet. You can use this spreadsheet to prepare for upcoming Well-Architected reviews or to utilize WA reviews in non-supported regions.

Prerequisites:

  • An AWS Account that you are able to use for testing, that is not used for production or other purposes.
  • An Identity and Access Management (IAM) user or federated credentials into that account that has permissions to use Well-Architected Tool (WellArchitectedConsoleFullAccess managed policy).
  • Python 3.9+
  • AWS SDK for Python (Boto3) installed

Costs:

  • There are no costs for copying or creating new WellArchitected Reviews

Steps: