IP to Country Region City Excel Converter
Originally published: 05/11/2019 10:14
Publication number: ELQ-95973-1
View all versions & Certificate

IP to Country Region City Excel Converter

Excel tool to find Country, Region and City for a list of IP4 addresses very quickly.

Determining the geographical locations of a website's visitors may help a website owner or SEO specialist analyze website traffic and plan an SEO campaign accordingly.

This easy-to-use "IP to Country-Region-City Excel converter" provides a handy way to find countries from a bulk list of IP addresses within a second. This converter has a database of around 3 million rows of IP ranges assigned to different countries, regions and cities, so it works without an Internet connection and provides results in a second.

The user needs to input single or all IP4 addresses in separate rows in column A and converter will display their countries, regions and cities in corresponding rows in column B,C and D respectively. It also checks for any invalid IP4 address and displays message accordingly. The User can clear the IP list in column A by clicking on "Clear IP List" button, which runs a simple macro. In order to use this macro, user needs to enable the macro at the time of opening the file. However, if the user doesn't prefer to enable macro, converter will still work and show the countries,regions and cities for all the IP addresses except clearing the IP list in column A.

The converter is ready to show 1000 results, which can easily be extended by the user as per their requirement.

This Best Practice includes
1 Excel file

Acquire business license for $12.00

Add to cart

Add to bookmarks


Further information

To find geographic locations for a bulk list of IP4 addresses instantly.

0.0 / 5 (0 votes)

please wait...