multi colored folders piled up

Export AWS Security Groups & rules to CSV

As of this month, October 2021, there’s a super easy way to export AWS security groups & rules to CSV! Yes, finally, go ahead jump up and down! Let’s settle down now, but seriously we have been waiting for a way to export one or more security groups to CSV and export just the AWS security group rules to CSV. This solution is just a click away!

Export all security groups to CSV

  1. Login to the AWS console, navigate to the EC2 service
  2. Select Security Groups
  3. Select the top most square checkbox
  4. You’ll see a big dropdown button that says, “Export Security Groups to CSV“, simply click it!
  5. Done, your CSV will automatically download.
Export AWS security groups to CSV
Exports all selected security groups to CSV
All AWS security groups export in spreadsheet format
All AWS security groups export in spreadsheet format

Export one security group to CSV

  1. Login to the AWS console, navigate to the EC2 service
  2. Select Security Groups
  3. Select the square checkbox just for one or more security groups
  4. You’ll see a big dropdown button that says, “Export Security Groups to CSV“, simply click it!
  5. Done, your CSV will automatically download.
A single AWS security groups export in spreadsheet format
A single AWS security groups export in CSV format

Export all inbound and outbound rules only to CSV

  1. Login to the AWS console, navigate to the EC2 service
  2. Select Security Groups
  3. Select the square checkbox just for one or more security groups
  4. You’ll see a big dropdown button that says, “Export Security Groups to CSV“, this time click on the triangle to view more options. This time select “Export security groups inbound/outbound rules to CSV“.
  5. Done, your CSV will automatically download.
Exporting inbound/outbound rules
Exporting inbound/outbound rules
Inbound/outbound rules in CSV format
Inbound/outbound rules in CSV format

Pro Tip The first two options does include the Tags in the export!

Interested in AWS infrastructure automation? Checkout my previous blogs on Terraform and Terragrunt! Subscribe below to learn more.