IP2Location™ Excel Add-In

IP2Location Excel Add-In is a free add-in that enables end-users to detect country, region, city, latitude, longitude, ZIP code, ISP, domain name, time zone, connection speed, IDD code, area code, weather station code, weather station name, MCC, MNC, mobile brand name, elevation, and usage type by using an IP address as input parameter. It is using IP2Location BIN database as internal lookup reference and IP2Location ActiveX component as lookup engine. It does not required external network connection. IP2Location ActiveX component with BIN database is available separately as a commercial product.

 

Pre-requisites

 

Installation

Follow the steps in the README.TXT inside the zipped file.

 

Screenshots

Get the geo location information as simple as using the function from Excel.

Screenshot of geo location information for the corresponding IP Address on Column A.

 

IP2Location Excel Functions

Function NameInputDescription
IP2Location_AreaCode(strIP)IP AddressReturns area code of a given IP address.
IP2Location_City(strIP)IP AddressReturns city of a given IP address.
IP2Location_CountryLong(strIP)IP AddressReturns country name of a given IP address.
IP2Location_CountryShort(strIP)IP AddressReturns country code of a given IP address.
IP2Location_Domain(strIP)IP AddressReturns domain of a given IP address.
IP2Location_Elevation(strIP)IP AddressReturns the average height of city above sea level in meters of a given IP address.
IP2Location_IDDCode(strIP)IP AddressReturns IDD code of a given IP address.
IP2Location_ISP(strIP)IP AddressReturns Internet Service Provider name of a given IP address.
IP2Location_Latitude(strIP)IP AddressReturns latitude of a given IP address.
IP2Location_Longitude(strIP)IP AddressReturns longitude of a given IP address.
IP2Location_MCC(strIP)IP AddressReturns Mobile Country Codes (MCC) of a given IP address.
IP2Location_MNC(strIP)IP AddressReturns Mobile Network Code (MNC) of a given IP address.
IP2Location_MobileBrand(strIP)IP AddressReturns commercial brand associated with the mobile carrier of a given IP address.
IP2Location_NetSpeed(strIP)IP AddressReturns net speed of a given IP address.
IP2Location_Region(strIP)IP AddressReturns region of a given IP address.
IP2Location_TimeZone(strIP)IP AddressReturns time zone of a given IP address.
IP2Location_UsageType(strIP)IP AddressReturns the usage type classification (commercial, organization, government and so on) of a given IP address.
IP2Location_WeatherStationCode(strIP)IP AddressReturns special code to identify the nearest weather observation station of a given IP address.
IP2Location_WeatherStationName(strIP)IP AddressReturns the nearest weather observation station of a given IP address.
IP2Location_ZIPCode(strIP)IP AddressReturns ZIP Code (US only) of a given 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.