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
Extore is a team of professionals who are passionate about creating extensions for web browsers. This devotion also gives us opportunity to appreciate work of other people. We get inspired by useful, open source extensions made by developers all over the world. Our strong belief is that one should share helpful add-ons with others. That’s why we’d like to present you our ever-growing list of favourite extensions that have inspired us. Moreover, as you probably have already learned, sometimes struggling for the best brings an end to the good. Talking about add-ons it often turns out that an upgrade is worse then previous version. Also it can become really tricky to get back to the beloved version of your favourite extension. That’s why we’re going to make not only the latest, but all versions of our favourite (and we hope yours too) add-ons available for download. No more compromises, just stick to the version you really like!
Preparing download link, please wait for seconds
Almost done...
Click to download
Error getting file. Please try again
