IP2Location™ Google Sheet Add-On
|IP2Location Google Sheet Add-On is a free add-on 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 web service lookup reference. An IP2Location Web Service API key is required for this service to work. Sign up for a key at IP2Location Web Service page.|
- Google Sheet
- IP2Location Web Service API key
- Install from the Google Sheet via the menu (Add-ons -> Get add-ons... -> IP2Location)
- Install from the direct link https://chrome.google.com/webstore/detail/ip2location/bhbkibfamajihabmhlebcllfmijlflnm.
- Click on the Add-ons in the Google Sheet menu. Go to IP2Location -> Edit settings.
- Enter your API key and click Login.
IP2Location Google Sheet Function
|IP2Location(strIP)||Cell or range containing IP address(es)||Returns country code, country name, region name, city name, 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.|
Get the geo location information as simple as using the function from Google Sheet.
NOTE: Do not process more than 400 IPs at a time as Google Sheet has quotas/limitations.
The geo location information for the corresponding IP Address on Column A will now appear.
Now we need to store the results. Select the result cells and right-click. Then click Copy.
Go to another sheet and right-click. Then click Paste special -> Paste values only.
NOTE: We only want to store the values instead of the formula.
Go back to the original sheet and delete the result rows. After that, you can do the next batch of IP addresses.
NOTE: This is so that we don't run the formula on the previously queried IP addresses. Google Sheet will reprocess if you close and reopen the sheet.