IP2Location 12 CRX for Google Sheets

A Free Productivity Add-on

Published By Hexasoft

Sponsored Links

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

Download CRX


7.37 KB

Chrome Store

Tech Specs

  • • Type: Google Sheets Add-on
  • • Latest Version: 12
  • • Price: Freeware
  • • Offline: No
  • • Developer: Hexasoft

User Reviews

  • 15 Votes, Average: 1.7 out of 5
  • • Rating Average
  • 1.7 out of 5
  • • Rating Users
  • 15

Download Count

  • • Total Downloads
  • 1
  • • Current Version Downloads
  • 1
  • • 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.

Sponsored Links

More About IP2Location

IP2Location Screenshot Image
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

Download IP2Location 12

More Add-ons to Consider (Similar or Related)