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, or 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.





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 NameInputDescription
IPAddress_IPNumber(strIP)IP AddressReturns IP numbers.
IPNumber_IPAddress(double)IP NumbersReturns IP address.
Thank you for downloading

Sharing this great stuff to your friends!

Or share it on your blog or web page:

Free IP2Location geolocation resources available at <a href="http://www.ip2location.com">http://www.ip2location.com</a>
Copy & paste this text as HTML.