FREE

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 an input parameter. It is using the IP2Location BIN database as internal lookup reference and the IP2Location ActiveX component as lookup engine. It does not require an external network connection.

Pre-requisites

  • .NET Framework 4.6.1
  • Microsoft Office (2007, 2010, 2013, 2016 or 2019) running on Microsoft Windows.
Installation
  1. Follow the steps in the README.TXT inside the zipped file.
  2. Get the geo location information as simple as using the function from Excel.
  3. Screenshot of geo location information for the corresponding IP Address on Column A.
IP2Location Excel Functions
Function Name Input Description
IP2Location_AreaCode(strIP) IP Address Returns area code of a given IP address.
IP2Location_City(strIP) IP Address Returns city of a given IP address.
IP2Location_CountryLong(strIP) IP Address Returns country name of a given IP address.
IP2Location_CountryShort(strIP) IP Address Returns country code of a given IP address.
IP2Location_Domain(strIP) IP Address Returns domain of a given IP address.
IP2Location_Elevation(strIP) IP Address Returns the average height of city above sea level in meters of a given IP address.
IP2Location_IDDCode(strIP) IP Address Returns IDD code of a given IP address.
IP2Location_ISP(strIP) IP Address Returns Internet Service Provider name of a given IP address.
IP2Location_Latitude(strIP) IP Address Returns latitude of a given IP address.
IP2Location_Longitude(strIP) IP Address Returns longitude of a given IP address.
IP2Location_MCC(strIP) IP Address Returns Mobile Country Codes (MCC) of a given IP address.
IP2Location_MNC(strIP) IP Address Returns Mobile Network Code (MNC) of a given IP address.
IP2Location_MobileBrand(strIP) IP Address Returns commercial brand associated with the mobile carrier of a given IP address.
IP2Location_NetSpeed(strIP) IP Address Returns net speed of a given IP address.
IP2Location_Region(strIP) IP Address Returns region of a given IP address.
IP2Location_TimeZone(strIP) IP Address Returns time zone of a given IP address.
IP2Location_UsageType(strIP) IP Address Returns the usage type classification (commercial, organization, government and so on) of a given IP address.
IP2Location_WeatherStationCode(strIP) IP Address Returns special code to identify the nearest weather observation station of a given IP address.
IP2Location_WeatherStationName(strIP) IP Address Returns the nearest weather observation station of a given IP address.
IP2Location_ZIPCode(strIP) IP Address Returns ZIP Code (US only) of a given IP address.