GeoIP2 Connection Type CSV Database

In addition to our MaxMind DB binary format, we also offer GeoIP2 databases in a CSV format suitable for importing into a SQL database. This documentation details the format of those CSV files. The CSV files are shipped as a single zip file.

Product Information

To learn more about the GeoIP2 Connection Type database, including terms and pricing, please visit the GeoIP2 Connection Type Database page.

Zip File

The zip file itself is named GeoIP2-Connection-Type-CSV_{YYYYMMDD}.zip. The downloaded zip file contains a single directory which in turn contains several files. That directory is named GeoIP2-Connection-Type-CSV_{YYYYMMDD}.

The files in this zip archive are:

Filename Description
LICENSE.txt End user license
COPYRIGHT.txt Copyright statement
GeoIP2-Connection-Type-Blocks-IPv4.csv CSV file containing data on IPv4 addresses
GeoIP2-Connection-Type-Blocks-IPv6.csv CSV file containing data on IPv6 addresses

CSV File Format

All the CSV files start with a single header row containing column names. The specific column names and their contents are detailed below. The files are encoded as UTF-8.

Blocks Files

There are two CSV files for network blocks, one each for IPv4 and IPv6 blocks. These are named GeoIP2-Connection-Type-Blocks-IPv4.csv and GeoIP2-Connection-Type-Blocks-IPv6.csv respectively.

Name Type Description
network IP network as a string This is the IPv4 or IPv6 network in CIDR format such as “2.21.92.0/29” or “2001:4b0::/80”. We offer a utility to convert this column to start/end IPs or start/end integers. See the conversion utility section for details.
connection_type string One of the following values: Dialup, Cable/DSL, Corporate, or Cellular. Additional values may be added in the future.

Conversion Utility

We’ve created a small utility program to allow you to convert a GeoIP2 CSV file’s representation of IP addresses to another format. You can choose between start/end IP addresses, with the addresses represented as strings or integers.

The program is available from our geoip2-csv-converter GitHub project releases tab.