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.

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

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!

‍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.