iam2excel

Convert AWS IAM policy JSON files into beautifully formatted Excel (.xlsx) workbooks.

Install

pip install iam2excel

Or install directly from source:

pip install .

CLI Usage

iam2excel path/to/policy.json
# → writes policy.xlsx next to the JSON file

iam2excel path/to/policy.json -o /tmp/my_report.xlsx

Python API

from iam2excel import convert

# from a file path
out = convert("my_policy.json")
print(out)  # /absolute/path/to/my_policy.xlsx

# custom output path
out = convert("my_policy.json", output_path="reports/iam_audit.xlsx")

# from a dict (already parsed)
import json
policy = json.load(open("policy.json"))
out = convert(policy, output_path="audit.xlsx")

Excel Workbook Structure

The output workbook contains 4 sheets:

Colour legend

Example IAM JSON

{
  "Version": "2012-10-17",
  "Statement": [
    {
      "Sid": "AllowS3ReadOnly",
      "Effect": "Allow",
      "Action": ["s3:GetObject", "s3:ListBucket"],
      "Resource": ["arn:aws:s3:::my-bucket", "arn:aws:s3:::my-bucket/*"],
      "Condition": {
        "StringEquals": { "aws:RequestedRegion": "us-east-1" }
      }
    },
    {
      "Sid": "DenyDelete",
      "Effect": "Deny",
      "Action": "s3:DeleteObject",
      "Resource": "*"
    }
  ]
}