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
- Follow the steps in the README.TXT inside the zipped file.
-
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 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. |
