Amazon website is limited to 50 instances per page. Viewing lots of instances is a pain and it doesn’t support exporting to CSV/TSV/Excel/other out of the box. The only fix is to use the CLI.
- An AWS account with access rights to see your servers
- A pair of AWS keys (Users -> [username] -> Security Credentials -> Create Access Key)
# Install AWS packages sudo apt-get install -y python python-pip sudo pip install aws-shell
# aws-shell will show a wizard to configure your account and region the first time you use it aws-shell ec2 describe-instances --output text --query 'Reservations[*].Instances[*].[InstanceId, InstanceType, ImageId, State.Name, LaunchTime, Placement.AvailabilityZone, Placement.Tenancy, PrivateIpAddress, PrivateDnsName, PublicDnsName, [Tags[?Key==`Name`].Value] , [Tags[?Key==`purpose`].Value] , [Tags[?Key==`environment`].Value] , [Tags[?Key==`team`].Value]  ]' > instances.tsv # open instances.tsv with Excel # enjoy
You can modify the command to pick the information you want. Refer to the official AWS command line reference.