These scripts use the boto3 library to make AWS API calls. So if you don't have it, do:

pip install boto3

tags-to-csv.py

This script will put all ec2 instances with their tags into a spreadsheet. One instance per row with the instance ID in col A. tag-keys are separated into columns. If a instance doesn't have a tag, the cell will be left blank. Otherwise the tag-value is placed into the corresponding cell.

usage: tags-to-csv [-h] -o OUTPUT_FILE [-r AWS_REGION] [-v]

Get instance tags in CSV format.

optional arguments:
  -h, --help            show this help message and exit
  -o OUTPUT_FILE, --out OUTPUT_FILE
                        path to where the output should be written
  -r AWS_REGION, --region AWS_REGION
                        AWS region to use.
  -v, --version         show program's version number and exit

Example usage:

python tags-to-csv.py -o tags.csv --region 'us-east-1'

---

csv-to-tags.py

This script will append tags to EC2 instances using a CSV file.

Example CSV file:

Instance-id	cluster	environment
i-xxxxxxxx	web	dev
i-xxxxxxxx	application	prod

usage: csv-to-tags [-h] -i INPUT_FILE [-r AWS_REGION] [-v]

Append tags to EC2 instances from a CSV file.

optional arguments:
  -h, --help            show this help message and exit
  -i INPUT_FILE, --in INPUT_FILE
                        path to where the input file is located.
  -r AWS_REGION, --region AWS_REGION
                        AWS region to use.
  -v, --version         show program's version number and exit

Example usage:

python csv-to-tags.py -i tags.csv --region 'us-east-1'