You can download a CSV file (1.94 MB) and SQL export (0.23 MB, gzip compressed) with all machine types, disk types, operating system images, Google Cloud regions and zones. You can import and edit the CSV file to your favorite spreadsheet program (MS Excel, LibreOffice or Google Sheets). You can import the SQL dump into your favorite database (like SQLite).
Imported CSV file in LibreOffice spreadsheet program:
Imported SQL export in DB Browser for SQLite:
Comma Separated Values (CSV) file with GCE machine types and Google Cloud regions.
Gzip compressed Structured Query Language (SQL) export with GCE machine types, disk types, operating system images, Google Cloud regions and zones.
With the SQL export you can also do great queries using the command line (CLI).
# Download CSV file curl -O https://gcloud-compute.com/machine-types-regions.csv # Search CSV and count grep 'europe-west4' < machine-types-regions.csv | wc -l # Download SQL export curl -O https://gcloud-compute.com/machine-types-regions.sql.gz # Decompress SQL export gzip -d machine-types-regions.sql.gz # Import SQL dump sqlite3 gce.db < machine-types-regions.sql # SQL query Google Cloud machine types (instances) sqlite3 gce.db 'SELECT name, vCpus, hour FROM instances WHERE vCpus >= 8 AND region LIKE "europe-west4" ORDER BY hour ASC LIMIT 5'
Example SQL output:
e2-highcpu-8|8.0|0.21785232 n2d-highcpu-8|8.0|0.274688 e2-standard-8|8.0|0.29508816 n1-highcpu-8|8.0|0.3119968 n2-highcpu-8|8.0|0.315728
Everything you see here is published as open source software and licensed under the Apache License (version 2.0). You can find the source code on GitHub. Any improvements and pull requests are welcome.