Help & Support
Send Feedback
IP2Location
Provides an easy way to get IP geolocation data via the IP2Location Web Service.
Hexasoft
3 users
Works with
Install
Overview
NOTE: This app is free but it requires a paid subscription to a web service to work.

Example for querying a single IP address (using the default WS24 package)
=========================================================================
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 (using the default WS24 package)
============================================================================
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.

Example for querying a single IP address (specify WS1 to WS24 package)
======================================================================
You have an IP address in cell A1. In cell B1, you key in =IP2Location(A1, "WS3"). The results will occupy cells B1 to U1 and contains the country code, country name, region and city. Fields not in the package will be blank.

Example for querying a list of IP addresses (specify WS1 to WS24 package)
=========================================================================
You have IP addresses in cells A1 to A3. In cell B1, you key in =IP2Location(A1:A3, "WS3"). 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/plugins/others/sheet-add-on
Reviews
A User of IP2Location
August 29, 2016
good ip is location help all
Submit reply
Cancel
A User of IP2Location
August 16, 2016
It's really good but would be great if is free
Submit reply
Cancel
1-2 of 2
Additional information
Search
Clear search
Close search
Google apps
Main menu