Enrichments /
Gigasheet
No-Code Enrichment with
Gigasheet
How To Use Gigasheet GEO IP Enrichment to Geolocate a List of IP Addresses
Sign Up Free

Use Gigasheet GEO IP Enrichment To Perform Bulk IP Lookup

Gigasheet, the big data spreadsheet can not only open huge files, but also enrich data using no code enrichments. Gigasheet has free built-in enrichments for email and IP addresses.  In this example, we are going to use Gigasheet’s GEO IP Enrichment to geolocate a list of IP addresses.

Provider Website: https://gigasheet.com/
Provider Enrichment Docs: https://support.gigasheet.com/support/solutions/articles/69000699698-can-i-geolocate-ip-addresses-or-do-bulk-geo-ip-lookup-
Endpoint: Built into Gigasheet
Token / Registration Required: No

How To Enrich A Spreadsheet With Gigasheet GEO IP Enrichment:

For this example, my data is a list containing 10 IP addresses. Let’s use the free Gigasheet GEO IP Enrichment to geolocate the IP addresses.

sample data for bulk ip lookup using the Gigasheet GEO IP Enrichment

Step 1. In Gigasheet, click the Enrichments function to bring up the Data Enrichment options.

select Enrichments and then IP Address to perform bulk ip lookup

Step 2. Select IP Address as the Enrichment Type, and then the column to enrich, which in this case is “IP Address”. Next, check the box for GEO IP. Now we are ready to run the enrichment by hitting Apply. It’s that simple!

ready to execute bulk ip lookup using the Gigasheet GEO IP Enrichment

Step 3. Gigasheet will run the GEO IP Enrichment on your column containing IP Addresses and insert the following information into your sheet, if available:

  • Country
  • Country Code
  • City
  • County
  • Region
  • Latitude
  • Longitude
  • GEOHASH

As you can see, I have IP addresses from all over the world in my list.

Gigasheet sheet with the results of bulk ip lookup using the Gigasheet GEO IP Enrichment
Try it Out

The ease of a spreadsheet with the power of a data warehouse.

No Code
No Training
No Installation
Sign Up, Free Forever