[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

How to get General and Geolocation information for many IP addresses.

Posted on 2016-12-13
1
Medium Priority
?
611 Views
Last Modified: 2016-12-24
I have a list of over 2000 IP addresses in an Excel sheet that I would like to get the General and Geolocation for each one.  It would be great if it got populated into a column in the excel sheet.  The following web site has an example of the type of data that I am trying to collect:

http://whatismyipaddress.com/ip/

It works great, but it only does one at a time.  Does anyone have an idea on how to automate this?
0
Comment
Question by:rye004
1 Comment
 
LVL 37

Accepted Solution

by:
bbao earned 1500 total points
ID: 41924827
try this site.

How to get Public IP from Linux Terminal?
https://www.blackmoreops.com/2015/06/14/how-to-get-public-ip-from-linux-terminal/
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

591 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question