AWS EC2 snapshot report generator

less than 1 minute read

Python script to generate a XLSX report containing all EC2 instances in AWS account. Paginating technique has been used for getting EC2 Instances to make sure we receive all AWS resources.


Generated report has the following table header:

Placement Name Instance ID Instance Type Platform Public IP Private IP Instance State LaunchTime AWS Account CPU CPU Utilization Avg ECU memory GiB Volume Size GiB Volume
Size GiB Volume Size GiB                            


$ pip install openpyxl boto3
price.json file ( can be regenerated using python

Run via Python:

$ python AWS-profile-name

Leave a Comment