IP2Location™ IP Conversion Excel Add-In

IP2Location IP Conversion Excel Add-In is a free add-in that enables users to convert a IPv4 address into an IP Number and vice-versa.

Note: IP number is being used in the IP2Location database because it is more efficient to search between a range of numbers in a database. Please visit this page if you wish to learn more about conversion in PHP, ASP and other programming languages.


  • Microsoft Office (2007, 2010 or 2013) running on Microsoft Windows.
  1. Follow the steps in the README.TXT inside the zipped file.
  2. Screenshot of getting IP Numbers from Column A.
  3. Screenshot of getting IP Address from Column D.
IP2Location IP Conversion Excel Functions
Function Name Input Description
IPAddress_IPNumber(strIP) IP Address Returns IP numbers.
IPNumber_IPAddress(double) IP Numbers Returns IP address.