How to input a list of websites, and it output list of IP's?

Question

Does anyone know of a way to simply output a website's IP address, that could be input in an excel sheet? Ex. www.cnn.com www.google.com www.superuser.com

IP1 IP2 IP3

Something in cmd would be fantastic.

Answer 1

NirSoft's FastResolver tool seems to do exactly what you want.

Type in a list of hostnames you want to get IPs for:

It will return the resolved IPs for the hostnames:

You can then copy & paste the returned data directly into Excel, or you can get an HTML report (in a table) for it.

You can also save the results in a variety of formats using the Save Items option:

You could save as CSV and open that with Excel, saving it in the format you desire.

It also works the other way (convert IP to hostname). You can also search a range of IPs and it will resolve the hostnames for those as well (useful for a local network!).

Answer 2

echo off  
cls  
set /p input= Website:  
for /f "tokens=1,2 delims=[]" %%A in ('ping /n 1 /w 1 %input% ^| find "Pinging"') do set ipaddress=%%B  
cls  
echo %ipaddress%  
pause > nul  

to loop the script, just do this:

echo off  

:loop  
cls  
set /p input= Website:  
for /f "tokens=1,2 delims=[]" %%A in ('ping /n 1 /w 1 %input% ^| find "Pinging"') do set ipaddress=%%B  
cls  
echo %ipaddress%  
pause 

goto loop  

Also, 'grep' should work for pulling a list of domains from a .txt. Just capture each line as a workable variable:

set site1=www.google.com  
set site2=www.whatever.com

for /f "tokens=1,2 delims=[]" %%A in ('ping /n 1 /w 1 %site1% ^| find "Pinging"') do set ipaddress=%%B   

You'll have to play around with your script a little bit..