Imagine this –
You run a SaaS company with thousands of users worldwide.
Next month, you're planning to host an event in New York City and are looking to invite your users.
So, you go ahead and roll out an invitation email to every single user in your database.
Yay! That’s great.
But there's just one mistake you made here.
If you’re planning to host an event in New York City, it doesn’t make sense to roll out an invitation email to users based in Asia or Europe, or other parts of the world far away from New York.
Most SaaS companies, during sign-up, ask their users only for their name, email address, and payment information.
They don’t really require their users to share their location.
This means - you probably don’t know where your users are based.
Is that a bad thing? Not necessarily.
But what if you want to personalize your marketing campaigns based on the location of your customers when you don’t have access to their location in the first place?
How can you determine their location? The answer is simple: IP Address Lookup.
All you need is your customers’ IP addresses to personalize your marketing campaigns based on location. So – whether you want to invite your customers based in New York to a local event or run hyper-personalized advertisements, IP targeting is the way to go.
NOTE - If your customers are using VPN, then IP lookup tools will not be able to determine your customers’ location, but for the vast majority of internet users, it works great!
In the next section, we will show you how to get your hands on your customers’ location via their IP address lookup.
These tools are brilliant. All you need to do is enter the IP address and you’ll get access to Internet Service Provider, Country, City, Hostname, Region/State, and Area Code in no time.
Here’s an example:
However, what if you want to look up thousands of IP addresses at the same time? If you have thousands of users, it doesn’t make sense to look up every single IP address one by one.
We generated 5,000 Random IPs to learn how well these tools work using IPVOID Random IP Generator. Below are the results of bulk IP address lookup from several popular tools.
We pasted all 5,000 IP addresses to InfoByIP Domain and IP Bulk Lookup Tool to see whether it fetches us the locations of all 5,000 IP addresses or not.
However, as we expected, InfoByIP Domain and IP Bulk Lookup Tool only processed 100 IP addresses out of the 5,000 we provided them with.
And to our shock, we couldn’t even add all 5,000 IP addresses. The tool took only 3,501 IP addresses as input, of the 5,000 we pasted.
However, it only returned geo locations for 100 records. What!?
We tried performing the same set of actions and found out that no free Bulk IP Lookup tool allows its users to look up thousands of IP addresses at once.
Maximum of 100 IP's at once!
The limit is 100 again!
No free Bulk IP Lookup tool allows its users to look up thousands of IP addresses at once.
However, there is one tool that allows user to look up a billion IP addresses at once using our IP Address Enrichment feature.
You read it right... a billion. And it's free!
To show our IP Address Enrichment feature in action, we generated 100,000 random IP addresses via IPVOID Random IP Generator.
Now, we copied and pasted them to a blank Excel Workbook – which we named “Gigasheet IP Address Enrichment.”
We named our first column “IP Addresses” – which is why it shows “100,001” entries. Now, we uploaded this workbook to Gigasheet.
Haven’t tried out Gigasheet before? Click here to sign up.
Next, we uploaded our file to Gigasheet.
Inside the Gigasheet dashboard, click on +NEW -> File Upload.
With Gigasheet, you can upload spreadsheet files in different formats – from CSV to LOG to JSON to ZIP – Gigasheet processes files in different formats. And the best part is – you can either upload your file from your device or import your files from Google Drive, Dropbox, OneDrive, and many other sources. Gigasheet also allows its users to
Since we saved my Excel workbook on my local computer, we’ll directly upload my file to Gigasheet.
Gigasheet automatically created a folder with my file inside it.
We clicked on the file to load it inside Gigasheet. Here’s what it looks like:
Now, let’s look up all these IP addresses at once inside Gigasheet.
To do that, click on “Insert.” Next, select “Enrichments.” Now, you’ll see a Data Enrichment popup where you need to select “IP Address” as the enrichment column and tick-mark on the “GEO IP” under Service Options.
Here’s a GIF explaining the process:
Gigasheet will take a few seconds to process your request and as soon as it’s done – you’ll have hands on:
These columns show up in the Column List:
As well as in the sheet:
Now, let’s play around a bit.
Oh, did we tell you that you can use Gigasheet to filter or group your data? Not only is Gigasheet useful for looking up IP Addresses, but it is a powerful data exploration tool.
Let’s say you want to get your hands on the IP addresses of your customers based in the US. To do that, we’ll apply a filter inside Gigasheet:
Here’s the filter we applied:
And here are the results:
That’s how we find out IP addresses of customers based in the United States. Now, we can use these IP addresses to find out their email addresses. This way, we can know which customers to send an invitation email to or for other purposes. If you want to search by region, you can also do that – like for example, Chicago or Los Angeles.
And you can also group your data using the “Group” feature.
Let’s group our data by Geo Country:
And it’s done.
Let’s click on “China” to get our hands on the IP addresses of customers based in China.
Now, you can also add another layer of grouping. Let’s add another layer as “GEO REGION.”
Now, if we want to get our hands on IP addresses of our customers based in Chicago, all we need to do is expand the “America/Chicago” column: