Download

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: Screenshot: LibreOffice

Imported SQL export in DB Browser for SQLite: Screenshot: DB Browser for SQLite

Spreadsheet

Comma Separated Values (CSV) file with GCE machine types and Google Cloud regions.

Download CSV (1.94 MB)

Database

Gzip compressed Structured Query Language (SQL) export with GCE machine types, disk types, operating system images, Google Cloud regions and zones.

Download SQL (0.23 MB)

Command Line

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

Open Source

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.