Database Formats

GeoIP2 and GeoLite2 databases are available in our MMDB format or as CSV files. The MMDB format has been highly optimized for IP lookup performance, and is the preferred format for use in production. The CSV format may be easier to work with, especially if you want to join or merge your GeoIP2 or GeoLite2 data with other sources, or if you want to do manual queries or manipulation of the data.

MMDB format

The MMDB (MaxMind database) format has been developed especially for IP lookup. It is optimized to perform lookups on data indexed by IP network ranges quickly and efficiently. If you want the best performance on your IP lookups for use in a production environment, you should use the MMDB format files. You can read the technical MMDB format specifications on the MMDB github page.

We maintain a number of client APIs so that you can perform lookups on MMDB files in your preferred programming language. Learn more about our MMDB APIs on our developer portal.

CSV format

We also offer our GeoIP2 and GeoLite2 databases for download in the standard CSV (comma separate values) format. CSV files can easily be imported into other database platforms like SQL. We maintain guides on importing CSV files into database platforms on our developer portal.

Because it is such a common format, our CSV files may be easier to work with if you want to join or merge GeoIP2 data with data from other IP geolocation or IP data providers, or from your own records. It may also be easier to do manual analysis of the GeoIP2 data using standard data analysis tools and platforms using the CSV file.

You can read the full specifications for our CSV files on our developer portal.

This page was last updated on .

Was this article helpful?