IP2Location (bhbkibfamajihabmhlebcllfmijlflnm): Provides an easy way to get IP geolocation data via the IP2Location Web Service.... Read More > or Download Now >
IP2Location for Google Sheets
Tech Specs
- • Type: Google Sheets Add-on
- • Latest Version: 12
- • Price: Freeware
- • Offline: No
- • Developer: Hexasoft
User Reviews
- • Rating Average
- 1.7 out of 5
- • Rating Users
- 15
Download Count
- • Total Downloads
- 3
- • Current Version Downloads
- 3
- • Updated: July 17, 2019
IP2Location is a free Productivity Add-on for Google Sheets. You could download the latest version crx file or old version crx files and install it.
More About IP2Location
This add-on provides a custom function called IP2Location to retrieve IP geolocation data for an IP address using the IP2Location Web Service.
Just sign up for API key at https://www.ip2location.com/web-service and enter the key into the add-on settings to use.
Example for querying a single IP address
========================================
You have an IP address in cell A1. In cell B1, you key in =IP2Location(A1). The results will occupy cells B1 to U1 and contains the country code, country name, region, city, latitude, longitude, zip code, time zone, isp, domain, net speed, idd code, area code, weather station code, weather station name, mcc, mnc, mobile brand, elevation and usage type.
Example for querying a list of IP addresses
===========================================
You have IP addresses in cells A1 to A3. In cell B1, you key in =IP2Location(A1:A3). The results will be similar to the single query except each row will contains the results for that row's IP address.
Learn more about the functions at https://www.ip2location.com/free/sheet-addon
Just sign up for API key at https://www.ip2location.com/web-service and enter the key into the add-on settings to use.
Example for querying a single IP address
========================================
You have an IP address in cell A1. In cell B1, you key in =IP2Location(A1). The results will occupy cells B1 to U1 and contains the country code, country name, region, city, latitude, longitude, zip code, time zone, isp, domain, net speed, idd code, area code, weather station code, weather station name, mcc, mnc, mobile brand, elevation and usage type.
Example for querying a list of IP addresses
===========================================
You have IP addresses in cells A1 to A3. In cell B1, you key in =IP2Location(A1:A3). The results will be similar to the single query except each row will contains the results for that row's IP address.
Learn more about the functions at https://www.ip2location.com/free/sheet-addon
