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.

Download

Pre-requisites

Microsoft Office (2007, 2010 or 2013) running on Microsoft Windows.

Installation

Follow the steps in the README.TXT inside the zipped file.
Screenshot of getting IP Numbers from Column A.
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.